Here is what I have in DB2-ds.xml file located at
\jboss4.0*\server\default\deploy
<local-tx-datasource>
<jndi-name>jdbc/abrakadabra</jndi-name>
<connection-url>jdbc:db2://blueh006.rchland.ibm.com:60068/appvvdev</connection-url>
<driver-class>COM.ibm.db2.jdbc.app.DB2Driver</driver-class>
<user-name>bhcdev</user-name>
tmp23tmp
<min-pool-size>1</min-pool-size>
<!-- sql to call when connection is created -->
<new-connection-sql>select count(*) from as.cache</new-connection-sql>
<!-- sql to call on an existing pooled connection when it is obtained
from pool -->
<check-valid-connection-sql>select count(*) from
as.cache</check-valid-connection-sql>
</local-tx-datasource>
Corresponding entry in ejb-jar.xml is
<![CDATA[ExpireASPrices Bean]]>
<ejb-name>ExpireASPrices</ejb-name>
<local-home>products.hardware.configurator.as.emergencyfix.ExpireASPricesLocalHome</local-home>
products.hardware.configurator.as.emergencyfix.ExpireASPricesLocal
<ejb-class>products.hardware.configurator.as.emergencyfix.ExpireASPricesBean</ejb-class>
<session-type>Stateless</session-type>
<transaction-type>Bean</transaction-type>
<resource-ref>
<res-ref-name>jdbc/abrakadabra</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
in jboss.xml file
<ejb-name>ExpireASPrices</ejb-name>
<local-jndi-name>ejb/ExpireASPrices</local-jndi-name>
<resource-ref>
<res-ref-name>jdbc/abrakadabra</res-ref-name>
<jndi-name>java:/abrakadabra</jndi-name>
</resource-ref>
and referred in code as
ctx = (ctx == null) ? new javax.naming.InitialContext() : ctx;
ds = (javax.sql.DataSource)
ctx.lookup("java:comp/env/jdbc/abrakadabra"); //$NON-NLS-1$
Let me know if I am missing any thing. This app works fine in WAS, you must
have realized by now I am newbiee to JBOSS and carrying out necessary changes
for porting app to run on JBOSS
Thanks again
-Amitabh
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979415#3979415
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3979415
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
