oracle-ds.xml
**************
<?xml version="1.0" encoding="UTF-8"?>
<local-tx-datasource>
<jndi-name>oraclePool</jndi-name>
<connection-url>jdbc:oracle:thin:@**.**.**.*:portno:***</connection-url>
<driver-class>drivername</driver-class>
<user-name>xyz</user-name>
xy
</local-tx-datasource>
<local-tx-datasource>
<jndi-name>reportPool</jndi-name>
<connection-url>jdbc:oracle:thin:@***.**.**.**:portno:**</connection-url>
<driver-class>drivername</driver-class>
<user-name>abc</user-name>
ab
</local-tx-datasource>
ejb-jar.xml
***************
<ejb-jar>
No Description
<display-name>EmpSessionBean</display-name>
<ejb-name>EmpSessionBean</ejb-name>
com.blah.blah.EmpSessionBeanHome
com.blah.blah.EmpSession
<ejb-class>com.blah.blah.EmpSessionBean</ejb-class>
<session-type>Stateless</session-type>
<transaction-type>Container</transaction-type>
************** noramally we write res-ref-name for every beans but in this case
if i connect multiple datasource which res-ref-name should i write Is it
jdbc/DB or jdbc/reportDB ****************
<resource-ref>
No Description
<res-ref-name>jdbc/DB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</ejb-jar>
jboss.xml
*************
<ejb-name>EmpSessionBean</ejb-name>
<jndi-name>EmpSessionBean</jndi-name>
************** noramally we write res-ref-name for every beans but in this case
if i connect multiple datasource which res-ref-name should i write, Is it
jdbc/DB or jdbc/reportDB ****************
<res-ref-name>jdbc/DB</res-ref-name>
<resource-name>oraclePool</resource-name>
<resource-managers>
<resource-manager res-class="">
<res-name>jdbc/reportDB</res-name>
<res-jndi-name>java:/reportPool</res-jndi-name>
</resource-manager>
<resource-manager res-class="">
<res-name>jdbc/DB</res-name>
<res-jndi-name>java:/oraclePool</res-jndi-name>
</resource-manager>
</resource-managers>
from session bean i am trying to look up multiple datasources like this
dataSource = (DataSource)ictx.lookup("java:comp/env/jdbc/DB");---------------
xyz user should be connected
Connection con= dataSource.getConnection();
dataSource =
(DataSource)ictx.lookup("java:comp/env/jdbc/reportDB");--------------- abc user
should be connected
Connection con= dataSource.getConnection();
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3919016#3919016
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3919016
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
