Multi threads issue with JDBC running on BEA Weblogic 8.1 SP4
- From: Leo Racer <Leo Racer@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 3 May 2006 00:03:02 -0700
Hi,
My problem briefly is, I am trying to update a specific column in a row on
MSSQL server 2005 database via MSSQL Server 2005 JDBC Driver (sqljdbc_1.0).
following are some facts I have may help you understand my issue:-
1- I downloaded this driver from Microsoft site and followed the instructions
in xa_install.txt to support xa for MSSQL Server 2005 and copied the
sqljdbc_xa.dll file to the BINN folder for the SQL server 2005 instance
2- MSDTC ==> Enable XA Transactions is checked and running with SQL Server
2005
3- When I do this update transaction from one thread, it works and
everything
going well and data stored successfully in the database but when I run
more than
one thread calling same update method, it fails with very some error
messages
like the following
<3/05/2006 03:56:53 PM EST> <Error> <JTA> <BEA-110412>
<Xid=BEA1-0001708D23130B1
99E5E(12523276),Status=Rolled back.
[Reason=weblogic.transaction.internal.AppSet
RollbackOnlyException],HeuristicErrorCode=XA_HEURHAZ,numRepliesOwedMe=0,numRepli
esOwedOthers=0,seconds since begin=5,seconds
left=60,XAServerResourceInfo[weblog
ic.jdbc.wrapper.JTSXAResourceImpl]=(ServerResourceInfo[weblogic.jdbc.wrapper.JTS
XAResourceImpl]=(state=rolledback,assigned=APAENGC0009155),xar=weblogic.jdbc.wra
pper.JTSXAResourceImpl@ca6f2d,re-Registered =
false),SCInfo[VRDdomain+APAENGC000
9155]=(state=rolledback),properties=({weblogic.jdbc=t3://100.80.16.174:8080}),Coor
dinatorURL=APAENWSName+100.80.16.174:8080+VRDdomain+t3+) completed
heuristicall
y: (weblogic.jdbc.wrapper.JTSXAResourceImpl, HeuristicHazard,
(javax.transaction
..xa.XAException: Server failed to resume the transaction, desc:
380000016c.)) >
<3/05/2006 03:56:54 PM EST> <Warning> <JDBC> <BEA-001153> <Forcibly
releasing in
active connection
"weblogic.jdbc.wrapper.PoolConnection_com_microsoft_sqlserver_
jdbc_SQLServerConnection@2ef5" back into the connection pool "testPool".>
java.sql.SQLException: Cannot obtain connection: driverURL =
jdbc:weblogic:pool:
testPool, props = {enableTwoPhaseCommit=true, connectionPoolID=testPool,
jdbcTxDat
aSource=true, dataSourceName=TEST Tx Data Source}.
Nested Exception: java.lang.RuntimeException: Failed to setAutoCommit to
true fo
r pool connection.
at
weblogic.jdbc.wrapper.PoolConnection.init(Lweblogic.jdbc.common.inter
nal.ConnectionEnv;)V(PoolConnection.java:47)
at
weblogic.jdbc.pool.Driver.allocateConnection(Lweblogic.jdbc.common.in
ternal.ConnectionEnv;)Ljava.sql.Connection;(Driver.java:254)
at
weblogic.jdbc.pool.Driver.connect(Ljava.lang.String;Ljava.util.Proper
ties;)Ljava.sql.Connection;(Driver.java:164)
at
weblogic.jdbc.jts.Driver.getNonTxConnection(Ljava.lang.String;Ljava.u
til.Properties;)Ljava.sql.Connection;(Driver.java:509)
at
weblogic.jdbc.jts.Driver.connect(Ljava.lang.String;Ljava.util.Propert
ies;)Ljava.sql.Connection;(Driver.java:139)
at
weblogic.jdbc.common.internal.RmiDataSource.getConnection()Ljava.sql.
Connection;(RmiDataSource.java:305)
so this is my problem and I hope you can help me guys specially
( Matt Neerincx and Joe Weinstein ), I appreciate any help.
Thank you in advance..
Kind Regards
.
- Follow-Ups:
- Re: Multi threads issue with JDBC running on BEA Weblogic 8.1 SP4
- From: Joe Weinstein
- Re: Multi threads issue with JDBC running on BEA Weblogic 8.1 SP4
- Prev by Date: RE: Data conversion error
- Next by Date: cannot read BIG5
- Previous by thread: Re: Batch inserts dont work with PreparedStatement and selectMetho
- Next by thread: Re: Multi threads issue with JDBC running on BEA Weblogic 8.1 SP4
- Index(es):
Relevant Pages
|
