how to connect multiple datasource using ENC in jboss

[maha laxmi]

oracle-ds.xml
**************
<?xml version="1.0" encoding="UTF-8"?>



<local-tx-datasource>
<jndi-name>oraclePool</jndi-name>
<connection-url>jdbc racle:thin:@**.**.**.* ortno:***</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 racle:thin:@***.**.**.** ortno:**</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();
[ January 24, 2006: Message edited by: maha laxmi maha laxmi ]

[Wiley Snyder]

to look up multiple datasources using jndi your going to have to put them in your [[[[[[[[C:\jboss-XXX\server\default\deploy\XXXXwhateverdatabase-ds.xml

file.

i.e....

one of my development environments on Windows ...

 

<?xml version="1.0" encoding="UTF-8"?>
 
<!-- $Id: mysql-ds.xml,v 1.1.2.1 2003/12/12 19:19:56 starksm Exp $ -->
<!--  Datasource config for MySQL using 3.0.9 available from:
<a href="http://www.mysql.com/downloads/api-jdbc-stable.html" target="_blank" rel="nofollow">http://www.mysql.com/downloads/api-jdbc-stable.html</a>
-->
 
<datasources>
  <local-tx-datasource>
    <jndi-name>DefaultDS</jndi-name>
    <connection-url>jdbc:mysql://127.0.0.1:3306/myJbossDatabase</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>vvv</user-name>
    <password>xxx</password>
  </local-tx-datasource>
 
  <local-tx-datasource>
    <jndi-name>whyDS</jndi-name>
    <connection-url>jdbc:mysql://127.0.0.1:3306/whyds</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>vvv</user-name>
    <password>eee</password>
  </local-tx-datasource>
  
  <local-tx-datasource>
    <jndi-name>CrapOlaDS</jndi-name>
    <connection-url>jdbc:mysql://127.0.0.1:3306/cpDS</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>xxx</user-name>
    <password>yyy</password>
  </local-tx-datasource>
  
  <local-tx-datasource>
    <jndi-name>SomeOtherDS</jndi-name>
    <connection-url>jdbc:mysql://127.0.0.1:3306/sodatacenter</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>bush</user-name>
    <password>sucks</password>
  </local-tx-datasource>
  
  <local-tx-datasource>
    <jndi-name>SomeDatabaseDS</jndi-name>
    <connection-url>jdbc:mysql://127.0.0.1:3306/sdatabase</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <user-name>xxx</user-name>
    <password>xxx</password>
  </local-tx-datasource>
 
</datasources>