Sybase Connectivity

[Former Member]

Hi,

I have always been under the impression that Sybase JDBC driver was packaged in the IDBC server package, along with SQL and Oracle. Is this true?

We have a test box, fresh install on W2003 server of JDK 1.4.2_07 + xMII 11.5.3. All seems OK except an attempted connection to Sybase renders the following error message;

"ERROR ConnectionPool - Error loading JDBC driver, java.lang.ClassNotFoundException: com.sybase.jdbc2.jdbc.SybDriver, App folder=C:\ServletExec AS\se-xMII\webapps\default\Lighthammer\"

and

"FATAL Connector - Unable to create connection pool for SYB_UATDSS: java.lang.ClassNotFoundException: com.sybase.jdbc2.jdbc.SybDriver, App folder=C:\ServletExec AS\se-xMII\webapps\default\Lighthammer\

"

SQL connectivity is fine. SAP connectivity (via JCO) is fine. So it appears the install is fine and dandy.

Just in case the default install has not got the Sybase driver packaged, I copied a .JAR file that contains the referenced Sybase JDBC driver, updated the "Start Servlet Exec" batch file in the se-xmii folder, and restarted the servlet exec, but still got same error.

Is the Sybase driver packaged? If not how can one install it?

Thanks

[Former Member]

Hi Jeremy,

Thanks. I actually copied jconn2.jar but I copied it to c:\ServletExec\lib and updated the "classpath" variable in StartServletExec.bat

Close but no cigar!

I'll copy it to where you say and see how we go.

Regards

Kevin.

[jcgood25]

Kevin,

We stopped bundling the jconn2 jar file quite a few versions ago. You need to download the jdbc driver version appropriate to your needs and copy it to your C:\ServletExec AS\se-xMII\webapps\default\Lighthammer\WEB-INF\lib directory then restart the service.

Here are some useful urls for JDBC driver info:

<a href="http://www.minq.se/products/dbvis/drivers.html">http://www.minq.se/products/dbvis/drivers.html</a>

<a href="http://www.oxygenxml.com/database_drivers.html">http://www.oxygenxml.com/database_drivers.html</a>

Regards,

Jeremy