Re: Multi threads issue with JDBC running on BEA Weblogic 8.1 SP4

Tech-Archive recommends: Fix windows errors by optimizing your registry



Leo Racer wrote:

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

Hi Leo. This is the kind of case that is best handled with an official
WebLogic support case. We would want to know the version of WebLogic
you're using, and a description of your code and threads. There are
some questions, because you describe XA symptoms but the exception
you show is from a request for a non-XA connection, and not running
in the context of any XA transaction...
Joe Weinstein at BEA Systems

.

Relevant Pages