#Java 8 jdbc odbc bridge alternative driver
#Java 8 jdbc odbc bridge alternative code
#Java 8 jdbc odbc bridge alternative plus

(As a point of interest, JDBC is the trademarked name and is not an acronym nevertheless, JDBC is often thought of as standing for 'Java Database Connectivity.') The JDBC API consists of a set of classes and interfaces written in the Java programming language that provide a standard API for tool/database developers and makes it possible to write industrial strength database applications using an all-Java API. The JDBC API is a Java API for accessing virtually any kind of tabular data.

#Java 8 jdbc odbc bridge alternative code

Programmers who are not writing Enterprise JavaBeanstm (EJB) components or other server code will probably want to download the Java SE, rather than the J2EE, to limit the amount of disc space used. It is also possible to get the javax.sql package by downloading the J2EE, which includes both the java.sql and javax.sql packages.

#Java 8 jdbc odbc bridge alternative driver

A driver vendor may bundle the package javax.sql with its driver product, but if a driver does not include the package, it can be downloaded from the JDBC website at the following URL: The package java.sql, being part of the core API, is automatically included when the Java SE, is downloaded.

Applications using features added in the JDBC 2.0 API will, of course, need to be run using a driver that supports those features. Having been well designed from the beginning, the JDBC 1.0 API is essentially unchanged.

In keeping with the policy of maintaining backward compatibility, applications written using the JDBC 1.0 API will continue to run with both the Java SE, and the J2EE, just as they have always run.

javax.sql package-the JDBC Standard Extension API.

#Java 8 jdbc odbc bridge alternative plus

java.sql package-the JDBC 2.0 core API, which includes the JDBC 1.0 API plus the new API added in the J2SE.

The javax.sql package also provides the RowSet API, which makes it easy to handle data sets from virtually any data source as JavaBeanstm components. 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.