Eclipse Configuring SQL Explorer plug-ins and databases

1, download SQL Explore plugin, address: http://www.sqlexplorer.org/, download third, copy to eclipse plugin corresponding directory restart, download RCP plugin can use EXE directly

2, download the JDBC driver, address: http://www.mysql.com/products/connector/, I use MySQL, download the red line

3. Restart Eclipse to open the SQL Explore view (perspective)

A) The view of SQL Explorer on the left side of the new open is blank because no database driver is configured

b) Configure JDBC,

Open the Create New Connection Profile button in Connections view

The dialog of Create New connection appears

c) Click the Add/edit Drivers button to enter the database driver, as

The left side of the diagram is open, you can choose Add a custom connection, you can also edit in the original, we choose Add to add a driver named Mysqldriver, in the extra Class path sub-bar click Add JARs, Select the previously downloaded JDBC jar package, Driver Class name is called Com.mysql.jdbc.driver,example URL set to jdbc:mysql://localhost/, here I do not set the port number, The default should appear to be 3306, if you need to configure the port number can look at some other default configuration of the wording, so that the JDBC driver is done.

D) Go back to the Create New Connection dialog box in the connection sub-bar view, creating a name called MySQL, which drives the selection of the Mysqldriver database driver we just configured, Here the URL of the database will automatically follow the Mysqldriver configured URL, select the user as root. ok~

After OK, we can see the results in the connection view.

Right-click MySQL Select Connect

The default is to configure the local MySQL, fill in the password, and then on the right side of Eclipse to see the View database structure,root user SQL is displayed, very simple configuration process, I can continue to see Hibernate went

Eclipse Configuring SQL Explorer plug-ins and databases