Database Connection - JDBC

• Java SE - Java DB and Java Database Connectivity (JDBC)
  JDK 6 Java Database Connectivity (JDBC)-related APIs and Developer Guides, JDBC 3.0 API Documentation Guide, Java2 Standard Edition (Java SE) 6 JDK, Sun Microsystems.
  JDBC Guide from Java SE 5.0, JDBC Guide from J2SE 1.4.
• JDBC Documentation
  JDBC 3.0 API Documentation Guide, Java Standard Edition (Java SE) 5.0, Sun Microsystems Java Software.
  JDBC Guide from J2SE 1.4.
• Create your own type 3 JDBC driver
  JavaWorld Magazine article, by Nitin Nanda and Sunil Kumar, 2002.
  Part 1: Connect your Java applications to databases - the easy way (May/2002). Part 2: Compile, deploy, and access data using your custom-built JDBC driver (June/2002) Part 3: Enhance the custom JWDriver with advanced logging, connection pooling, and Predefined Data Sets (July/2002).
• TableGen
  TableGen package automatically generates classes to represent tables within a database. It is released under GPL.

JDBC Drivers

• JDBC Data Access API - Drivers
  Types of JDBC technology drivers: JDBC Driver Type 1, 2, 3, 4.
  Companies endorsing the JDBC database access API.
• OTN - Oracle Java Center - JDBC & SQLJ
  By OTN - Oracle Technology Network. Requires OTN login OTN (free).
  Oracle JDBC Driver Downloads.
  OTN: Oracle Documentation:
  
  • Oracle Database JDBC Developer's Guide and Reference, 10g Release 2 (10.2), Part Number B14355-01 (JDBC 10g R2 PDF)
  • Oracle9i JDBC Developer's Guide and Reference, Release 2 (9.2), March 2002, Part Number A96654-01 (JDBC 9i R2 PDF)
  • Oracle8i JDBC Developer's Guide and Reference, Release 3 (8.1.7), Part Number A83724-01 (JDBC 8i R3 PDF)
  • Oracle Database SQLJ Developer's Guide and Reference, 10g Release 2 (10.2), Part Number B16018-01 (SQLJ 10g R2 PDF)
  • Oracle9i SQLJ Developer's Guide and Reference, Release 2 (9.2), March 2002, Part Number A96655-01 (SQLJ 9i R2 PDF)
  • Oracle8i SQLJ Developer's Guide and Reference, Release 3 (8.1.7), Part Number A83723-01 (SQLJ 8i R3 PDF)
• i-net software JDBC drivers for Oracle Server
  ORANXO: JDBC 3.0 driver. SEROPTO: JDBC 2.0 + Optional Package driver. SERO: JDBC 2.0 driver. AUGURO: JDBC 1.22 driver. All these Oracle drivers are type 4, i.e., completely written in pure Java.
  Feature Matrix for i-net Oracle Server JDBC drivers.
  i-net ORANXO is a J2EE 1.3 certified JDBC 3.0 driver from i-net software for Oracle Database Server. It implements the latest API level JDBC 3.0 with all new features. i-net ORANXO requires a Java version 1.4 or higher. Commercial product.
• jTDS
  jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000 and 2005) and Sybase (10, 11, 12).
  jTDS is based on the work of the FreeTDS project and is currently the fastest complete JDBC driver for SQL Server and Sybase. jTDS is 100% JDBC 3.0 compatible. jTDS is also becoming a common choice for enterprise-level applications: jTDS passes both the J2EE 1.3 certification and Hibernate test suites, making it the driver of choice for SQL Server.
• Microsoft SQL Server 2005 JDBC Driver
  Microsoft Download: SQL Server 2005 JDBC Driver 1.2; SQL Server 2000 Driver for JDBC Service Pack 2.
  Frequently Asked Questions for SQL Server JDBC Driver.
  MSDN: Data Platform Downloads.
  JDBC Driver Service Pack 1.
• Connector/J - MySQL JDBC Drivers
  Connector/J is the JDBC Driver for MySQL. Developed by Mark Matthews, which joined the crew of developers at MySQL AB (june 2002) to make his MM.MySQL the official JDBC driver for MySQL renamed to Connector/J. As well as being open source, under a free software license (LGPL for Connector/J 2, GPL for Connector/J 3 and beyond), commercial licenses and support options are also available from MySQL-AB.
  Old SourceForge Project: MM.MySQL.
  mm.mysql Project & Documentation at Giant Java Tree (GJT).
• PostgreSQL JDBC Driver
  PostgreSQL JDBC driver allows Java programs to connect to a PostgreSQL database using standard, database independent Java code. It is a pure Java (Type IV) implementation. The driver provides are reasonably complete implementation of the JDBC 3 specification in addition to some PostgreSQL specific extensions.
