Problem:

The Relativity JDBC driver is shipped with the Relativity Data Server. Also, a small Java application, DBSample, is included to test the JDBC connection. However, DBSample provides only a small amount of information that may be obtained from a JDBC connection.

Resolution:

SQuirreL SQL Client is an open source tool available from SourceForge. A PDF document is available which describes the many uses of SQuirreL SQL Client. See Related Links at the right for more information.

Follow these steps to configure SQuirreL SQL Client for a Relativity Data Server JDBC data source.

1. Copy the Relativity JDBC driver, RelJDBC.jar, from the distribution media to a convenient location.
2. Following the instructions found on SourceForge, download and install SQuirreL SQL Client.
3. Start SQuirreL SQL Client.
4. Click on the Drivers tab. A large list of drivers is displayed.
5. Click on the button to add a driver.
6. Provide a name for the driver, for example “Relativity JDBC Client” (without quotes).
7. Enter ‘jdbc:relativity:servername:port/DSName’ (without quotes) in the Example URL text box.
8. Click on the Extra Class Path tab and then click Add.
9. Browse to the location of the Relativity JDBC driver (determined in step 1 above) and click open.
10. In the Class Name text box, type “relativity.jdbc.Driver” (without quotes). Note that this is a case-sensitive entry.
11. Click OK to save the new driver entry. The Relativity JDBC Client entry should appear in the list of drivers.
12. Click on the Aliases tab. You must provide an alias which contains the connection information for your Relativity Data Server data source.
13. Click on the button to add an alias. The Add Alias dialog will appear.
14. Provide a name. You will use this name when connecting to the data source.
15. For Driver, select the Relativity JDBC Client (named in step 6 above).
16. For URL, provide the URL for the Relativity Data Server data source in the following format:

    jdbc:relativity:servername:port/DSName

    where servername is the name of the server hosting Relativity Data Server, port is the port being used by Relativity Data Server (the default installation uses port 1583), and DSName is the server data source name. (jdbc, relativity, colons and the slash are literal characters.)

17. If necessary for the data source, supply User Name and Password.
18. Click OK to save the Alias definition.

Now that an Alias has been created, you may connect to the data source and use the features of SQuirreL SQL Client.

http://squirrel-sql.sourceforge.net/

Date:
 
Name:
 
Description of change: 
Date:
 
Name:
 
Description of change: