I am attempting to use the DbConnectionBroker from javaexchange.com. My setup is MySQL as the db, mm.mysql driver and Resin as the appserver. I am using Java and Jakarta Struts with JSPs on the front end.
When my app starts I create a ConnectionPool class that instantiates a static DbConnectionBroker. In the constructor of my servlets I then say dbPool = ConnectionPool.getInstance, and connection = dbPool.getConnection(). I do my db "stuff" and then call dbPool.freeConnection().
I was wondering if this is a suitable way to proceed. I am occasionally seeing errors relating to Broken Pipes but am not sure if they are related to my usage of the DbConnectionBroker.