Xathrya Sabertooth

Exploring MySQL Database with SQL Explorer Plugin for Eclipse

Posted: 06 Jul 2013 10:26 PM PDT

In previous article, we have discuss how to explore SQLite database using third party program, SQLite Manager on Mozilla Firefox. Now let’s cover another DBMS, MySQL.

In this article we will discuss about installation of SQL Explorer plugin for Eclipse. For this purpose I use:

Slackware64 14.0
Eclipse Juno
SQL Explorer 3.6.1

However, unless you are not using Eclipse, the Operating System should give no problem.

Prerequisite

MySQL DB

If you have not installed MySQL, please read related article first. This article will use assumption you have installed MySQL on your system.

Obtain the Material

SQLExplorer can be downloaded from it’s download page (SourceForge): http://sourceforge.net/projects/eclipsesql/files/SQL%20Explorer%20Plugin/3.6.1/

The one we use is the 3.6.1 release, or you can direct download here.

Next is MySQL Connector Java. This will act as connector so the plugin can communicate to MySQL database. Download the connector from it’s download page: http://dev.mysql.com/downloads/connector/j/

At this point we have two package:

sqlexplorer_plugin-3.6.1.zip
mysql-connector-java-5.1.25.tar.gz (or mysql-connector-java-5.1.25.zip if you prefer to)

Installation

Open up terminal and go to your download page (place you have all the materials we need) then invoke these commands:

  unzip sqlexplorer_plugin-3.6.1.zip  cp -R features plugin <eclipse path>

Replace the <eclipse path> with your actual eclipse installation path.

Next, we need to install the connector.

  tar -xf mysql-connector-java-5.1.25.tar.gz  cd mysql-connector-java-5.1.25  cp mysql-connector-java-5.1.25-bin.jar /usr/share/mysql/

Now open up Eclipse and there should be a new perspective SQL Explorer.

Proyek Teknologi

Selasa, 09 Juli 2013