Retrieving a connection from JNDI (which includes the connection pools of tomcat) is described as I think in the Hibernate reference.
Tomcat connection pools are described in the Tomcat Website.
I just wrote this in my book, so I still remember where I found the information.
Things get always more complicated as expected.<br />Author of eBook Hibernate 3 Developer Guide by example<br />Tutorials about Hibernate, EJB, Struts, JSF <a href="http://www.laliluna.de" target="_blank" rel="nofollow">www.laliluna.de</a>
Wait for it ... wait .... wait .... NOW! Pafiffle! A perfect tiny ad!
Free, earth friendly heat - from the CodeRanch trailboss