JDBC 3: Java Database Connectivity (M&T Books)

Java Database Connectivity (JDBC) is a programming interface that lets Java applications access a database via the SQL language. Java interpreters or Java virtual machines are available for all major client platforms: thereby allowing a platform independent database application to be written. JDBC 3.0 has been completed by database industry leaders including Oracle, Sybase and IBM, and has matured enough to encompass many features of any other database access technology or language suited for business applications. This practical guide to the new, enhanced features of JDBC 3 provides a step-by-step tutorial to the API, as well as many examples and discussions about advanced techniques. It also provides a complete reference of the API's packages and extensions. Powerful and enhanced new features are covered: batch updates; DataSource object; transaction savepoints; connection pooling; distributed transaction support; XA compatibility; types of results sets; holdable cursors; SQL99 types; scala functions; CLOB; array, reference and datalink objects; customized type mapping; transform groups; ParameterMetaData API; auto generated keys; and more.