Please could someone point out where I can find instructions on using JBoss 3.0.3 with Sybase jConnect?
I have setup the following in my jboss.xml:
<ejb-name>DataBean</ejb-name>
<bean-home-name>com/menno/ejb/Data</bean-home-name>
0
<jndi-name>com/menno/ejb/Data</jndi-name>
<resource-ref>
<res-ref-name>TESTDB</res-ref-name>
<jndi-name>com/menno/jdbc/TESTDB</jndi-name>
<cmp-resource>True</cmp-resource>
</resource-ref>
Then I've taken a copy of the docs/examples/jca/sybase-service.xml and amended the following lines:
com/menno/jdbc/TESTDB
<config-property name="ConnectionURL" type="java.lang.String">jdbc:sybase:Tds:mennoserver:8310/MYDB?JCONNECT_VERSION=6</config-property>
However when I try and use the ejb I get the following error:
Failed to find data source 'java:comp/env/TESTDB'
NameNotFound, jdbc not bound
I can see the LocalDataSource in the JNDIView's "java: Namespace" as /com/menno/jdbc/TESTDB. So I have no idea what I am doing wrong.
Any help appreciated.
Thanks,
Menno