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:

o	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.

o	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.