Russell Beattie

I implemented database connection pooling on this site and on Mobitopia. It took all of 5 minutes since all I did was use Orion's built-in db pooling. The funny thing about this was that I remember specifically taking OUT the data connection stuff over a year ago because I switched from my own Linux box to a hosted Resin server and their JNDI stuff was fucked. I never bothered to add the pooling back in after I switched to JohnCompanies and also I was worried about portability. Now there's a few lines that are OrionServer/J2EE server specific... oh well.

Does anyone have any experience with this pooling system on a real site? I had it working before, but didn't have the traffic to notice anything. I've got a max of 10 connections with a timeout of 10 seconds (which may be way too much for a web page). I'd like to know if anyone had any troubles or whatnot.

And hey, I'm getting a million messages that say: "DriverManagerConnectionPoolConnection not closed, check your code!" when the connections time out. Someone know how to close these weird-ass pseudo connections? Google wasn't helping me out.

Thanks,

-Russ

Later - the next day. It turns out that I was using Evermind's connection pool wrapper which isn't well cooked. I downloaded the latest JDBC driver from MySQL.com and changed my data-sources.xml to look like this:

   <data-source

       name="RussellBeattieDS"
       location="jdbc/RussellBeattiePooledDS"
       class="com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource"
       max-connections="20"
       min-connections="2"
       inactivity-timeout="20"
       wait-timeout="10"
       username="CHANGEME"
       password="CHANGEME"
       host="localhost"
   >
    <property name="databaseName" value="CHANGEME"/>

    </data-source>