Hi, See also: http://share.whichever.com/ where you can find all kinds of valuable Village related info including the entire source.
by the way, I heard that the oracle jdbc driver limits the size of LOB data to 4000B, which I'm still not sure whether this info is correct. Is this information correct? I want to insert large text data into the database, like up to 1MB. is there a way(besides using datadirect's driver) to do this with oracle? I'm quite new to Oracle and am struggling to find a way... Regards, Shin O. >> -----Original Message----- >> From: Felipe Ramos [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, December 17, 2003 6:39 PM >> To: Apache Torque Users List >> Subject: Re: Problem with CLOB retreival >> >> >> 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.ht >> >ml >> > >> >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] >> ------------------------ >> >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]