 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Struts - A MVC web framework | | Tomcat - JSP/Servlet container | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | | JSP - A mailing list about Java Server Pages specification and reference | |
Struts & Hibernate
|
|
|
| | | Accessing Different DBs from State less EJB | Accessing Different DBs from State less EJB 2003-11-02 - By Anil Kumar
Back
Hi,
I had a Stateless session Bean and DAO to access 4 databases. But as per my
requirement I have to get data from different databases one after other in EJB.
I am getting data from First DB then when it is trying to create the statement
for second DB its throwing the error.
WTRN0062E: An illegal attempt to use multiple resources that have only one
-phase capability has occurred within a global transaction.
I am using Websphere application server (WSAD) with COM.ibm.db2.jdbc.app
.DB2Driver
(JDBC 2.0) Database is DB2.
Please help me out
Thanks a lot
Anil
-- ---- ---- ---- ---- ---- -----
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
<DIV>Hi,</DIV>
<DIV> </DIV>
<DIV>I had a Stateless session Bean and DAO to access 4  
;databases. But as per my requirement I have to get data from different
databases one after other in EJB.</DIV>
<DIV>I am getting data from First DB then when it is trying to create the
statement for second DB its throwing the error.</DIV>
<DIV> </DIV>
<DIV>WTRN0062E: An illegal attempt to use multiple resources that have only one
-phase capability has occurred within a global transaction.</DIV>
<DIV> </DIV>
<DIV>I am using Websphere application server (WSAD) with <FONT size=2>COM.ibm
.db2.jdbc.app.DB2Driver</FONT></DIV>
<DIV>(JDBC 2.0) Database is DB2. </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Please help me out</DIV>
<DIV> </DIV>
<DIV>Thanks a lot</DIV>
<DIV>Anil</DIV>
<DIV> </DIV>
<DIV> </DIV><p><hr SIZE=1>
Do you Yahoo!?<br>
Exclusive Video Premiere - <a href="http://launch.yahoo.com/video/?1093432&fs=1
&redirectURL=http://launch.yahoo.com/promos/britneyspears/">Britney Spears</a>
====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
|
|
|
