Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

What to do when JDBC driver does not support transcations

 
Jehan Jaleel
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Jehan Jaleel
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic