RE: Problem with CLOB retreival

[Shin Ohkubo]

Hi,

I was facing the same problem the other day.
I retrieved the result as a oraqle.sql.CLOB, and then used the
getSubString method.

        Object o = rset.getObject(2);
        if (o instanceof CLOB) {
                CLOB clob = (CLOB) o;
                System.out.println("SOURCE Length: " + clob.length());
                String content = clob.getSubString(1, (int)
clob.length());
                System.out.println("SOURCE: " + content);
        }

hth,

SO

>> -----Original Message-----
>> From: Jaya [mailto:[EMAIL PROTECTED] 
>> Sent: Tuesday, December 16, 2003 9:13 PM
>> To: [EMAIL PROTECTED]
>> Subject: Problem with CLOB retreival
>> 
>> 
>> 
>> Hi,
>> 
>> We are using Torque with Oracle 8.1.7. But we are facing 
>> problem with CLOB retreival. It returns null when the column 
>> is retrieved as a string. We tried some workarounds like 
>> changing the data type to LONGVARBINARY in schema.xml. But 
>> it didn't work out.
>> 
>> If any one knows the solution for this problem,please let me know.
>> 
>> Thank You.
>> 
>> Regards,
>> Jaya.
>> 
>> 
>> 
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>> 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]