The DataSource API plays an integral part in these capabilities and also works with the Javatm Naming and Directory Interfacetm (JNDI) to improve portability and make code maintenance easier. This package makes it easier to build server-side applications using the Java platform by providing an open architecture that supports connection pooling and distributed transactions that span multiple database servers.

JDBC Standard Extension API-the package javax.sql, which may be downloaded from.

Some of the new features in this package are scrollable result sets, batch updates, programmatic updates, and support for the new SQ元 data types. JDBC 2.0 core API-the package java.sql the JDBC API that is part of the Java SE, which includes the JDBC 1.0 API plus the new JDBC API added in the java.sql package.The J2EE, includes the complete JDBC 2.0 API.

JDBC 2.0 API-the complete JDBC API, including both the java.sql package (the JDBC 2.0 core API) and the javax.sql package (the JDBC Standard Extension API).

The following list defines various terms used in talking about the JDBC API. The JDBC 2.0 API includes all of the API that is part of Java SE, and also the API in the JDBC Standard Extension API. It also extends JDBC technology beyond the client to the server with connection pooling and distributed transactions. In addition, the new API includes features such as scrollable and updatable result sets and improved performance. The JDBC 2.0 API supplements the basic API with more advanced features and provides a standard way to access the latest object-relational features being supported by today's relational database management systems. It includes the JDBC 1.0 API, which provides the basic functionality for data access. The JDBCtm API is the application programming interface that provides universal data access for the Javatm programming language. NOTE: The material in this chapter is based on JDBCtm API Tutorial and Reference, Second Edition: Universal Data Access for the Javatm 2 Platform, published by Addison Wesley as part of the Java series, ISBN 8-1.

Java 8 jdbc odbc bridge alternative