Issue with loading the Sybase JDBC driver.BW-JDBC-100033 "Configuration Test Failed. Failed to find or load the JDBC driver: com.sybase.jdbc2.jdbc.SybDriver".

Issue with loading the Sybase JDBC driver.BW-JDBC-100033 "Configuration Test Failed. Failed to find or load the JDBC driver: com.sybase.jdbc2.jdbc.SybDriver".

book

Article ID: KB0093700

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Description:
Issue with loading the JDBC driver for Sybase even when the vendor driver JAR file is present under the "%TIBCO_HOME%\tpcl\5.x\jdbc" folder. The latest JDBC driver may be used but "JDBC Driver" is set with the driver name for an older version. If you unjar/open the driver JAR file, you can see that the there is no "com.sybase.jdbc2.jdbc.SybDriver" class but there is a com\sybase\jdbc4\jdbc\SybDriver(com.sybase.jdbc4.jdbc.SybDriver) class or com\sybase\jdbc3\jdbc\SybDriver(com.sybase.jdbc3.jdbc.SybDriver) depending on the version of driver being used (jconn3.jar/jconn4.jar).  
Symptoms:
Following exception will be thrown in Designer:

+++
BW-JDBC-100033 "Configuration Test Failed. Failed to find or load the JDBC driver: com.sybase.jdbc2.jdbc.SybDriver"
++++

Cause:
Incorrect driver class name  configured in "JDBC Driver" property

Issue/Introduction

Issue with loading the Sybase JDBC driver.BW-JDBC-100033 "Configuration Test Failed. Failed to find or load the JDBC driver: com.sybase.jdbc2.jdbc.SybDriver".

Resolution

Modify "JDBC Driver" to "com.sybase.jdbc4.jdbc.SybDriver" or "com.sybase.jdbc3.jdbc.SybDriver" depending on the version of the driver being used.