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



Wessam (leo) wrote:

Hi Joe,

Thank you for your quick response, really you gave me a hope.
Weblogic version I am using is 8.1 SP4 with sqljdbc_1.0 and SQL Server 2005

my code description as the following:-

A process method takes file path as a parameter => build new File object from that file path ==> build new fileinputstream from that object file ===> create UserTransaction object (javax.transaction.UserTransaction) ====> begin transaction object
=====> create new document from our document class and set some attributes to it
and then dividing this document to chunks and write them eventually to the database
after calling another method and doing some extra modifications
======> commit

this is an overview of what's happening, hope it helps.
another question Joe, is there any updates for sqljdbc other than xa_install (xa support)

Thanks in advance Joe.
Kind Regards

I must repeat again that you should open an official support case
with BEA support. It would really help to show the code. The pool
isn't defined to use the SQLServer driver's XADataSource...
You won't get any more help here, so do get in contact with BEA support.
Joe




"Joe Weinstein" wrote:



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
Loading