Hi. I've been trying to set up Sybase as a datasource for Jboss 3.2.2RC2 with Tomcat. My sybase-ds.xml file is:
<local-tx-datasource>
<jndi-name>jdbc/SybaseDB</jndi-name>
<!-- Sybase jConnect URL for the database.
NOTE: The hostname and port are made up values. The optional
database name is provided, as well as some additinal Driver
parameters.
-->
<connection-url>URL=jdbc:sybase:Tds:host:port/mydb?charset=iso_1&JCONNECT_VERSION=5</connection-url>
<driver-class>com.sybase.jdbc2.jdbc.SybDataSource</driver-class>
<user-name>x</user-name>
y
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>
When I attempt to get a connection, I get the following jboss resource exception:
org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL
If I change the driver class to SybDriver, it leaves out the "Apparently" bit. I've been unable to set up Sybase as an XADataSource becase a) there is no setURL method in the SybXADataSource or SybDataSource classes and b) the class org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl does not seem to come with the latest JBoss distro.
So, I am wondering if anyone has had success getting Sybase to work with JBoss, and precisely how they did it.