How to add a JDBC driver

This procedure assumes you are creating a new JDBC data source, and you need to install a new driver because the driver that the database requires is not available in the list of drivers.

1	In New JDBC Data Source Profile, shown in Figure 2-4, choose Manage Drivers.

Figure 2-4  New JDBC Data Source Profile

2	In Manage JDBC Drivers, choose Add to install the JAR file that contains the driver.

3	Navigate to the directory that contains the JAR file. Select the JAR file and choose Open. Manage JDBC Drivers shows the new JAR file.

4	Choose Drivers to see the list of installed drivers, as shown in Figure 2-5.

Figure 2-5  Viewing JDBC driver classes

5	Optionally, set the properties for a driver, using the following steps:

1	Select the new driver, then choose Edit.

2	In Edit JDBC Driver, specify the following information:

In Driver Display Name, type a user-friendly name that describes the driver. This name appears in parenthesis next to the driver class name in Driver Class on New JDBC Data Source Profile.

In URL Template, type the URL format that the driver requires. This URL format appears in Driver URL on New JDBC Data Source Profile.

Figure 2-6 shows an example of properties specified for a MySQL JDBC driver.

Figure 2-6  Properties specified for a JDBC driver

3	Choose OK. Manage JDBC Driver displays the new display name and URL template syntax suggestion.

6	In New JDBC Data Source Profile, specify the connection properties to connect to the JDBC data source. The Driver Class list displays the installed driver.