How to specify the connection information for a database or other JDBC data source
2 In Data Source Name, type a name for the data source. The name must be unique in the current report. Figure 2‑2 shows a default data source name.
Figure 2‑2
Figure 2‑3
1 In Driver Class, choose a driver class from the drop-down list. If you do not see the driver class that you want to use, add a driver as described later in this section.
2 In Database URL, type the database URL, using the syntax that the driver requires. Typically, BIRT Report Designer displays the necessary syntax in Database URL. For a Sun JDBC/ODBC bridge, for example, the syntax iswhere <data source name> is the name of your data source. For example, the following URL identifies the sales database:
3 In User Name, type the user name to use when connecting to the JDBC data source. This field can be left blank if your data source does not require a user name.
4 In Password, type the password to use when connecting to the JDBC data source. This field can be left blank if your data source does not require a password.
5 In JNDI URL, type the full path to the connection pooling service, if applicable. The following path is an example:
4 To ensure that the connection information is correct, choose Test Connection. If Test Connection returns an error, repeat the preceding steps to correct the error. Then, test the connection again.
(c) Copyright Actuate Corporation 2009 |