Previous Page Next Page

JDBC Connection Plugins

JReport Designer provides connection plugins for the most commonly used relational databases: Oracle, MySQL and MS SQL Server, to include the JDBC drivers required for these databases for an easy connection setup procedure.

A connection plugin can have its own driver, configuration dialog and logo. The configuration dialog defined in a plugin can be used to create a connection to the database and can get driver from the plugin.

To set up a JDBC connection to connect to the Oracle/MySQL/SQL Server database via plugin:

1. Do one of the following:
   • On the Start Page, click Oracle, MySQL or SQL Server in the Connect category. In the Create Connection dialog, specify an existing catalog or create a new one and click OK.
   • In the Catalog Manager, right-click a data source and select New JDBC Connection from the shortcut menu, then click Oracle, MySQL or SQL Server in the Select Connection Type dialog.
   • In the Catalog Manager, select a data source and click New Data Source on the toolbar. In the New Data Source dialog, specify the name of the data source, then select the Oracle, MySQL or SQL Server connection type and click OK.

   The Connect to Oracle/Connect to MySQL/Connect to SQL Server dialog appears.

   

2. The Driver drop-down list displays the driver included in the connection plugin by default.
3. For Oracle, from the Connection Type drop-down list choose whether to use ServiceName, SID, or TNSName to connect to the database. Then in the text box of Service Name/TNS Name which corresponds to the connection type, specify the service name or TNS name of the database instance.

   For SQL Server and MySQL, you need to specify the name of the database or schema in the Database text box.

4. In the Server text box, specify the host name or IP address of the database server.
5. Specify the port of the database server in the Port text box.
6. Specify the user ID and password used for accessing the database.
7. If you want to use URL to specify the connection information, select the Show URL checkbox and then configure the necessary information. To test whether the specified information is workable, click the Test Connection button.
8. If your database has some special requirements, you can click the More Options button to modify the options according to your requirements.
9. Click OK and the connection will be added in the specified catalog in the Catalog Manager.

   You can then add DBMS objects from the database into the JReport catalog via the connection.

Previous Page Next Page