Get an overview of JDBC's architecture, then learn how to connect to a database and handle SQL queries and responses with PreparedStatements, transactions, connection pooling, and more.

Connection pooling is a technique used for sharing server resources among requesting clients. This article focuses on support for connection pooling of both database resources and nondatabase ...

If you want connection pooling (and I assume a shared cache against the database) I don't think you have any choice but write a separate daemon.

I've got a fairly large legacy fat-client app that needs some performance improvements in its DB access since the powers that be have decided to relocate the SQL servers that the client talks to ...