hibernate 2.0 with websphere 5.0, datasource problem

ss370 · **Joined:** Mon Dec 29, 2003 7:17 pm **Posts:** 3

I am using hibernate 2.0 with websphere 5.0 and having problems with datasource set up.

In my hibernate.cfg.xml file I specify the jndi name of a datasource which has been set up in websphere. However once the server started, I got the following error:

[12/29/03 15:13:07:812 PST] 6a1dc216 LocalTransact E WLTC0033E: Resource jdbc/myDS rolled back in cleanup of unresolved LocalTransactionContainment.
[12/29/03 15:13:07:828 PST] 6a1dc216 LocalTransact E WLTC0032E: One or more resources rolled back. An unresolved LocalTransactionContainment had an unresolved action of rollback.

I am wondering that do I need to set up a resource ref with the datasource so that I can set the isolation level? I am not sure this error was caused by that or not?

Any suggestion?

Thanks !

emmanuel · **Posted:** Tue Dec 30, 2003 6:21 am

Did you specify in you hibernate.cfg.xml or hibernate.properties:

michael · **Posted:** Tue Dec 30, 2003 7:35 am

Quote:

hibernate.transaction.manager_lookup_class to net.sf.hibernate.transaction.JTATransactionFactory,

That should be hibernate.transaction.factory_class I think

emmanuel · **Posted:** Tue Dec 30, 2003 8:26 am

Damn Cut and pastle ;-)

ss370 · **Joined:** Mon Dec 29, 2003 7:17 pm **Posts:** 3

Thanks a lot for replies!

My concern is that I am using SLSB to work with hibernate and let the SLSB to control the transaction thru container of course. From the documentation I found that if I let container control transaction, then I don't have to specify the transaction factory class. I did find the documentation is not very clear on this point. And my application works with weblogic with the same settings.

I am going to give the transaction factory class a try and will repost the result here.

Thanks again!

ss370 · **Joined:** Mon Dec 29, 2003 7:17 pm **Posts:** 3

I put transaction.factory_class in hibernate.cfg.xml and set it to net.sf.hibernate.transaction.JTATransactionFactory. I got "Could not obtain WebSphere JTSXA instance" error. Even I put jta.UserTransaction in hibernate.cfg.xml and set it to jta/usertransaction, still the same problem.

Before I made the changes, I only have transaction.manager_lookup_class, and that setting works with weblogic.

Any setting was wrong or is there any new setting I have to put in?

Thanks !