File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Murach's Java Servlets and JSP this week in the Servlets 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Help
 
Similar Threads
EntityManagers and transactions
Two phase commit in hibernate?
javax. transaction. UserTransaction - reuse
Transaction
JTA query