Re: Problem with CLOB retreival

Felipe Ramos Wed, 17 Dec 2003 02:42:35 -0800

Thank you very much Jaya

It's very interesting for me.

Jaya wrote:

Hi,

I got the info from this mailing list archive only. Please
see the link

http://www.mail-archive.com/[EMAIL PROTECTED]/msg07213.html

In villagexxx.jar you can find a class named Value.java where we have to
include the code given below by Shin Ohkubo. Make jar again and use it.

You can get the source code for village from CVS  as given in the link
http://share.whichever.com/index.php?SCREEN=village

Hope this helps you.

Regards,
Jaya


-----Original Message-----
From: Felipe Ramos [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 2:13 PM
To: Apache Torque Users List
Subject: Re: Problem with CLOB retreival

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]
------------------------


---------------------------------------------------------------------
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] ------------------------

Re: Problem with CLOB retreival

Reply via email to