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:
Then define an Alias:
Finally, connect by selecting your Alias from the Connect drop-down box on the Alias tool bar. Click Connect from the pop-up dialog.