I have question with regard to propblem I had in topic:

http://forum.hibernate.org/viewtopic.ph ... 01#2231901

I realized that that connections can not be shared within a local transaction containment boundary. Does it mean within a transaction block if I run five different queries, it eats up 5 connection from the connection pool?

Let's say if I have the following block:

session = util.getSession();
tx = util.startTransaction(session);

dao1.runquey1(session);
dao2.runquery2(session);
.
.
daon.runquery2(session)


util.commitTransaction(tx);
util.closeSession(session);


Then I need to have n connections per transaction block (if that is the case then , it is expensive to run multiple queries within a transaction block, all the connections in the connection pool are going to be eaten up fast if the volume of hits is high]. For those of you who things are not clear, take a look at :

http://www-1.ibm.com/support/docview.ws ... wg21121449