Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Message-ID: <3FE0244C.3060709@tissat.es>
Date: Wed, 17 Dec 2003 10:39:24 +0100
From: "Felipe Ramos" <framos@tissat.es>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
 rv:1.0.2) Gecko/20021120 Netscape/7.01
MIME-Version: 1.0
To: Apache Torque Users List <torque-user@db.apache.org>
Subject: Re: Problem with CLOB retreival
References: <OIEAKGAFBOPILCECBMDCAEEDCAAA.jaya@gft.com>
Content-Type: multipart/alternative;
 boundary="------------050702050407050901070303"

--------------050702050407050901070303
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

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/turbine-user@jakarta.apache.org/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:framos@tissat.es]
>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:sh.okubo@po1.iftc.co.jp]
>>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:Jayalakshmi@gft.com]
>>>>Sent: Tuesday, December 16, 2003 9:13 PM
>>>>To: torque-user@db.apache.org
>>>>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: torque-user-unsubscribe@db.apache.org
>>>>For additional commands, e-mail: torque-user-help@db.apache.org
>>>>
>>>>
>>>>
>>>>        
>>>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>For additional commands, e-mail: torque-user-help@db.apache.org
>>
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>For additional commands, e-mail: torque-user-help@db.apache.org
>>
>>
>>
>>
>>    
>>
>
>--
>------------------------
>Felipe Ramos
>Tissat SA
>C/ Orense 34-9�
>28020 Madrid
>Tel: (+34) 91 4175913
>Fax: (+34) 91 4172914
>Mail: framos@tissat.es
>------------------------
>
>
>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org
>
>
>  
>

-- 
------------------------
Felipe Ramos
Tissat SA
C/ Orense 34-9�
28020 Madrid
Tel: (+34) 91 4175913 
Fax: (+34) 91 4172914
Mail: framos@tissat.es
------------------------


--------------050702050407050901070303--