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]