java.sql.BLOB and Oracle 8i

Does anyone know if its possible to use the java.sql.BLOB class using Oracle 8i? Article 68349.1 on Metalink says:

  Oracle.sql.BLOB and oracle.sql.CLOB are datatypes that are supported   by the JDBC 2.0 standard. As such, these datatypes will implement   java.sql.BLOB and java.sql.CLOB when the JDBC 2.0 standard is available.   This standard for JDBC is part of the JDK 1.2 release.

  Since the 8i release of the JDBC drivers is JDBC 1.22 and JDK 1.1.6   compliant, the oracle.sql.BLOB and oracle.sql.CLOB classes do not   implement java.sql.BLOB and java.sql.CLOB interfaces because they   are not present in the classes.zip file that comes with the JDK 1.1.x.

  To get around this and to offer support of the JDBC 2.0 features that   pertain to LOB datatypes, Oracle has placed JDBC 2.0 compliant   interfaces to LOB datatypes in the oracle.jdbc2 package. This package   can be found in classes111.zip.

  The oracle.sql.BLOB and oracle.sql.CLOB datatypes implement the interfaces   oracle.jdbc2.Blob and oracle.jdbc2.Clob, respectively. In a future   release of Oracle, LOB types will implement java.sql.* interfaces.

The article is dated 05-FEB-1999 so the situation may have changed since then. The current JDBC versions on otn.oracle.com are for JDK 1.2 so it sounds like its still not possible to use the java.sql.BLOB class, even though i can create these classes in JDeveloper.

Thanks,

Andy Received on Sun Dec 02 2001 - 08:09:18 CST