Configuring JDBC Drivers

This section describes how to configure JDBC drivers for database connections in the BWPlugin.properties file. You can also configure JDBC drivers in the DatabaseConnection tab of the iProcess Connection shared resource, see iProcess Connection.

Perform the following tasks to configure JDBC drivers in the BWPlugin.properties file:

• Set Up a JDBC Driver
• Add a JDBC Driver

When the Auto Config check box in the DatabaseConnection tab of the iProcess Connection activity is checked, the configuration of the JDBC driver is applied after clicking the Test Connection button in the DatabaseConnection tab of the iProcess Connection activity or at runtime if the details of the database connection are changed. For more information, see iProcess Connection.

Set Up a JDBC Driver

You need to set up JDBC drivers in the BWPlugin.properties file, which is located in the TIBCO_HOME\bw\plugins\lib\palettes directory, before connecting a database.

Note: If the JDBC driver for database connection is not set in the BWPlugin.properties file, and the Auto Config check box in the DatabaseConnection tab of the iProcess Connection activity is checked, the TIBCO JDBC driver will be used for database connection.

To set up a JDBC driver, perform the following steps:

1. Find the type of database that is used for database connection in the BWPlugin.properties file. Three types of databases are supported: Oracle, DB2, and SQL Server.
2. Delete all the number signs (#) that begin each command line under the database section. For example, if the Oracle database is used in your database connection, then edit the following command lines: 
#For Oracle
#iProcessPlugin.DefaultDatabaseType=1
#iProcessPlugin.DefaultJdbcDriver=oracle.jdbc.driver.OracleDriver
#iProcessPlugin.DefaultDatabaseUrl=jdbc:oracle:thin:@<HOST>:<PORT>:<CONNECTIONID>
#iProcessPlugin.DefaultDataSource=oracle.jdbc.xa.client.OracleXADataSource

After deleting the number signs (#), the command lines should be:

#For Oracle
iProcessPlugin.DefaultDatabaseType=1
iProcessPlugin.DefaultJdbcDriver=oracle.jdbc.driver.OracleDriver
iProcessPlugin.DefaultDatabaseUrl=jdbc:oracle:thin:@<HOST>:<PORT>:<CONNECTIONID>
iProcessPlugin.DefaultDataSource=oracle.jdbc.xa.client.OracleXADataSource
Add a JDBC Driver

After setting the JDBC driver in the BWPlugin.properties file, you need to add the JDBC driver of the database you required to the TIBCO_HOME\tpcl\version_number\jdbc directory or the TIBCO_HOME\bw\version_number\lib directory. If the jdbc folder does not exist, you need to create a jdbc folder under the TIBCO_HOME\tpcl\version_number directory.