BW 6.x Oracle driver vs BW 5.x Oracle driver.

BW 6.x Oracle driver vs BW 5.x Oracle driver.

book

Article ID: KB0086965

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Resolution:
In BW 6.x the Oracle driver in the dropdown is - "oracle.jdbc.OracleDriver". In BW 5.x, the Oracle driver in the dropdown is "oracle.jdbc.driver.OracleDriver". According to the Oracle website, the "oracle.jdbc.driver.OracleDriver" is deprecated and the new driver is "oracle.jdbc.OracleDriver". We continue to use these drivers in BW 5.x versions and new driver in BW6.x versions. You will need to be careful when copy/pasting the driver when moving from a 5.x to to a 6.x project development.

Issue/Introduction

BW 6.x Oracle driver vs BW 5.x Oracle driver.

Additional Information

http://www.orafaq.com/wiki/JDBC
http://stackoverflow.com/questions/6202653/difference-between-oracle-jdbc-driver-classes
http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html#Oracle_8i,_9i_&_10g
http://www.oracle.com/technetwork/database/enterprise-edition/111070-readme-083278.html