wood burning stoves*
The moose likes BEA/Weblogic and the fly likes JDBC Help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "JDBC Help" Watch "JDBC Help" New topic
Author

JDBC Help

pappu pager
Greenhorn

Joined: Mar 24, 2002
Posts: 5
I am using informix db with the IFXXADataSource Driver for transaction two phase commit.
I have deployed a Stateless Session bean with Transaction type as 'Bean'. After beginning the UserTransaction I fetch the connection from the two datasources, create Statement on the two connection objects and execute the update statement. After updating UserTransaction commit() is invoked. The connections are returned back subsequently(connection.close()).
The Distributed transaction works fine for the first time after starting the WLS server, but when the same transaction is executed again then it gives an error
"XA error: XAER_OUTSIDE : The resource manager is doing work outside global transaction start() failed on resource 'conPool1'"
The error is encountered when the program is trying to create a Statement on the Connection object.
Pls help me and explain abt what is wrong
Chris Mathews
Ranch Hand

Joined: Jul 18, 2001
Posts: 2712
Make sure you are using at least version 2.21JC3 of Informix's JDBC-Driver. This is a known problem on previous versions of the driver.
pappu pager
Greenhorn

Joined: Mar 24, 2002
Posts: 5
How do i know which driver version i am using....
~a
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: JDBC Help
 
Similar Threads
Two phase commit in hibernate?
EntityManagers and transactions
javax. transaction. UserTransaction - reuse
Transaction
JTA query