JDBC 603 Adapter Connections for Sybase 125

, ,
1

Has anyone configured version 6.03 of the JDBC Adapter to connect to a Sybase 12.5 database? If so, could you please share your adapter connections?

I have jconn2.jar in my server’s classpath and the following values for my adapter connection properties:

Transaction Type: NO_TRANSACTION
DataSource Class: com.sybase.jdbc2.jdbc.SybDriver
serverName: <hostname>
user: <username>
password: ******
databaseName: <sybase_database_name>
portNumber: 5005

Thanks in advance,

Mark

2

The IS error log showed that the server could not find the javax.sql.DataSource class. Turns out that the jConnect 5.5 jar does not include any javax.sql.* classes.

My workaround was to put classes12.zip in the server’s classpath. It would be nice to know where to get this from Sybase.

Mark

3

Mark - Try this:

[url=“wmusers.com”]wmusers.com

4

Yes, saw that, however, “javasql.zip” is not present in neither my webMethods installation nor my Sybase 12.5 installation. Is that part of the Fixes and Service packs for the 6.03 JDBC adapter?

Mark

5

The javax.sql.DataSource class is included in the rt.jar of the Sun142 JVM that my server is using. Not sure why it is not being picked up in the classpath.

Mark

6

The actual zip file is called “javaxsql.zip” not “javasql.zip” and is part of the JDBC Adapter 6.0.3 installation. Sorry about the typo. Installing the 6.0.3 adapter will put this jar file in …/packages/WmJDBCAdapter/code/jars by default.

I agree with you that your classpath should pick up DataSource.class if it’s in rt.jar but I don’t know why this isn’t occurring. But stranger things have happened with wM :slight_smile: