[jdjlist] Re: CLOB in Java

[John O'Sullivan]

Title: RE: [jdjlist] Re: CLOB in Java

This is a very good discussion thread.     You just gave me an idea.  We can institute a discussion thread rating system!  It would be the first of its kind!  The subject line of a post will include the “rating”.  That way you can just delete all threads that fall below your rating threshold.  You don’t have to open and read everything.  We will not need a moderator at all.   When you post you assign what you think the rating should be.  Subsequent thread posters can bounce the rating up or down.   As a group, all we need to do is come up with the rating criteria.   This should be a real hoot!!  Who wants to take the first stab at it?          -----Original Message----- From: Greg Nudelman [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 12:54 PM To: JDJList Subject: [jdjlist] Re: CLOB in Java   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 ____________________________________________________ ____________________________________________________ To change your JDJList options, please visit: http://www.sys-con.com/java/list.cfm Save Bandwidth! Clean up your posts before replying ____________________________________________________