0 Replies Latest reply on Feb 12, 2003 1:32 PM by CC

    Jboss3.04 and Sybase ASE 12.0

    CC Newbie

      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