AW: [Helma-user] oracle, jdbc & CLOB

[manfred.andres at orf.at]

Hi paul.

Here is a short excerpt from one mail describing the solution to this problem (it's the content of the db.properties):
>Dbname.url=url-to-db
>Dbname.user=user
>Dbname.password=passwd
>Dbname.SetBigStringTryClob=true
>Dbname.SomeOtherJdbcProp=TheValueToThisProperty
>....
>
>(SetBigStringTryClob=true must be set to insert more than 4k into
>oracle-columns...)

It is possible to add any JDBC-Parameter with this schema of the db.properties and the one you are looking for is
SetBigStringTryClob=true

Ojdbc14.jar is the correct name, but do you have the correct file? We found two different versions (all downloaded from oracle) having different file-sizes. The correct file size is 1352918 bytes... I think the wrong one was smaller...

There are some other implications for this switch:
SetBigStringTryClob  boolean  
Setting this property to "true" forces PreparedStatement.setString() method to use setStringForClob() if the data is larger than 32765 bytes. Please note that using this method with VARCHAR and LONG columns may cause large data to be truncated silently, or cause other errors differing from the normal behavior of setString().
(Taken from: http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm other jdbc-properties may also be found at this location)

Cu

Manfred


-----Ursprüngliche Nachricht-----
Von: helma-user-bounces at helma.org [mailto:helma-user-bounces at helma.org] Im Auftrag von Paul Alexandrow
Gesendet: Freitag, 20. August 2004 14:22
An: helma-user at helma.org
Betreff: [Helma-user] oracle, jdbc & CLOB


Hi List,

a few months ago there was a discussion between Manfred and Hannes (hope I didn't forget about somebody) about INSERTing and UPDATEing CLOB fields with more than 4k chars in Oracle (at least that problem was mentioned in that discussion). The reason I'm writing is that I encounter the very same problem right now and like to ask if anybody already found a solution to this (which i suppose) and would be so kind to share it with me.

paul

PS: im using ojdbc14.jar / thin


_______________________________________________
Helma-user mailing list
Helma-user at helma.org http://helma.org/mailman/listinfo/helma-user