Connecting to Sybase ASA from JBoss 3.0

[jurberg]

I'm trying to get JBoss 3.0 to connect to my Sybase Adaptive Server Anywhere database. If I add to my config file, I get:

[org.jboss.deployment.SARDeployer] Problem in init
org.jboss.deployment.DeploymentException: Invalid classpath element missing codebase or archives:

during start up. If I leave it out, I get:

org.jboss.util.NestedSQLException: Failed to register driver for: com.sybase.jdbc2.jdbc.SybDriver; - nested throwable: (java.lang.ClassNotFoundException: com.sybase.jdbc2.jdbc.SybDriver...

when I first try to get a connection.

I've tried putting this file in jboss/lib, jboss/server/default/lib and jboss/server/default/deploy to no avail.

Any ideas how to get this working?

Thanks,
John

[ropeter321]

I am having this same problem. Anyone know the answer?

[wumpuz]

The classpath element needs a 'codebase' attribute which shows where to look for the jar.

e.g.
If your sybase-service.xml is in default/deploy, then put jconn2.jar in default/lib.