db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Jdo Wiki] Update of "SquirrelSqlClient" by MichelleCaisse
Date Tue, 11 Oct 2005 23:57:18 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Jdo Wiki" for change notification.

The following page has been changed by MichelleCaisse:

New page:
= 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.Embedded``Driver'''||
||Extra Classpath||Location of your derby jar file, e.g. '''c:/Documents and Settings/gwb/.maven/repository/org.apache.derby/jars/derby-'''||
||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:

 1. Select Drivers/New Driver
 1. Select the Extra Class Path tab.
 1. Click Add.
 1. Enter the Extra Classpath in the text box or navigate to your Derby jar file.
 1. Click Open.
 1. Enter the driver name in the Name text box.
 1. Enter the Example URL in its text box.
 1. Enter the Class Name in its text box.
 1. Click OK.
Then define an Alias:
 1. Select Aliases/New Alias.
 1. Enter the Alias name in the Name text box.
 1. Select the driver you defined from the drop-down box.
 1. Enter the URL in its box.
 1. Enter the user name in its box.
 1. Enter the password in its box.
 1. Click Test to test the connection.
 1. 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. 

View raw message