Anyone got EJBs deployed with Sybase ?

[nrichards]

..... 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

[suresh.don]

Hi

For having the SybaseDS to be available in your Application server you need to deploy the sybase-ds.xml in the deploy folder of the JBoss.

The sample sybase-ds.xml file will be available in the examples of jboss. examples/jca/sybase-ds.xml

Regards,
Suresh.A