Installing Jadclipse in Eclipse

Today I am going to show you how to install and use Jadclipse. Jadclipse is eclipse plug-in that integrates Jad (Java decompiler) with Eclipse.

  • First you require Jad for decompiling java files. You can find a list of mirrors on this site where you can get JAD for various platforms. Download it and unzip into any folder on your hard drive.
  • Next download the Jadclipse plug-in jar file from here and place the jar file in your eclipse plugins folder
  • Restart your eclipse. If eclipse didn’t recognize the plug-in then launch eclipse with -clean flag.

eclipse -clean

  • Configure the path to the Jad executable in eclipse under Window > Preferences… > Java > JadClipse > Path to Decompiler.
  • Set the full path of the jad executable, e.g. C:\Program Files\Jad\jad.exe
  • Go to Window > Preferences… > General > Editors > File Associations and make sure that the JadClipse Class File Viewer has the default file association for *.class  files.
Jad preferences
Jad preferences in eclipse running under mac.
file association
file association

Now everything is done. If you want to view the source for any class then simply ctrl+click on that class then the source for that class will be showed in your eclipse editor.


Reading from CLOB in java through JDBC

Here is a code snippet that I have used to read from a CLOB, Oracle 10g instance.

PreparedStatment ps = connection.prepareStatement
("SELECT clobcolumn from clobtable");
ResultSet rs = ps.executeQuery();
oracle.sql.CLOB clobValue = (oracle.sql.CLOB)rs.getCLOB(1);
BufferedReader reader = new BufferedReader(new
String read = null;
StringBuffer buffer = new StringBuffer();
while((read = reader.readLine()) != null )
Digg This

Installing Eclipse SQL Explorer Plug-in in Eclipse Ganymede (Eclipse 3.4)

This is an updated post for my earlier post Installing Eclipse SQL Explorer Plug-in for installing Eclipse SQL Explorer plug-in in Eclipse 3.4

Eclipse version 3.4
Eclipse SQL Explorer version 3.5.0

Installing using the Eclipse update manager.

  • From the Eclipse menu select Help->Software Updates…

  • Software Updates and Add-ons dialogue box will be displayed. Select the Available Software tab on the top of the dialogue box. Now Click on the Add Site button on the right hand side of the dialogue box.


  • It will search and present you with available software

  • Select the features you want to install . In this case select the branch, it will also install the patch and click on the Install button on the top right hand side.
  • It will check for dependencies if any and will present to you what all you need to install.

  • Confirm the plug-ins you want to install and click next

  • Accept the license agreement and click on Finish.

After the installation is done it will ask to restart the workbench, restart the workbench. To open the Eclipse SQL Explorer perspective from the menu select Window->Open Perspective->Other. From the list of perspectives select Sql Explorer and click on ok, you will be switched to SQl Explorer Perspective.

Technorati Tags: , ,

Configuring SQL Explorer Plugin

We will configure the SQL Explorer Plug-in & connect to the database. I will be using MySql server. It will be almost the same for all the databases. If you have not yet installed the plug-in please see my post on Installing Eclipse SQL Explorer Plug-in.

  • From the eclipse menu, select window->preferences
  • In the preference dialog box, select the SQL Explorer node.
  • Select the JDBC Drivers node.
  • Select the Driver you want to configure. We will configure MySQL Driver. So select the MySQL Driver & click edit on the right hand side.
  • Select the “extra class path” tab in the change dialog box.
  • Add the MySQL Connector jar file by clicking on add button. You can download the connectors from MySQL site. You can download it directly from here.
  • Once you added the jar file click on List Drivers on the right hand side. You can see all the loaded drivers. Select the one appropriate to you.
  • Enter the URL of your MySQL Server in the Example URL text box. Something like this “jdbc:mysql://localhost:3306/test”. Here “test” is the database name & enter the url without quotes.
  • Click ok to finish the installation of the driver. You should be able to see a green tick mark for the driver we just installed.

Now we will connect to the database.

  • From the eclipse menu, select window->Open Perspective->other.
  • In the Open Perspective dialog box select SQL Explorer & click ok.
  • Eclipse will be switched to SQL Explorer perspective.

Installing Eclipse SQL Explorer Plug-in

For installing SQL Explorer plug-in in eclipse 3.4 go to this updated post Installing Eclipse Explorer Plug-in in Eclipse Ganymede (Eclipse 3.4).

Today I am going to show you how to install SQL Explorer plug-in in eclipse.

There are two ways to install.

  1. Download the distribution
    file and unzip it into your Eclipse installation.
  2. Use the Eclipse Update

Installing using the Eclipse Update Manager

  • From the Eclipse menu,
    select Help->Software Update->Find and Install. You will be
    displayed with a Install/Update dialog box.
  • Select Search for new
    features to install radio button & click next.
  • Click on the New Remote
    Site on the right hand side of the Install dialog box
  • Enter the name as “SQL
    Explorer” & “” (without quotes) for
    the url in the New Update Site dialog box and click ok.
  • Select the SQL Explorer
    site in the Install dialog box and click finish.
  • Once the search is
    finished, it will present with the features to install.
  • Select the features you
    want to install. In this case select SQL Explorer branch & click next.
  • Accept the license
    agreement & click next.
  • Select the install location
    where you want to install this plug-in. By default it will be installed
    into the eclipse plug-in directory. If you want to add another location
    click on the change location button on the lower right hand corner and
    specify the directory where you want to install. Once you are finished
    with the selections click on finish button.