23/11/2011 9 Comments
Update: As I switched to Linux Mint, I ran into an permission problem. To have it working, follow the procedure available at http://community.linuxmint.com/tutorial/view/938, which provides additional steps.
On my current project, we use Oracle database. The best free tool I have found so far to work with the database as a Java developer is Oracle SQL Developer.
Oracle does not provide a package for Debian based distros. I tried to run the tool from the generic archive but it failed to run because it seems to be aiming at another environment with respect to the Swing look and feel that it failed to load. After some googling, I found that there is a package to make a package (sqldeveloper-package)out of the archive to make it installable as such.
Here is how to use it.
Download Oracle SQL Developer
As the download requires that one have an Oracle account, I download it from the browser at the following address: http://www.oracle.com/technetwork/developer-tools/sql-developer/sqldev-ea-download-486950.html
See my post Install Sun JDK 6 on Ubuntu 11.10
Install the sqldeveloper-package and its dependencies
$ sudo apt-get install sqldeveloper-package debhelper
$ sudo apt-get install tofrodos
It is necessary to create the following symlinks for the tool to work:
$ sudo ln -s fromdos dos2unix $ sudo ln -s todos unix2dos
Make the deb package
It seems that the -b switch can be used to indicate where to generate the .deb but it does not seem to work (Or I did not spend enough time trying to get it to work). The tool will generate the .deb in the working directory.
$ cd ~/Downloads $ make-sqldeveloper-package ~/Downloads/sqldeveloper-3.1.06.44-no-jre.zip
Install the package
$ sudo dpkg -i sqldeveloper_3.1.06.44+0.2.3-1_all.deb
The tool is now available in Applications->Programming->Sql Developer