This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes EJB and other Java EE Technologies and the fly likes  how to connect different datasources using multiple datasource using ENC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark " how to connect different datasources using multiple datasource using ENC " Watch " how to connect different datasources using multiple datasource using ENC " New topic
Author

how to connect different datasources using multiple datasource using ENC

maha laxmi
Ranch Hand

Joined: Sep 23, 2005
Posts: 68
how to connect different datasources using multiple datasource using ENC in jboss?

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();
Roger Chung-Wee
Ranch Hand

Joined: Sep 29, 2002
Posts: 1683
Check the DTD:
<!ELEMENT session (description?, display-name?, small-icon?,
large-icon?, ejb-name, home?, remote?, local-home?, local?,
ejb-class, session-type, transaction-type, env-entry*, ejb-ref*,
ejb-local-ref*, security-role-ref*, security-identity?, resource-ref*,
resource-env-ref*)>

As the resource-ref element can occur zero or more times, you should declare as many as needed.


SCJP 1.4, SCWCD 1.3, SCBCD 1.3
maha laxmi
Ranch Hand

Joined: Sep 23, 2005
Posts: 68
Originally posted by Roger Chung-Wee:
Check the DTD:

As the resource-ref element can occur zero or more times, you should declare as many as needed.


THANKS it worked
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to connect different datasources using multiple datasource using ENC