0 Replies Latest reply on Oct 25, 2002 6:31 AM by menno

    Configuring Sybase datasource

    menno

      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