Previous Next

How to specify the connection information for a database or other JDBC data source

1  
2  
1  
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 source

Figure 2-2  Creating a JDBC data source
3  
New JDBC Data Source Profile appears, as shown in Figure 2-3.

Figure 2-3 Defining JDBC connection information

Figure 2-3  Defining JDBC connection information
3  
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
jdbc:mysql://<host>:<port>/<database>
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  
java:comp/env/jdbc/MyDataSource
In the example, MyDataSource is the name of the JNDI database service.
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.
5  

(c) Copyright Actuate Corporation 2011