Three Oracle Packages


oracle.jdbc
Beginning in Oracle 9i, the Oracle extensions to JDBC are captured in the package oracle.jdbc, which contains classes and interfaces that specify the Oracle extensions in a manner similar to the way the classes and interfaces in java.sql specify the public JDBC API. Your code should use the package oracle.jdbc instead of the package oracle.jdbc.driver used in earlier versions of Oracle. By converting your code to use oracle.jdbc, you will be able to take advantage of future enhancements that use different implementation classes.

oracle.sql
A package of classes that represent Java SQL types and Oracle specific SQL types. Its classes include:

Class Description
BFILE A class for Oracle specific data type BFILE.
BLOB This class implements the java.sql.Blob interface in JDBC 2.0.
CHAR The Oracle specific representation of characters.
CLOB This class implements java.sql.Clob interface in JDBC.2.0.
DATE The DATE class
NUMBER The NUMBER class
RAW It is a representation of the Oracle RAW datatype.
REF It is a representation of the Oracle REF datatype, and it implements the java.sql.Ref interface.
ROWID It is a representation of the Oracle ROWID datatype.
TIMESTAMP The TIMESTAMP class

oracle.jdbc.pool
It is a package of connection cache and pooling related classes. One of its class OracleDataSource is a factory for Connection objects. Data sources are standard, general-use objects for specifying databases or other resources to use. The data source facility provides a complete replacement for the previous JDBC DriverManager facility.




      I broke my finger last week. On the other hand, I’m okay.