Previous TopicNext Topic


How to specify an additional JDBC driver

The following procedure starts by creating a new data source to access the features required to manage JDBC drivers. If you have an existing data source, you can add JDBC drivers by initiating an edit of the data source to access the features described in this procedure.

  1. Use a file manager to copy the JAR files that contain the JDBC drivers you want to use to the following directory in your BIRT Report Designer installation:
  2. C:\eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_2.0.0\drivers 
    
    If you do not copy the JAR file to this location, you will have to restore the driver whenver you want to use it.
  3. In BIRT Report Designer, open or create a project and a report design.
  4. Choose Data Explorer.
  5. Right-click Data Sources, then choose New Data Source from the context menu.
  6. New Data Source--Select a Data Source type appears.

  7. Identify the type of data source as JDBC:
    1. In Data sources, select JDBC Data Source.
    2. In Data Source Name, type a name for the data source or accept the default name.
    3. You do not need to create a BIRT Report Designer data source to add a JDBC driver but the name in this field must be unique in the current report design.
    4. Choose Next.
    5. New Data Source--New Data Source appears.

  8. In New Data Source--New Data Source, choose Manage Drivers.
  9. Manage JDBC Drivers--JAR Files appears.

  10. Add the JAR files for the additional JDBC driver:
    1. Choose Add.
    2. Open appears.
    3. Navigate to the directory with the driver class file, select the driver JAR file and choose Open.
    4. Manage JDBC Drivers--JAR Files appears, showing the new driver class.
  11. Choose Drivers.
  12. Manage JDBC Drivers--Drivers appears.

  13. Specify the properties for a driver:
    1. Select the new driver.
    2. Choose Edit.
    3. Edit JDBC Driver appears.

    4. Specify settings for the JDBC driver:
      • In Driver Display Name, type a name you want to display for this driver on the Display Name column of Manage JDBC Drivers--Drivers.
      • In URL Template, type the syntax suggestion you want to display for this driver in Database URL on New Data Source--New Data Source.
      Choose OK.
      Manage JDBC Drivers--Drivers appears, displaying the new display name and URL template syntax suggestion.
  14. Choose OK.
  15. New Data Source--New Data Source appears. If you choose the driver you specified in Edit JDBC Driver, BIRT Report Designer displays the URL template syntax suggestion you provided.

(c) Copyright Actuate Corporation 2006

Previous TopicNext Topic