SQuirreL
SQuirreL is an SQL client that can be used with any JDBC compliant database. It allows you to view database entities and execute SQL commands. More information is available at http://www.squirrelsql.org/. To download and install SQuirreL, follow the instructions at http://www.squirrelsql.org/#installation.
To use SQuirreL with Derby, you will need to configure SQuirreL with the following values:
derby.system.home |
Where your Derby database is located. For the JDO TCK, it is under tck20/target/database/derby, e.g. c:/myLocalTCKRepos/jdo/trunk/tck20/target/database/derby |
database name |
Whatever it is. For the TCK, it is jdotckdb. |
Driver Name |
Your choice, e.g. Derby-embedded for the embedded driver |
Example URL |
jdbc:derby:<path_to_derby.system.home><dbname> (Use this literal text; you will replace the placeholders when you set up the alias.) |
Class Name |
org.apache.derby.jdbc.EmbeddedDriver |
Extra Classpath |
Location of your derby jar file, e.g. c:/Documents and Settings/gwb/.maven/repository/org.apache.derby/jars/derby-10.1.1.0.jar |
Alias Name |
Your choice, e.g. jdotckdb |
URL |
The driver example URL with the placeholders replaced, e.g. jdbc:derby:c:/myTCKRepos/jdo/trunk/tck20/target/database/derby/jdotckdb |
User Name |
For the TCK, this is tckuser. |
Password |
For the TCK, this is tckuser, the same as the User Name. |
To configure SQuirreL, define a Driver:
- Select Drivers/New Driver
- Select the Extra Class Path tab.
- Click Add.
- Enter the Extra Classpath in the text box or navigate to your Derby jar file.
- Click Open.
- Enter the driver name in the Name text box.
- Enter the Example URL in its text box.
- Enter the Class Name in its text box.
- Click OK.
Then define an Alias:
- Select Aliases/New Alias.
- Enter the Alias name in the Name text box.
- Select the driver you defined from the drop-down box.
- Enter the URL in its box.
- Enter the user name in its box.
- Enter the password in its box.
- Click Test to test the connection.
- Click OK to save the Alias and close the dialog.
Finally, connect by selecting your Alias from the Connect drop-down box on the Alias tool bar. Click Connect from the pop-up dialog.