 | 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
Ashraf,
Iam implementing DAO the same way as you told. I am following the core J2EE
design
patterns.
Thanks
Anil
ashraf galal <ashrafwg@(protected)> wrote:
Anil;
you must implement it usaing the abstract factory pattern.
the pattern looks like the following class diagram:
I hope this might help you.
Best wishes
Ashraf Galal
EAI Senior Architect
(416)804-8359
>From: Anil Kumar
>Reply-To: An interest list for Sun Java Center J2EE Pattern Catalog
>To: J2EEPATTERNS-INTEREST@(protected)
>Subject: Accessing Different DBs from State less EJB
>Date: Sat, 1 Nov 2003 21:45:41 -0800
>
>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)
-- ---- ---- ---- ---- ---- -----
Tired of spam? Get advanced junk mail protection with MSN 8. ==================
================================================== 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)
-- ---- ---- ---- ---- ---- -----
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>Ashraf,</DIV>
<DIV> </DIV>
<DIV>Iam implementing DAO the same way as you told. I am following the
core J2EE design <BR>patterns.</DIV>
<DIV> </DIV>
<DIV>Thanks</DIV>
<DIV>Anil</DIV>
<DIV><BR><B><I>ashraf galal <ashrafwg@(protected)></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER
-LEFT: #1010ff 2px solid">
<DIV>
<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. ===============================================
===================== 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)</BLOCKQUOTE><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)
|
|
|
