Previous Next

Connecting to a Data Source : About BIRT data sources : How to add a JDBC driver

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 your database requires is not available in the list of drivers.

1

Figure 2-4 New JDBC Data Source Path

Figure 2-4
2
On Manage JDBC Drivers, shown in Figure 2‑5, choose Add to install the JAR file that contains the driver.

Figure 2-5 Managing JDBC drivers

Figure 2-5
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. BIRT Report Designer copies the JAR file to the Eclipse JDBC directory.
4
Choose Drivers to see the list of installed drivers, as shown in Figure 2‑6.

Figure 2-6 Viewing JDBC driver classes

Figure 2-6
5
Specify the properties for a driver, using the following steps:
1

Figure 2-7 Editing a JDBC driver URL template

Figure 2-7
2
1
2
In URL Template, type the syntax suggestion that appears for this driver in Database URL on New JDBC Data Source Profile.
Choose OK. The driver manager displays the new display name and URL template syntax suggestion.
6

(c) Copyright Actuate Corporation 2008