JDBC Versions 13 JDBC Versions Throughout the history (Web hosting macintosh)
JDBC Versions 13 JDBC Versions Throughout the history of JDBC, Sun has introduced several different versions, beginning with version 1.0 in January of 1997. This initial specification defined the interfaces necessary to create an instance of the driver in a Java application, building SQL statements to execute against the underlying database, return results through a ResultSet object, and obtain various pieces of metadata about the database as well as the ResultSet. Next, the 2.0/2.1 specification was released; this broke the original 1.0 specification into two parts. The Core API for 2.0 didn t add much to the original 1.0 specification but instead concentrated on performance and SQL 99 data types. The added functionality included programmatic SQL statements, scrollable ResultSets, streams, and other small updates. The second part of the 2.0/2.1 specification is called the JDBC 2.0 Optional Package. This package includes interfaces for data source interfaces, connection pooling, distributed transactions, and RowSets. Recently, version 3.0 of the JDBC specification was released. Supported in the 1.4.x version of Java, the new specification includes many enhancements to ResultSets, data types, connection pools, and basic SQL statements. New functionality includes savepoint support (for checkpointing within transactions) and support for ParameterMetaData. You can find a complete discussion of the 3.0 specification at http://java.sun.com/products/jdbc/download.html#corespec30. In the section JDBC Support within 3.0.1 later in this chapter, we provide a complete overview of MySQL Connector/J s support of the functionality found in the specification. Appendix C, JDBC API and Connector/J also contains a detailed review of the complete specification and Connector/J support. JDBC Driver Types This section discusses the basic programming model of the JDBC driver itself. There are four different ways a JDBC driver can be created by vendors to support their database: Type 1: JDBC-ODBC Bridge Type 2: Native-API partly Java Type 3: JDBC-Net pure Java Type 4: Native-protocol pure Java
Note: If you are looking for cheapest and affordable webspace to host and run your servlet application check Astra servlet hosting services