Custom Database Driver in JDBC Connection in Tibco

Custom Database Driver in JDBC Connection in Tibco

The following drivers are included in the TIBCO BusinessWorks installation: 

•     tibcosoftwareinc.jdbc.oracle.OracleDriver
•     tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver
•     tibcosoftwareinc.jdbc.sybase.SybaseDriver
•     tibcosoftwareinc.jdbc.db2.DB2Driver  

      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)

     com.sybase.jdbc2.jdbc.SybDriver

     com.timesten.jdbc.TimesTenDriver

     com.ibm.db2.jcc.DB2Driver

  

      The following drivers are JDBC 2.0-compliant and should work correctly, but they are not officially supported with 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 will function properly with TIBCO BusinessWorks. To use an unsupported driver, perform the following:

 

Download the JDBC driver and copy the required JAR files to a location in the classpath of the TIBCO BusinessWorks Engine. For example, you can copy the files to the following location: TIBCO_HOME/tpcl//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.

 

      See TIBCO BusinessWorks Release Notes for more information on the supported and tested versions of databases and database drivers.