JDBC for CDC/FP Optional Package Specification v1.0: Overview

Use is subject to License Terms. Your use of this web site or any of its content or software indicates your agreement to be bound by these License Terms.

Copyright © 2006 Sun Microsystems, Inc. All rights reserved.

Overview

Package

Class

Tree

Deprecated

Index

Help

JDBC for CDC/FP Optional Package

PREV NEXT

FRAMES NO FRAMES

JDBC for CDC/FP Optional Package Specification v1.0

JDBC for CDC/FP Optional Package Specification v1.0 (PUBLIC DRAFT)

See:
Description

Packages

java.sql Provides the API for accessing and processing data stored in a data source (usually a relational database) using the Java^TM programming language.

javax.sql Provides the API for data source access and manipulation of tabular data as JavaBeans.

This package was originally developed as a supplement to java.sql package and, as of the version 1.4 release, is included in the Java^TM 2 SDK, Standard Edition.

JDBC for CDC/FP Optional Package Specification v1.0 (PUBLIC DRAFT)

Last updated 8/14/2002

License

This specification is made available under the following terms.

Introduction

This specification was developed under the Java Community Process (JCP) version 2.1, as Java Specification Request 169 (JSR-169). The JSR is available on the JCP website, http://jcp.org/jsr/detail/169.jsp. The following companies and individuals contributed to the definition of this specification as the expert group:

Name	Representing
Jon Ellis	Sun Microsystems, Inc. (Specification Lead)
Jonathan Bruce	Sun Microsystems, Inc. (Specification Lead)
Richard Dettinger	IBM
John Goodson	DataDirect Technologies.
Sam Rehman	Oracle Corporation.
David Murphy	Individual contributor
Scott Marlow	SilverStream Software, Inc.
Ara Aravamudhan	Pointbase, Inc.
Joseph Weinstein	BEA Systems
Paul Bonfanti	New Atlanta Communications, LLC.

The work done in this specification is based upon the JDBC 3.0 Specification. For more information see the JDBC website, http://java.sun.com/products/jdbc and the JCP webpage for JSR-054, http://jcp.org/jsr/detail/54.jsp.

Feedback

Any comments, corrections and feedback on this specification should be sent to jdbc-cdc@sun.com.

Overview

The JDBC for CDC / FP Optional Package defines a subset of the JDBC 3.0 API that can be used in conjunction with the Java 2 Micro Edition (J2ME) Connected Device Configuration / Foundation Profile (CDC / FP).

Requirements

J2ME CDC / FP defines minimum requirements for the processing, RAM and ROM, virtual machine capabilities that a device must have in order to support the configuration. In order to support the JDBC for CDC / FP Optional Package the device must provide an additional:

256Kb of RAM storage
256Kb of ROM storage

Unless otherwise noted in the following sections, the requirements for supporting features of the JDBC Specification API present in the JDBC for CDC/FP Optional Package are defined by the JDBC 3.0 Specification API.

Changes

The following sections describe all of the changes that have been made relative to the JDBC 3.0 Specification API. In all cases the changes are removing functionality that is not applicable for, or are not supported by, the CDC / FP configuration. As a result the JDBC for CDC / FP Optional Package API is a strict subset of the JDBC 3.0 Specification API.

The change log details at which milestones changes were made.

The following changes have been made relative to the JDBC 3.0 Specification API:

support for connection pooled and XA enabled data sources has been removed.
the DriverManager class, the Driver and DriverPropertyInfo interfaces have been removed, the DatabaseMetaData method getURL and the Rowset methods getURL() and setURL() have been removed. Users should now use the DataSource interface to create connections. See the API documentation for further details.
SQLException, and it's sub-classes now override the toString method, driver vendors write the output of toString to the log. Details of exceptions and warning are no longer automatically written to the log.
the ParameterMetaData interface has been removed.
support for setting parameters by name in the CallableStatement interface has been removed.
support SQL 99 types (the Struct, Array, Ref, SQLData, SQLInput and SQLOutput interfaces) has been removed.
support for custom type mapping (via setTypeMap() / getTypeMap()) has been removed.

Details

Click below for a list of classes that make up the JDBC for CDC/FP Optional Package:

List of JDBC for CDC/FP Optional Package classes.

The following interfaces/classes have been removed during the process of subsetting the API for CDC/FP:

java.sql.Array java.sql.Driver java.sql.DriverManager java.sql.DriverPropertyInfo java.sql.ParameterMetaData java.sql.Ref java.sql.SQLData java.sql.SQLInput java.sql.SQLOutput java.sql.SQLPermission java.sql.Struct javax.sql.ConnectionEventListener javax.sql.ConnectionPoolDataSource javax.sql.PooledConnection javax.sql.XAConnection javax.sql.XADataSource javax.sql.ConnectionEvent

The following methods/constants have been removed:

