This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA 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