  | 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 ashraf galal
Back <html><div style='background-color:'><DIV> <P>Anil;</P> <P>you must implement it usaing the abstract factory pattern.</P> <P>the pattern looks like the following class diagram:</P> <P><IMG height=469 alt="Figure 9.8" src="http://java.sun.com/blueprints /corej2eepatterns/Patterns/images09/figure09_08.gif" width=459 align=bottom border=0 name=Graphic8></P> <P>I hope this might help you.</P> <P>Best wishes</P> <P>Ashraf Galal</P> <P>EAI Senior Architect <BR>(416)804-8359</P></DIV> <DIV></DIV> <DIV></DIV> <DIV></DIV> <DIV></DIV>>From: Anil Kumar <ANIL007DC@(protected)> <DIV></DIV>>Reply-To: An interest list for Sun Java Center J2EE Pattern Catalog <J2EEPATTERNS-INTEREST@(protected)> <DIV></DIV>>To: J2EEPATTERNS-INTEREST@(protected) <DIV></DIV>>Subject: Accessing Different DBs from State less EJB <DIV></DIV>>Date: Sat, 1 Nov 2003 21:45:41 -0800 <DIV></DIV>> <DIV></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 COM.ibm.db2 .jdbc.app.DB2Driver <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></DIV>> <DIV></DIV>> <DIV></DIV>>-- ---- ---- ---- ---- ---- ----- <DIV></DIV>>Do you Yahoo!? <DIV></DIV>>Exclusive Video Premiere - Britney Spears <DIV></DIV>> <DIV></DIV>>================================================================ ==== <DIV></DIV>>Companion Site: http://www.corej2eepatterns.com <DIV></DIV>>J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns <DIV></DIV>>List Archive: http://archives.java.sun.com/archives/j2eepatterns -interest.html <DIV></DIV>>Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv @(protected) <DIV></DIV></div><br clear=all><hr>Tired of spam? Get <a href="http://g.msn .com/8HMAENCA/2734??PS=">advanced junk mail protection</a> with MSN 8.</html> ==================================================================== 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)
|
|
 |