Creating database connection using Eclipse Data Source Explorer

Data Source Explorer included in Eclipse supports lots of database connection. Sometimes it is useful when checking inconsistent database state, otherwise, people have to lauch separate dedicated application, causing annoying stuff like login, querying and so on.

Once you create connection profile as to DB, just clicking the button  frees you from annoying things.

Pictures below shows overall steps for a new database profile.

clicking new...

clicking new button proceeds with next step.

will create new Derby Connection Profile

click next

Currently, no profile for Derby is found, and so we will define a new driver template.

jar/zip is required to define db connection.

Driver listing is shown, but in order to make it work,  a right driver class file ( *.jar) should be specified.
clcking tab "Jar List" show driver registration window.

that is not real.

String "derby.jar" never means a correct connector. To get it work, click Button "Edit JAR/Zip..." and then select a proper connector.

derby.jar for javaDB(Apache DB).

After selecting *.jar, the full file path is shown instead of the fake "derby.jar" string.

click "OK". new Driver Template has been made, and we can create connection to Derby using it.

driver, database location and connection url

The Driver name, "Derby Embbedded JDBC Driver" is selected and connection url is show. A new database is created at "C/Users/y**ri/MyDB" named with MyDB. You can change the path and db name as you wish.

Before clicking "Finish" button, be sure to test the settings.

configuration succeded.

Once first connection succeed, following test could fail because of the url option "create=true".(try to uncheck the"create database" option)

summary about configuration

database "MyDB" is shown

This is applied to others.