Data size bigger than max size for this type

[ricsouzamoura]

This error occurs when I use setString in JDBC because there is a restriction of data size: 4000 bytes
I am using SqlUpdate to insert a registry in the database and the setters method are implicit to me...
I read about a solution: to use setCharacterString
But, how the setters method are implicit I don't get change the setString method to setCharacterString in this situations.
Does somebody have any solutions ?

Thanks in advance

[nyname00]

Hi,
are you using the Oracle 9i drivers (odbc14.jar)?. If so, try to switch to the Oracle 10 drivers, as far as i know there should not be such a 4K limit.

regards,
Mario

[graeder]

I'm also receiving this error when trying to insert a BLOB over 4k into an oracle table. I'm using NamedParameterJdbcDaoSupport and issuing an insert with a Map of parameters, one of which is a byte[] for the BLOB column. I did upgrade my oracle driver to 10.2.0 as recommended by this post and it did not seem to help.

Any other advice?

[martynhiemstra]

I have just downloaded the most recent version of the odbc14.jar file and now it works