Hi Bill, Thank you very much for your kind and valuable reply. However, this mailing list seems to unaccept attached files; Would it be possible for you to send the file directly via e-mail to me? My e-mail is [EMAIL PROTECTED]
I am looking forward to hearing from you. Thank you very much in advance, Best regards, Shin Ohkubo -----Original Message----- From: Bill Leng [mailto:[EMAIL PROTECTED] Sent: Thursday, December 18, 2003 1:00 AM To: Apache Torque Users List Subject: Re: Problem with CLOB retreival Hope this email helps. The root cause is Oracle's jdbc driver does not conform jdbc specc. In fact, most jdbc drivers do not conform jdbc spec when dealing with clob or blob but oracle is nortoriously bas in this regard. Per spec, you should be able to PreparedStatement.setClob or setBlob. However, this is not the way oracle driver works. You must call setBlob to set an empty Blob. The select that blob and update its content. This means that you need to operations instead one. village is written per jdbc spec and of cource it does not work. To make it work, two solutions. 1. use a third party jdbc driver, such as DataDirect's jdbc driver (it is expensive though).. Or 2. make changes to village to introduce oracle specific stuff which was what I did. Try the attached village.jar. It should work with oracle blob. I did not try to fix clob because for English they are equivalent. You should unpack the jar and modify the oracle.properties file. Shin Ohkubo wrote: 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] -- Bill Leng Sr. Software Engineer Metatomix, Inc. Tel: (901)261-8911 Fax: (901)261-8901 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]