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 On New JDBC Data Source Profile, shown in Figure 2‑4, choose Manage Drivers. Figure 2‑4 New JDBC Data Source Profile 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 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 5 Specify the properties for a driver, using the following steps: 1 Select the new driver, then choose Edit. Edit JDBC Driver appears, as shown in Figure 2‑7. Figure 2‑7 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 Manage JDBC Drivers. 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 Choose OK.
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.