 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | JSP - A mailing list about Java Server Pages specification and reference | | 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 | |
Struts & Hibernate
|
|
|
| | | Two phase commit transaction using WSAD5.0 and DB2 | Two phase commit transaction using WSAD5.0 and DB2 2005-04-27 - By Gerry Gao
Back
Hi Anuj,
We are using XA with Oracle two, but it is do no need to use XADataSource or
native jdbc connection. If you sure that you must access the native jdbc
connection you can try this:
import com.ibm.ws.rsadapter.jdbc.WSJdbcConnection;
import com.ibm.ws.rsadapter.jdbc.WSJdbcUtil;
...
if (con instanceof WSJdbcConnection) {
db2XADS=
(DB2XADataSource) WSJdbcUtil.getNativeConnection((WSJdbcConnection) con);
}
It works on WAS 5.1 and I think WAS provide same API in lower edition.
good luck
Gerry
-- -- Original Message -- --
From: Anuj Kumar
To: J2EE-INTEREST@(protected)
Sent: Wednesday, April 27, 2005 2:16 PM
Subject: Two phase commit transaction using WSAD5.0 and DB2
Hi All,
I am trying to implement (prototype) 2 phase commit transaction protocol
using wsad5.1 and db2.i configured the DB2XADatasource provider in wsad and
when i try yo run my program i get
[4/27/05 11:27:13:296 GMT+05:30] 1accbc8a WebGroup E SRVE0026E: [Servlet
Error]-[A]: java.lang.ClassCastException: com.ibm.ws.rsadapter.jdbc
.WSJdbcDataSource
at hello.A.getDataSource(A.java:196)
while looking up and casting the DB2XADatasource.
My method which is supposec to return DB2XADatasource is..
public static DB2XADataSource getDataSource(String jndiName) {
InitialContext ctx = null;
DB2XADataSource db2Datasource = null;
Connection conn = null;
try {
ctx = new InitialContext();
db2Datasource = (DB2XADataSource) ctx.lookup(jndiName);
} catch (NamingException ne) {
ne.printStackTrace();
}
return db2Datasource ;
}
}
can anyone Help me out ???
Thanks a lotttt
Anuj
===========================================================================
To unsubscribe, send email to listserv@(protected) and include in the body of
the message "signoff J2EE-INTEREST". For general help, send email to listserv
@(protected) and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to listserv@(protected) and include in the body
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected) and include in the body of the message "help".
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859 (See http://iso-8859.ora-code.com)-1">
<META content="MSHTML 6.00.2800.1498" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face="Lucida Console" size=2>Hi Anuj,</FONT></DIV>
<DIV><FONT face="Lucida Console" size=2></FONT> </DIV>
<DIV><FONT face="Lucida Console" size=2>We are using XA with Oracle two, but it
is do no need to use XADataSource or native jdbc connection. If you sure that
you must access the native jdbc connection you can try this:</FONT></DIV>
<DIV><FONT face="Lucida Console" size=2></FONT> </DIV>
<DIV><FONT face="Lucida Console" size=2>import
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection;<BR>import
com.ibm.ws.rsadapter.jdbc.WSJdbcUtil;</FONT></DIV>
<DIV><FONT face="Lucida Console" size=2>....</FONT></DIV>
<DIV><FONT face="Lucida Console" size=2>if (con instanceof WSJdbcConnection)
{<BR>db2XADS=<BR> (<FONT face="Times New Roman"
size=3>DB2XADataSource</FONT>) WSJdbcUtil.getNativeConnection((WSJdbcConnection
)
con);</FONT></DIV>
<DIV><FONT face="Lucida Console" size=2>}</FONT></DIV>
<DIV><FONT face="Lucida Console" size=2></FONT> </DIV>
<DIV><FONT face="Lucida Console" size=2>It works on WAS 5.1 and I think WAS
provide same API in lower edition.</FONT></DIV>
<DIV><FONT face="Lucida Console" size=2></FONT> </DIV>
<DIV><FONT face="Lucida Console" size=2>good luck</FONT></DIV>
<DIV><FONT face="Lucida Console" size=2>Gerry</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT:
#000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">-- -- Original Message -- -- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=anujkumar73@(protected)
href="mailto:anujkumar73@(protected)">Anuj Kumar</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=J2EE-INTEREST@(protected)
href="mailto:J2EE-INTEREST@(protected)">J2EE-INTEREST@(protected)</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, April 27, 2005 2:16
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Two phase commit transaction
using WSAD5.0 and DB2</DIV>
<DIV><BR></DIV>
<P> <BR>Hi All,<BR><BR>I am trying to implement (prototype) 2 phase commit
transaction protocol using wsad5.1 and db2.i configured the DB2XADatasource
provider in wsad and when i try yo run my program i get <BR>[4/27/05
11:27:13:296 GMT+05:30] 1accbc8a WebGroup E SRVE0026E:
[Servlet Error]-[A]: java.lang.ClassCastException:
com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource<BR> at
hello.A.getDataSource(A.java:196)<BR><BR>while looking up and casting the
DB2XADatasource.<BR><BR>My method which is supposec to return DB2XADatasource
is..<BR><BR>public static DB2XADataSource getDataSource(String jndiName)
{<BR><BR> InitialContext ctx =
null;<BR> DB2XADataSource
db2Datasource
= null;<BR> Connection conn =
null;<BR><BR> try {<BR>
ctx = new
InitialContext();<BR><BR>  
;
db2Datasource = (DB2XADataSource) ctx.lookup(jndiName);<BR>
<BR>
<BR>
} catch (NamingException ne) {<BR>
ne.printStackTrace();<BR>
}<BR><BR>
return db2Datasource ;<BR> }<BR><BR>}<BR><BR>can
anyone Help me out ???<BR><BR>Thanks a lotttt<BR>Anuj<BR></P><BR><BR><A
href="http://clients.rediff.com/signature/track_sig.asp" target=_blank><IMG
hspace=0
src="http://ads.rediff.com/RealMedia/ads/adstream_nx.cgi/www.rediffmailcom
/inbox.htm@(protected)"
border=0></A>
===========================================================================
To
unsubscribe, send email to listserv@(protected) and include in the body of
the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected) and include in the body of the message "help".
<P></P></BLOCKQUOTE></BODY></HTML>
===========================================================================
To unsubscribe, send email to listserv@(protected) and include in the body
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected) and include in the body of the message "help".
<p>
|
|
|
