Oracle JDBC driver

From: Sudarshan Sampath <ssampath_at_scr.siemens.com>
Date: Tue, 26 Jun 2001 14:00:35 -0400
Message-ID: <584_6.11143$DW1.462627@iad-read.news.verio.net>

Has anyone tried to use java.sql package to query a CLOB column from an Oracle database?

I have been using the OracleResultSet class to query the CLOB column. Just wanted to find out if there was a way to query a Clob column from Oracle table
using the Clob datatype in java.sql.

With Oracle jdbc driver classes (with the Oracle datatype):

CLOB m_clob = ((OracleResultSet) rs).getCLOB("Column_name");

instead is there a way to do it using java.sql package (with the Java SQL datatype):

Clob m_clob = rs.getClob("Column_name");

It hangs and exits if I try the above statement with no errors or exceptions. I am not
sure if what I am doing is right or wrong. I am trying this from the IBM Websphere
Servlet environment.

Any pointers?

Thanks,

-Sudarshan Received on Tue Jun 26 2001 - 13:00:35 CDT