JDBC resources
The JDBC API provides a programming interface for data access of relational databases, and is comprised of two packages:
java.sql JDBC 3.0 core API javax.sql JDBC 3.0 Standard Extension API Data source and connection pooling
Using data source objects for JDBC applications is IBM's recommended way to establish database connections, and the only way if you want to use connection pooling and distributed transactions.
The following database platforms are supported for JDBC:
- DB2 family
- Oracle
- Sybase
- Informix
- SQL Server
- Cloudscape v10.1 / Derby
- Third-party vendor JDBC data source using SQL99 standards
New in V6.1: The new embedded Cloudscape v10.1 is a pure Java database server. The code base, called Derby by the open source community, is a product of the Apache Software Foundation (ASF) open source relational database project. The new Cloudscape includes Derby without any modification to the underlying source code.
WAS does not currently support Cloudscape v10.1 for production.