• JayBird
  JayBird JCA/JDBC driver for Firebird RDBMS, by IBPhoenix.
  Firebird 1.0.x & 1.5.x are officialy supported by JayBird. JayBird 1.0.x and 1.5.x work, but with no official support, with InterBase 6.0, 6.5, and 7.1. JayBird 2.0.x will NOT work with any of the InterBase servers, since it uses a Firebird-specific constant during attachment.
  Firebird Development: JayBird JDBC/JCA Drivers - Frequently Asked Questions (FAQ) - JayBird.
  InterClient/InterServer was the old Java Connectivity Kit for InterBase. It was never completed and, for Firebird Java connectivity, was replaced by Jaybird, a native class 4 JCA-JDBC driver.
• IBM DB2 - APIs Java: JDBC & SQLJ
  IBM DB2 Information Center. IBM DB2 Universal Database provides driver support for client applications and applets that are written in Java(TM) using JDBC, and for embedded SQL for Java (SQLJ). DB2 version 8 comes with a new Type 4 and Type 2 JDBC Driver called DB2 Universal JDBC Driver, that speaks the standard DRDA protocol. Type 4 is Pure Java, no JNI, no bridging.
  Overview of Java Development in DB2 UDB for Linux, UNIX, and Windows: Version 8.1 Update, by Paul C. Zikopoulos & Grant Hutchison, IBM Canada.
  Developing Enterprise Java Applications Using DB2 UDB Version 8, by Grant Hutchison, DB2 team at the IBM Toronto Lab, Sep/2002.
  DB2 UDB Version 8 - End of Support date is April 30, 2009.
• NetDirect - Java Database Connectivity
  NetDirect is a industry leader in providing a range of high performance, full featured and scalable JDBC™ solutions for Java database connectivity applications. All products are fully certified by Sun's J2EE™ certification program.
  NetDirect JSQLConnect™ is a highly optimized driver for native JDBC access to Microsoft SQL Server (JDBC 3.0, type 4 driver).
• DataDirect Connect for JDBC
  JDBC Driver for Oracle - DB2 - SQL Server - Sybase - Informix. DataDirect Technologies offers a Type 4 JDBC driver for high-performance database connectivity for all major commercial databases - Oracle, DB2, MS SQL Server, Sybase and Informix. Connect for JDBC drivers support the latest database features, such as JTA (Java Transaction API) and Windows Authentication for SQL Server, and are fully compliant with JDK 1.4 and JDBC 3.0.
• HA-JDBC: High-Availability JDBC
  HA-JDBC is a JDBC driver proxy that provides light-weight, transparent, fault tolerant clustering capability to any underlying JDBC driver.
  Supports any database accessible via JDBC, including full JDBC 3.0 and 4.0 feature set. Exposes JMX management interface. Open source (LGPL).
• Open Source JDBC Tools for High Availabity & Monitoring
  By Java-Source.net.

Connection Pooling

• Commons DBCP
  Java DataBase Connection Pool, by Apache Commons project. DBCP is a database connection pool that relies on code in the Jakarta commons-pool package to provide the underlying object pool mechanisms that it utilizes. Applications can use the DBCP component directly or through the existing interface of their container / supporting framework.
• C3P0
  c3p0: JDBC DataSources/Resource Pools. c3p0 is an easy-to-use library for augmenting traditional (DriverManager-based) JDBC drivers with JNDI-bindable DataSources, including DataSources that implement Connection and Statement Pooling, as described by the jdbc3 spec and jdbc2 std extension.
• Proxool
  Proxool is an easy to use Java connection pool that transparently adds connection pooling to your existing JDBC driver, and provides several control features for configuration and monitoring.
• Java Exchange - Db Connection Broker
  Last version: 1.0.13, 03/21/2002.
  DbConnectionBroker is a pure Java package for handling multiple concurrent database connections. DbConnectionBroker creates a broker with a very simple interface for handing out and returning database connections, managing a dynamic and configurable pool of connections for you with a background housekeeping thread. DbConnectionBroker was used in several large database applications and it is free for all uses.
  Multi Tier Architectures for Database Connectivity, whitepaper by Marc A. Mnich, JavaExchange.com, Jan. 1998.
  Java Exchange is dedicated to servlet-based technologies for Java, with database expertise centered around Oracle and Solid.
• DBPool - Java Database Connection Pooling
  By Giles Winstanley. Last updated: 21st July 2006.
• Core Servlets - Chapter 18: JDBC and Database Connection Pooling
  Source code archive for Core Servlets and JavaServer Pages books.
  Core Servlets and JavaServer Pages (JSP), a Sun Press Book, by Marty Hall.
• HA-JDBC: High-Availability JDBC
  HA-JDBC is a JDBC driver proxy that provides light-weight, transparent clustering capability to any underlying JDBC driver.
• Connection Pooling
  Online contents from book Advanced Programming for the Java2 Platform, by Calvin Austin & Monica Pawlan, November 1999. Extracted from "Chapter 8 Continued: Connection Pooling", explains the implementation of a database connection pool, including links for download of all related Java classes source code. Available online on Sun Developer Network (SDN) Online Training.
• IBM developerWorks Java technology: Connection pools
  "Dive into connection pooling with J2EE". IBM developerWorks Java technology article. By Siva Visveswaran, columnist, JavaWorld, October 2000 (Reprinted with permission from JavaWorld).
• Open Source Database Connection Pools
  By Java-Source.net.