Ok, I first must apologize for what seems like an easy question. I have scoured the documentation, but being incredibly unfamiliar with Hibernate, I've been unlucky.

Now then, I have a simple JMS Application that does lookups from 1 of 30 different databases using Hibernate. Currently we make the connections on the fly and don't want to implement connection pooling. Right now it creates a new connection about 10 times per call. I want to set it so that for each call to the MDB, Hibernate creates one connection and uses it until the request is finished.

Any pointers or hints to get me off in the right direction will be very much appreciated!

Thanks,
Paul

I've been trying to play with the hibernate.connection.release_mode property, but it doesn't seem to hold my connections open.

Any info would help, thanks.

Can anyone lend a hand? I'm still not figuring it out...