aspose file tools*
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 Spring in Action this week in the Spring 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: What to do when JDBC driver does not support transcations