Sorry to bring this up again but I'm new to this and I am unable to connect to Sybase using the above example. In straight Java/Jdbc (without Jboss) I can get it to work. Setting up a datasource seems to be my sticking point.
Here's what I have:
08:05:58,357 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service
thread 1-1) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]
08:05:58,982 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774
: Service status report
JBAS014775: New missing/unsatisfied dependencies:
service jboss.jdbc-driver.sybaseDriver (missing) dependents: [service jbos
s.data-source.java:jboss/datasources/SybaseDS]
...\standalone\configuration\standalone.xml
<subsystem xmlns="urn:jboss:domain:datasources:1.0">
...
<datasources>
<datasource jndi-name="java:jboss/datasources/ExampleDS"
pool-name="ExampleDS" enabled="true" use-java-context="true">
<connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>
<driver>h2</driver>
<security>
<user-name>sa</user-name>
<password>sa</password>
</security>
</datasource>
<datasource jndi-name="java:jboss/datasources/SybaseDS" pool-name="SybaseDS" enabled="true">
<connection-url>jdbc:sybase:Tds:10.250.5.27:5000</connection-url>
<driver-class>com.sybase.jdbc4.jdbc.SybDriver</driver-class>
<driver>sybaseDriver</driver>
<security>
<user-name>sa</user-name>
<password>angels</password>
</security>
</datasource>
<drivers>
<driver name="h2" module="com.h2database.h2">
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
</driver>
<driver name="sybaseDriver" module="com.sybaseDS.sybaseDriver"/>
</drivers>
</datasources>
...
</subsystem>
And
...com\sybaseDS\sybase\main
<module xmlns="urn:jboss:module:1.1" name="com.sybaseDS.sybaseDriver">
<resources>
<resource-root path="jconn4.jar"/>
<!-- Insert resources here -->
</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>