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.html In villagexxx.jar you can find a class named Value.javawhere we haveto include the code given below by Shin Ohkubo. Make jaragain and useit. You can get the source code for village from CVS as givenin the linkhttp://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 mustretrievethe 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 isretrieved asa string. We tried some workarounds like changing thedata type toLONGVARBINARY in schema.xml. But it didn't work out. If any one knows the solution for this problem,pleaselet 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]