File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "JDBC Help" Watch "JDBC Help" New topic


pappu pager

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

Joined: Mar 24, 2002
Posts: 5
How do i know which driver version i am using....
subject: JDBC Help
It's not a secret anymore!