Hibernate version: 2.1.6

We have a requirement to create DAO to execute stored
procedures from multiple datasources in a single
transaction in WebLogic server. Is it possible? If so could
you please provide some example.

Yes it is possible. Just use a transactional DS from WL and configure the TransactionManagers in Hibernate (see the ref doc)

My requirement is two fold :
one is to achieve global transaction behaviour using weblogic app. server
second is to access multiple data stores using two different conenction pools deployed on weblogic.

I have used the following code :
property name="hibernate.connection.datasource" value=<Name of datasource>/>
<property name="hibernate.transaction.manager_lookup_class" value="net.sf.hibernate.transaction.WeblogicTransactionManagerLookup"/>
<property name="hibernate.transaction.factory_class" value="net.sf.hibernate.transaction.JTATransactionFactory"/>
<property name="jta.UserTransaction" value="javax/transaction/UserTransaction"/>

The first requirement gets fulfilled bt above code.
But for second it gives the following error :

Caused by: java.sql.SQLException: Connection has already been created in this tx context for pool named CvdbPool. Illegal attempt to create connection from another pool: TlvPool

Thanks in advance!

First, you realize you need to set up two seperate SessionFactorys to access two seperate DataSources, right? You only posted config for one, so just wanted to be sure.

Second, make sure you are using transacted DS in WebLogic. How this is done varies by version, so check the docs. Also, make sure you are using the XA versions of your jdbc drivers. WebLogic allows you to "emulate 2PC" for non-XA drivers in a datasource, but they (at least up through 6.1) only allowed one such datasource to participate in a given JTA transaction.

Same for 7

Second, make sure you are using transacted DS in WebLogic. How this is done varies by version, so check the docs. Also, make sure you are using the XA versions of your jdbc drivers. WebLogic allows you to "emulate 2PC" for non-XA drivers in a datasource, but they (at least up through 6.1) only allowed one such datasource to participate in a given JTA transaction.[/quote]


Thanks a million! Steve!
I was using non XA driver with "emulate 2PC" on. I tried with XA driver and it works!
Thanks once again.....