Product specifications

5.3.3 To create a JDBC connection with Extensions

In order to create a JDBC connection:

• Obtain the necessary JDBC driver software for the database, and copy the files to your system.

These files are available from the database vendor. The driver software consists typically of one or

more JAR files.

• Ensure that you have the database access details to hand, for example the login and password

details.

Go to the next section of the guide to find the Extensions parameter values.

Use one or more of the Extensions parameter values to create your own driver directories.

For example, Extensions parameter values for MS SQL Server 2005 middleware are sqlsrv2005,

sqlsrv and jdbc in the sqlsrv.sbo file. You can create any of the following directories:

• connectionserver-install-dir\connectionServer\jdbc\drivers\sqlsrv2005

• connectionserver-install-dir\connectionServer\jdbc\drivers\sqlsrv

• connectionserver-install-dir\connectionServer\jdbc\drivers\jdbc

Copy the JAR files into the directories of your choice.

Run the connection wizard.

The JDBC driver that you have configured appears in the list of available connections.

Select the JDBC driver and use the wizard to configure the connection.

To load JDBC drivers, Connection Server searches for JAR files in each directory from the most specific

to the least specific until it finds them. The connection is then available for use.

Example:

For example, if you store JAR files in connectionserver-install-dir\connectionServer\jd

bc\drivers\sqlsrv only, then Connection Server first searches for drivers in sqlsrv2005 directory,

finds it empty, then it searches in sqlsrv directory, finds the JAR files and loads the driver.

Note:

Because sqlsrv is Extensions value of all MS SQL Server target databases, JAR files specified

in this directory are loaded for all MS SQL Server databases.