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
|
