Sunday, October 5, 2008

mySQL connection pool?

After speaking to the guys from the carrot2 project (Dawid Weiss and Stanislaw Osinski), they have advised me since this is a production-level code/project, it is probably best if I implement some kind of sql connection pool.

That way database connections can be handled properly in a threaded/enterprise environment.

So I took a look around the net, and since I was using the MySQL Connector/J Driver to connect to the database, in their documentation I found:

http://dev.mysql.com/doc/refman/5.0/en/connector-j-usagenotes-j2ee.html

It has some sample code for creating a connection pool. I'm not sure if I have enough time to implement it, but we'll see :)

No comments: