Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Help

 
pappu pager
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2712
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How do i know which driver version i am using....
~a
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic