Example 1: Setting up a connection via the Oracle JDBC driver

Assume that:

• You have already installed the Oracle JDBC driver, and have appended the archive file (ojdbc6.jar) of the thin driver to the ADDCLASSPATH variable in the file setenv.bat in <designer_install_root>\bin.
• The Oracle database server is with the name p02_wuhb, port number 1521, database orcl, user name scott and password tiger.
• A catalog has been created with a default data source.

Take the following steps to set up a connection which connects JReport Designer to a database via the Oracle JDBC driver:

1. Start JReport Designer and open the catalog.
2. In the Data tab of the Catalog Browser, expand the node of the default data source, right-click the Relational node and select Add JDBC Connection from the shortcut menu.
3. In the Get JDBC Connection Information dialog, uncheck the Use ODBC Data Source option.
4. Check the Driver checkbox, and enter the JDBC driver class name oracle.jdbc.OracleDriver in the Driver text field.
5. In the URL text field, specify the URL in the format jdbc:oracle:thin:@<hostname>:<port>:<SID>. In this example, enter jdbc:oracle:thin:@p02_wuhb:1521:orcl.
6. Input the user name scott and password tiger respectively.
7. Click OK to set up the connection.