#### How to add a JDBC driver

If you have an existing JDBC data source, you can add JDBC drivers by editing the data source.

1. In BIRT Report Designer, open an existing report design.
2. Choose Data Explorer.
3. Right-click an existing JDBC data source, then choose Edit from the context menu. Edit Data Source appears, as shown in Figure 2-10.

Figure 2-10 Adding a JDBC driver
4. Choose Manage Drivers. The JDBC driver manager appears, a s shown in Figure 2-11.

Figure 2-11 Managing JDBC drivers
5. To add the JAR files for the additional driver, choose Add, then navigate to the directory that contains the driver class file. Select the driver JAR file and choose Open.
The driver manager appears, showing the new driver class. BIRT Report Designer copies the JAR file to the Eclipse JDBC directory.
6. Choose Drivers to see the Drivers page, as shown in Figure 2-12.

Figure 2-12 Viewing JDBC driver classes
7. Specify the properties for a driver:

1. Select the new driver, then choose Edit. Edit JDBC Driver appears, as shown in Figure 2-13.

Figure 2-13 Editing a JDBC driver URL template
2. Specify settings for the JDBC driver:

1. In Driver Display Name, type a name that appears in the Display Name column in the driver manager.
2. In URL Template, type the syntax suggestion that appears for this driver in Database URL on New Data Source.

Choose OK. The driver manager displays the new display name and URL template syntax suggestion.

8. Choose OK. Edit Data Source appears.