Creating a Connection Pool without using a Java EE Application Server

Question

I'm building a response-time critical multithreaded application in JSE v7 and I need/want to access an SQL Database (via JDBC) with optimal response time - the application is written using JSE for the most part and I want to ideally avoid putting the critical workload through it sat on an App Server. Can I achieve Connection Pooling without a Java EE Application Server or is this the only option?

I have three tables I want to Read, two to update and one to insert.

The desired response time is sub 500ms.

Answer 1

Yes. In no particular order, you might use HikariCP, BoneCP, or c3p0 or Apache DBCP. You may also find these benchmarks helpful (I would take them with a grain of salt).