Hi, I'm trying to get jboss 3.04 talk to Sybase ASE 12.0. I started with the sybase-service.xml file I got from the jboss package and modified only the "ManagedConnectionFactoryProperties" properties as follow:
<config-property name="ConnectionURL" type="java.lang.String">
jdbc:sybase:Tds:mydb_host:5000/db_name
</config-property>
<config-property name="DriverClass" type="java.lang.String">
com.sybase.jdbc2.jdbc.SybDataSource
</config-property>
<config-property name="UserName" type="java.lang.String">
sa
</config-property>
<config-property name="Password" type="java.lang.String">
sa_passwd
</config-property>
then I copied it to JBOSS_ROOT/server/default/deploy and I got the following warning from Jboss output:
WARN [ServiceController] jboss.jca:service=LocalTxDS,name=SybaseDB does not implement any Service methods
And when I pressed ahead and ran my ejb program which does the following query:
PreparedStatement ps = conn.prepareStatement("select * from sysobjects");
ResultSet rsw = ps.executeQuery();
, the following exception is dumped out from jboss:
ERROR [STDERR] java.sql.SQLException: Table not found: SYSOBJECTS in statement [select * from sysobjects]
Could someone tell my what's up with my setup? any help would be much appreciated!
CC