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

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

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



"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

  • Re: Multi threads issue with JDBC running on BEA Weblogic 8.1 SP4
    ... is there any updates for sqljdbc other than xa_install (xa support) ... I am trying to update a specific column in a row on MSSQL server 2005 database via MSSQL Server 2005 JDBC Driver. ... active connection ... (Matt Neerincx and Joe Weinstein), ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Multi threads issue with JDBC running on BEA Weblogic 8.1 SP4
    ... I am trying to update a specific column in a row on MSSQL server 2005 database via MSSQL Server 2005 JDBC Driver. ... 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 ... active connection ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Ruby | Ruby on Rails | database MS SQL Server 2005
    ... mssql server. ... This is how I created the connection: ... I added bob as a local user and created ... the ODBC connection called MyDSName. ...
    (comp.lang.ruby)
  • Multi threads issue with JDBC running on BEA Weblogic 8.1 SP4
    ... MSSQL server 2005 database via MSSQL Server 2005 JDBC Driver. ... java.sql.SQLException: Cannot obtain connection: driverURL = ...
    (microsoft.public.sqlserver.jdbcdriver)