java.sql.CallableStatement.Object getObject (int, java.util.Map) java.sql.CallableStatement.getArray (int) java.sql.CallableStatement.registerOutParameter(String, int) java.sql.CallableStatement.registerOutParameter(String, int, int) java.sql.CallableStatement.registerOutParameter (String, int, String) java.sql.CallableStatement.setURL(String, java.net.URL) java.sql.CallableStatement.setNull(String, int) java.sql.CallableStatement.setBoolean(String, boolean) java.sql.CallableStatement.setByte(String, byte) java.sql.CallableStatement.setShort(String, short) java.sql.CallableStatement.setInt(String, int) java.sql.CallableStatement.setLong(String, long) java.sql.CallableStatement.setFloat(String, float) java.sql.CallableStatement.setDouble(String, double) java.sql.CallableStatement.setString(String, String) java.sql.CallableStatement.setBytes(String, byte[]) java.sql.CallableStatement.setDate(String, java.sql.Date) java.sql.CallableStatement.setTime(String, java.sql.Time) java.sql.CallableStatement.setTimestamp(String, java.sql.Timestamp) java.sql.CallableStatement.setAsciiStream(String, java.io.InputStream, int) java.sql.CallableStatement.setBinaryStream(String, java.io.InputStream, int) java.sql.CallableStatement.setObject(String, Object, int, int) java.sql.CallableStatement.setObject(String, Object, int ) java.sql.CallableStatement.setObject(String, Object) java.sql.CallableStatement.setCharacterStream(String, java.io.Reader, int) java.sql.CallableStatement.setDate(String, java.sql.Date, Calendar) java.sql.CallableStatement.setTime(String, java.sql.Time, Calendar) java.sql.CallableStatement.setTimestamp(String, java.sql.Timestamp, Calendar) java.sql.CallableStatement.setNull (int, int, String) java.sql.CallableStatement.getString(String) java.sql.CallableStatement.getBoolean(String) java.sql.CallableStatement.getByte(String) java.sql.CallableStatement.getShort(String) java.sql.CallableStatement.getInt(String) java.sql.CallableStatement.getLong(String) java.sql.CallableStatement.getFloat(String) java.sql.CallableStatement.getDouble(String) java.sql.CallableStatement.getBytes(String) java.sql.CallableStatement.getDate(String) java.sql.CallableStatement.getTimestamp(String) java.sql.CallableStatement.getObject(String) java.sql.CallableStatement.getObject (String, java.util.Map) java.sql.CallableStatement.getRef (String) java.sql.CallableStatement.getBlob (String) java.sql.CallableStatement.getClob (String) java.sql.CallableStatement.getArray (String) java.sql.CallableStatement.getDate(String, Calendar) java.sql.CallableStatement.getTime(String, Calendar) java.sql.CallableStatement.getTimestamp(String, Calendar) java.sql.CallableStatement.getURL(String) java.sql.DatabaseMetaData.getURL() java.sql.Connection.getTypeMap() java.sql.Connection.setTypeMap(java.util.Map) java.sql.PreparedStatement.setRef (int, Ref) java.sql.PreparedStatement.setArray (int, Array) java.sql.PreparedStatement.ParameterMetaData getParameterMetaData() java.sql.ResultSet.getObject(int, java.util.Map) java.sql.ResultSet.getRef(int) java.sql.ResultSet.getArray(int) java.sql.ResultSet.getObject(String, java.util.Map) java.sql.ResultSet.getRef(String) java.sql.ResultSet.getArray(String) java.sql.ResultSet.updateRef(int, java.sql.Ref) java.sql.ResultSet.updateRef(String, java.sql.Ref) java.sql.ResultSet.updateArray(int, java.sql.Array) java.sql.ResultSet.updateArray(String, java.sql.Array) javax.sql.Rowset.getURL() javax.sql.Rowset.setURL(String)

The following methods have been removed as they are not supported by CDC/FP:

java.sql.CallableStatement.java.getBigDecimal(int, int) java.sql.CallableStatement.getBigDecimal(int) java.sql.CallableStatement.setBigDecimal(String, BigDecimal) java.sql.CallableStatement.getBigDecimal(String ) java.sql.PreparedStatement.setBigDecimal(int, BigDecimal) java.sql.ResultSet.getBigDecimal(int, int) java.sql.ResultSet.getBigDecimal(String, int) java.sql.ResultSet.getBigDecimal(int) java.sql.ResultSet.getBigDecimal(String) java.sql.ResultSet.updateBigDecimal(int, BigDecimal) java.sql.ResultSet.updateBigDecimal(String, BigDecimal)

The following deprecated methods have been removed:

java.sql.CallableStatement.getBigDecimal(int, int)
java.sql.Date.getHours() java.sql.Date.setHours(int) java.sql.Date.getMinutes() java.sql.Date.setMinutes(int) java.sql.Date.getSeconds() java.sql.Date.setSeconds(int) java.sql.DriverManager.getLogStream() java.sql.DriverManager.setLogStream(PrintStream) java.sql.PreparedStatement.setUnicodeStream(int, InputStream, int) java.sql.ResultSet.getBigDecimal(int, int) java.sql.ResultSet.getBigDecimal(String, int) java.sql.ResultSet.getUnicodeStream(int) java.sql.ResultSet.getUnicodeStream(String) java.sql.Time.getDate() java.sql.Time.setDate(int) java.sql.Time.getDay() java.sql.Time.getMonth() java.sql.Time.setMonth(int) java.sql.Time.getYear() java.sql.Time.setYear(int)

The following deprecated constructors have been removed:

java.sql.Date(int, int, int) java.sql.Time(int, int, int) java.sql.Timestamp(int, int, int, int, int, int, int)

Note: the above lists are not exclusive; methods may appear in multiple lists.