Database Connection

The Database Connection tab has the following fields.

Field

Global

Var?

Description

Connection Type

No

The type of database connection you wish to have. You can select:

• JDBC. Select JDBC if you wish to use a JDBC transaction group. JDBC connections cannot be used if you intend to place iProcess Palette resources within an XA transaction group.
• XA. The XA connection type should be selected if you plan to use the TIBCO ActiveMatrix BusinessWorks Plug-in for iProcess activities that refer to this shared resource in a BusinessWorks XA transaction group. See "Transactions" in TIBCO ActiveMatrix BusinessWorks Process Design Guide for more information about XA transactions.

Max Connections

Yes

The maximum number of database connections to allocate. The default maximum is 10. The minimum value that can be specified is 1.

See "Connection Pooling" in TIBCO ActiveMatrix BusinessWorks Palette Reference Guide for more information about this field.

Login Timeout (sec)

Yes

Time (in seconds) to wait for a successful database connection. Only JDBC drivers that support connection timeouts can use this configuration field. If the JDBC driver does not support connection timeouts, the value of this field is ignored. Most JDBC drivers should support connection timeouts.

Operation Timeout (sec)

Yes

Time (in seconds) to wait for a connection to the iProcess database.

Auto Config

No

This field specifies whether to configure the database connection automatically or manually:

• If this check box is checked, the database connection will be configured automatically. However, you need to configure the JDBC driver for database connection in the BWPlugin.properties file. See Configuring JDBC Drivers for more information.

Note: If the JDBC driver for database connection is not set in the BWPlugin.properties file, the TIBCO JDBC driver will be used for database connection.

The JDBC driver you set up in the BWPlugin.properties file will be used:

— By the Test Connection button.
— At runtime if the database connection details are changed.

Warning:

— The iProcess memos are not compatible with the JDBC Oracle database driver (tibcosoftwareinc.jdbc.oracle.OracleDriver) that is supplied with the TIBCO ActiveMatrix BusinessWorks installation. If you want to use iProcess memos and you are using Oracle as your database type, you must obtain the JDBC driver from Oracle (oracle.jdbc.driver.OracleDriver (oci)), and save the driver in the TIBCO_HOME\bw\plugins\lib directory. See "Database Drivers" in TIBCO ActiveMatrix BusinessWorks Palette Reference Guide for more information.

Auto Config (continuation)

No
— The TIBCO JDBC driver version 2.x is not supported for setting up a connection for Oracle database. Starting a case in TIBCO ActiveMatrix BusinessWorks will be failed if you use the TIBCO JDBC driver version 2.x to set up the connection for Oracle database. To avoid this problem, you can use the TIBCO JDBC driver version 1.x as a substitution or use the JDBC driver supplied by Oracle.
• If this check box is unchecked, the database connection will be configured manually. You need to specify details of the database connection in the Database Connection tab.

The following fields are available if the Auto Config check box is unchecked.

Database Type

Yes

The database used by iProcess Engine. You can specify the name of the database either by entering a database name in this field or by referencing a predefined global variable.

Three types of database are supported in this field:

• DB2
• Oracle
• SQL Server

Note: The spelling of the database name can be either upper case or lower case. If the database name you entered is invalid, an error dialog is displayed to remind you to correct it.

JDBC Driver

Yes

This field is only displayed if you select JDBC from the Connection Type drop-down list.

The name of your JDBC Driver.

Warning:

— If you want to use iProcess memos and you are using Oracle as your database type, you must use the JDBC driver supplied by Oracle (oracle.jdbc.driver.OracleDriver (oci)) rather than the JDBC driver that is supplied with the TIBCO ActiveMatrix BusinessWorks installation. You must obtain this from Oracle. This is because iProcess memos are not compatible with the JDBC Oracle database driver that is supplied with the TIBCO ActiveMatrix BusinessWorks installation. See "Database Drivers" in TIBCO ActiveMatrix BusinessWorks Palette Reference Guide for more information.
— When you use the JDBC driver version 2.x (tibcosoftwareinc.jdbc.oracle.OracleDriver) to set up a connection for Oracle database, starting a case in TIBCO ActiveMatrix BusinessWorks will be failed. This problem will not occur when you use TIBCO JDBC driver version 2.x to set up connections for DB2 and SQL Server database. To avoid this problem, you can use TIBCO JDBC driver version 1.x as a substitution or just use the JDBC driver supplied by Oracle.

JDBC Driver (continuation)

No

The Oracle JDBC driver is used:

• When you select JDBC from the Connection Type list, check the Auto Config check box, and set up the Oracle JDBC driver ((oracle.jdbc.driver.OracleDriver (oci)) as the JDBC driver in the BWPlugin.properties file.
• When you select JDBC from the Connection Type list, uncheck the Auto Config check box, and type the name of the JDBC driver supplied by Oracle in the JDBC Driver field manually in the DatabaseConnection tab of the iProcess Connection shared resource.

The TIBCO JDBC driver will be used:

• When you select JDBC from the Connection Type list, check the Auto Config check box in the DatabaseConnection tab of the iProcess Connection shared resource, and haven’t specified the JDBC driver in the BWPlugin.properties file.
• When you select JDBC from the Connection Type list, uncheck the Auto Config check box, and type the name of the JDBC driver supplied by TIBCO in the JDBC Driver field manually in the DatabaseConnection tab of the iProcess Connection shared resource.

If you have installed TIBCO JDBC driver version 2.x and you want to use TIBCO JDBC driver to set up a connection for Oracle database, you need to uninstall the JDBC driver version 2.x first and then reinstall the JDBC driver version 1.x. For more information about the installation and uninstall of TIBCO JDBC driver, see TIBCO Database Drivers Supplement Installation.

XA Data Source

Yes

The XA DataSource class.

Note: This field is only displayed if you select XA from the Connection Type field.

TIBCO ActiveMatrix BusinessWorks attempts to find the class. However, you may need to add the location of the class to the CLASSPATH environment variable.

Database URL

Yes

The URL to use to connect to the database. This field is completed automatically when you press the Test Connection button. If you need to amend it manually, uncheck the Auto Config check box so the Database URL field is enabled.

Database Username

Yes

Username to use when connecting to the database.

Note: If you are using SQL Server and your usernames authenticate using Windows authentication, you should enter the username of the user you have created that uses SQL Server authentication. See "Pre-requisites for the TIBCO iProcess Server Plug-in for ActiveMatrix BusinessWorks When Using SQL Server" in TIBCO iProcess Technology Plug-ins Installation for more information.

Database Password

Yes

Password to use when connecting to the database.

Note: If you are using SQL Server and your usernames authenticate using Windows authentication, you should enter the password of the user you have created that uses SQL Server authentication. See "Pre-requisites for the TIBCO iProcess Server Plug-in for ActiveMatrix BusinessWorks When Using SQL Server" in TIBCO iProcess Technology Plug-ins Installation for more information.

Database Schema Owner

Yes

The username of the Schema Owner for the database.

Note: If you are using SQL Server and your usernames authenticate using Windows authentication, enter the username of the iProcess Table Owner. See "Pre-requisites for the TIBCO iProcess Server Plug-in for ActiveMatrix BusinessWorks When Using SQL Server" in TIBCO iProcess Technology Plug-ins Installation for more information.

Test Connection Button

When the Test Connection button is clicked, TIBCO ActiveMatrix BusinessWorks attempts to connect to the database using the specified usernames and passwords. You can use this button to determine if the connection will succeed.