I have tried Bruce's idea but got an error:
java.sql.SQLException: No suitable driver
I changed from thin to OCI8 as suggested. The error seems to be when I tried to get the jdo. When I changed back to thin, it ran a ok, accept for the 4k clob limit that is.
Daniel, I'm not very familiar with oracle and don't quite understand the TNS-NAMES.ora thing that you mentioned. Can you please explain?
Any help is appreciated. Thanks,
hamdi
Daniel Honig wrote:
Bruce,----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
Your forgetting the whole part about TNS-NAMES.ora and
ensuring that the jdbc:url matches the instance/SID for
that is declared in the TNS-NAMES.ora file.
-Daniel
-----Original Message-----
From: Bruce Snyder [mailto:ferret@;frii.com]
Sent: Monday, October 21, 2002 2:59 PM
To: [EMAIL PROTECTED]
Subject: Re: [castor-dev] Have problem with oracle clob bigger than 4k
This one time, at band camp, Hamdi Mohs Yusof said:
HMY>I have a problem with accessing an oracle's clob field to store text
HMY>bigger than 4k. I don't have any problem with mysql's text field. I have
HMY>searched the archived mailling list but have not found a suitable work
HMY>around.
Hamdi,
Are you using Oracle's thin driver or the OCI driver. When I worked with
LOBs I had to make use of the OCI driver. It's as simple as changing
the URL in the database descriptor from this:
jdbc:oracle:thin:@<SID>
to this:
jdbc:oracle:OCI8:@<SID>
As long as you're using classes12.zip, the change of this URL should
be unnoticable.
Bruce
--
perl -e 'print
unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
