We use Hibernate 3, WebSphere 6 and Oracle 9i. Initailly we did not use WebSphere data source and everything worked just great (we specified database connection info in hibernate.config.xml). Now we are trying to use WebSphere data source. We were able to retrieve data, but when we are doing transaction (update, delete, insert), we got an error.
Here is part of the script in hibernate.config.xml file we have:
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="connection.datasource">jdbc/our_app</property>
<property name="transaction.factory_class">org.hibernate.transaction.JTATransactionFactory</property>
<property name="transaction.manager_lookup_class">org.hibernate.transaction.WebSphereTransactionManagerLookup</property>
<property name="jta.UserTransaction">java:comp/UserTransaction</property>
Also our session beans have <transaction-type>Bean</transaction-type>
Could somebody let us know how we can handle this issue.
Thanks a lot
|