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 Creating a JDBC data sourceFigure 2-3 Defining JDBC connection information
1 In Driver Class, choose a driver class from the drop-down list. If you do not see the driver class that you need, add the driver as described later in this section.
2 In Database URL, type the URL for the database, using the format that the driver requires. For a MySQL database, for example, the format is
3 In User Name, type a valid user name to connect to the JDBC data source. This field can be left blank if the data source does not require a user name.
4 In Password, type a valid password to connect to the JDBC data source. This field can be left blank if the 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 2012 |