J2EE™ and Beyond: Design, Develop, and Deploy World-Class Java™ Software

Introduction

The java.sql.Connection object is a required part of any database interaction with JDBC. The Connection object represents the physical connection to the database, usually using an underlying network connection, and is responsible for maintaining and managing the connection.

Though the Connection represents a physical connection, the process of obtaining a connection may not represent the creation of a physical connection to the database, since connection pooling may simply use an existing connection instead of creating a new connection.

A Connection object can provide information about the tables in the database, the supported SQL grammar, the stored procedures available, and the general capabilities of the database connection by ...