This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Websphere and the fly likes What to do when JDBC driver does not support transcations 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 » Websphere
Bookmark "What to do when JDBC driver does not support transcations" Watch "What to do when JDBC driver does not support transcations" New topic
Author

What to do when JDBC driver does not support transcations

Jehan Jaleel
Ranch Hand

Joined: Jan 16, 2001
Posts: 38
I have a JDBC driver which I must use in a transcation but the driver currently does not support transcations. When I use it in WAS now it gives me the following error....

" An illegal attempt to enlist a one phase capable resource with existing two phase capable resources has occurred"

I was wondering if there is any way I could configure WAS to make this work.

Any help would be appreciated.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Simple answer: No.

Whether or not a driver can support transactions is partly down to what's been implemented in the driver and what the DB can support. For example MyISAM tables in MySQL are non-transactional. I'd look for a different JDBC driver if you believe the DB you are using can support transactions.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Jehan Jaleel
Ranch Hand

Joined: Jan 16, 2001
Posts: 38
I think I may be able to do it with Last Participant Support. Does anyone know how to configure this in WSAD? A document I have says it is in the Extended Services tab of the Application Deployment descriptor tab but I did not see it.

Thanks for any help.
 
 
subject: What to do when JDBC driver does not support transcations
 
Similar Threads
Accessing Entity from MDB
One Phase and Two Phase Error
Transactions with Stored Procedures
Last Participant Support
Db2 driver and Distributed transaction