Database Drivers
The following drivers are supported, but you must obtain, install, and configure these from the appropriate vendor:
-
oracle.JDBC.driver.OracleDriver (oci)
-
oracle.JDBC.driver.OracleDriver (thin)
-
org.postgresql.Driver
-
com.sybase.jdbc2.jdbc.SybDriver
-
com.timesten.jdbc.TimesTenDriver
-
com.ibm.db2.jcc.DB2Driver
-
com.mysql.jdbc.Driver
-
com.microsoft.sqlserver.jdbc.SQLServerDriver
The following drivers are JDBC 2.0-compliant and should work correctly, but they are not officially supported with ActiveMatrix BusinessWorks. You must obtain, install, and configure the driver from the appropriate vendor:
-
sun.jdbc.odbc.JdbcOdbcDriver
-
weblogic.jdbc.mssqlserver4.Driver
You can download, install, and use other JDBC drivers, but TIBCO does not guarantee the drivers function properly with ActiveMatrix BusinessWorks. To use an unsupported driver, perform the following:
Procedure
-
Download the JDBC driver and copy the required JAR files to a location in the classpath of the ActiveMatrix BusinessWorks Engine. For example, you can copy the files to the following location:
TIBCO_HOME
/tpcl/<
version
>/jdbc
. -
In the JDBC Connection resource, choose Select Driver from the drop-down list in the JDBC Driver field and type in the name of the driver class in the text box within that field. Then, type in the correct URL in the Database URL field and specify the other fields in the resource.
For more information on the supported and tested versions of databases and database drivers, see TIBCO ActiveMatrix BusinessWorks™ Release Notes.
You can also use Progress DataDirect drivers with a valid License key. Perform the following steps:
-
Copy the Progress DataDirect driver JAR files to a location in the classpath of the TIBCO ActiveMatrix BusinessWorks Engine. For example, you can copy the files to the following location:
TIBCO_HOME/tpcl/<version>/native-jdbc
. -
In the JDBC Connection resource, choose Select Driver from the drop-down list in the JDBC Driver field and type in the name of the driver class in the text box within that field.
-
Type in the correct URL in the Database URL field and specify the other fields in the resource.