This is a very good discussion thread.
I know I may get a frown or two, but for a "small" CLOB I was able to use getString() in both the Oracle thin driver and Weblogic OCI. Strangely, when I tried to use streams, I encountered some difficulties -- I think it used to hang with one of the drivers, but this was a while ago, so I am not sure.
The only gotcha (as I see in my comments) was that the CLOB has to be the very first column in your query.
Greg
-----Original Message-----
From: Alastair Rodgers [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 27, 2002 5:30 AM
To: JDJList
Subject: [jdjlist] Re: CLOB in Java
I came across this problem too. It really annoyed me, since this was the only point in my app where I had to use the Oracle-specific classes directly in my code instead of just using the standard JDBC interfaces. I isolated the offending stuff into a 'LOBUpdater' class, so at least the implementation-specific bit was localised to one point in the code.
> -----Original Message-----
> From: David Gallardo [mailto:[EMAIL PROTECTED]]
>
> An important gotcha: Oracle's JDBC drivers do not completely
> implement the
> standard Blob and Clob interfaces. You should instead use
> Oracle's BLOB and
> CLOB types, which you can obtain from an OracleResultSet with
> methods the
> getBLOB() and getCLOB(). (Just cast your ResultSet to
> OracleResultSet to
> call these methods.) BLOB and CLOB have slightly different
> methods than
> Blob and Clob. Refer to the Oracle doc for details.
>
____________________________________________________
To change your JDJList options, please visit:
http://www.sys-con.com/java/list.cfm
Save Bandwidth! Clean up your posts before replying
____________________________________________________
To change your JDJList options, please visit:
http://www.sys-con.com/java/list.cfm
Save Bandwidth! Clean up your posts before replying
____________________________________________________
