1 Reply Latest reply on Jan 29, 2008 6:28 AM by Suresh A

    Anyone got EJBs deployed with Sybase ?

    nrichards Novice

      ..... cos I'm having lots of trouble getting it to work on 2.4.4. I can connect to the database using JDBC, but the same settings don't enable me to use EJBs. Below is my jaws.xml and changes to jboss.jcml:


      SybaseDS
      <type-mapping>Sybase</type-mapping>
      <enterprise-beans>

      <ejb-name>HotelEJB</ejb-name>
      <table-name>HOTEL</table-name>
      <create-table>false</create-table>
      <cmp-field>
      <field-name>id</field-name>
      <column-name>HOTEL_ID</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>chainID</field-name>
      <column-name>CHAIN_ID</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>address</field-name>
      <column-name>ADDRESS</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>state</field-name>
      <column-name>STATE</column-name>
      <jdbc-type>VARCHAR</jdbc-type>
      <sql-type>CHAR(2)</sql-type>
      </cmp-field>
      <cmp-field>
      <field-name>countryCode</field-name>
      <column-name>COUNTRY_CODE</column-name>
      <jdbc-type>VARCHAR</jdbc-type>
      <sql-type>CHAR(2)</sql-type>
      </cmp-field>

      </enterprise-beans>




      com.sybase.jdbc2.jdbc.SybDriver



      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      SybaseDS
      jdbc:sybase:Tds:localhost:2638?ServiceName=stb
      dba
      sql


      I was hoping someone would be able to post the correct configuration options for EJB deployment with Sybase. I'm currently getting "DeploymentException - SybaseDS not bound".

      Thanks in advance,
      Neil