Re: [castor-dev] Have problem with oracle clob bigger than 4k

[Micka�l Guessant]

Hamdi Mohs Yusof wrote:

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.

... as long as you have the Oracle client installed and configured (not
needed in thin mode).

Maybe this link could help :
http://www.jguru.com/faq/view.jsp?EID=431031

"JDBC functionality is completely dependent on the functionality of the JDBC driver AND the underlying DBMS engine. At one time there was a 4k restriction on LOBs. It's not clear from the documentation exactly when this restriction was lifted, although it definitely has been by 8i, Release 2(8.1.6). Even so, there are other limitations and restrictions that can cause write problems for LOBs."

Hope this helps ;-)

--
Mickael Guessant

----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev