Key JDBC classes and interfaces
2-2 Oracle TimesTen In-Memory Database Java Developer's Guide
■ TimesTen JDBC extensions
■ Additional TimesTen classes and interfaces
For reference information on standard JDBC, see the following for information about
the
java.sql
package (the first for Java 6, the second for Java 5.0):
http://docs.oracle.com/javase/6/docs/api/java/sql/package-summary.html
http://docs.oracle.com/javase/1.5.0/docs/api/java/sql/package-summary.html
For reference information on TimesTen JDBC extensions, refer to Oracle TimesTen
In-Memory Database JDBC Extensions Java API Reference.
Package imports
You must import the standard JDBC package in any Java program that uses JDBC:
import java.sql.*;
If you are going to use data sources or pooled connections, you must also import the
standard extended JDBC package:
import javax.sql.*;
You must import the TimesTen JDBC package:
import com.timesten.jdbc.*;
To use XA data sources for JTA, you must also import the following TimesTen
package:
import com.timesten.jdbc.xa.*;
Support for interfaces in the java.sql package
TimesTen supports the
java.sql
interfaces as indicated in Table 2–1, with
TimesTen-specific support and restrictions noted.
Also see "TimesTen JDBC extensions" on page 2-4.
Note: It is recommended that you use Java 6 with TimesTen. Java 6
is a more capable API, especially for handling LOBs.
Table 2–1 Supported java.sql interfaces
Interface in java.sql Remarks on TimesTen support
Blob
■ The
position()
method, which returns the position where a
specified byte pattern or BLOB pattern begins, is not supported.
■ Java 5.0 does not support
free()
or
getBinaryStream(pos,length)
, but TimesTen provides them as
extensions. They are standard in Java 6.
CallableStatement
■ You must pass parameters to
CallableStatement
by position, not
by name.
■ You cannot use SQL escape syntax.
■ There is no support for
Array
,
Struct
, or
Ref
.
■ There is no support for
Calendar
for
setDate()
,
getDate()
,
setTime()
, or
getTime()
.
剩余111页未读，继续阅读
