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.

Siva examines the JDBC 2.0, JMS 1.02, JNDI 1.2 Standard Extension APIs with regard to connection pooling and looks at some existing vendor implementations of those APIs.

A JDBC connection pool is the answer. A connection pool will create a collection of JDBC connections, and dole those connections out to your program any time there's a need to interact with the ...