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.