Re: Problem with CLOB retreival

[Felipe Ramos]

I have some questions....

Changing the code in village? What's village?  Where I must retrieve the 
result as a oracle.sql.CLOB?

Could you please, give a list of steps to follow?  It would be wonderful !!

I really am very interesting in the same topic.

Jaya wrote:

Hi,

Thanks a lot. It is working by changing the code in village 
as you have said.

Regards,
Jaya.
-----Original Message-----
From: Shin Ohkubo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 5:59 AM
To: 'Apache Torque Users List'
Subject: RE: Problem with CLOB retreival
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]




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

--
------------------------
Felipe Ramos
Tissat SA
C/ Orense 34-9ª
28020 Madrid
Tel: (+34) 91 4175913 
Fax: (+34) 91 4172914
Mail: [EMAIL PROTECTED]
------------------------