SQLException: "Data size bigger than... "

From: <ikoerber_at_my-dejanews.com>
Date: Fri, 14 May 1999 07:07:24 GMT
Message-ID: <7hgi3c$kia$1@nnrp1.deja.com>

Hi,
when I set a String with setObject(int, Object) in a PreparedStatement, I get the SQLException:

"Data size bigger than max size for this type"

The oracle data type is LONG. The exception occurs only when the string is longer than 4kBytes.
I haven't found any information about the maximum size of a java String which i can set with setObject. I know that the oracle data type LONG type is mapped to JDBC data type LONGVARCHAR. But isn't there enough space for a string when using this type. Something near 1GigaByte ???
We are using oracle 8.0.4 database with the oracle thin JDBC driver.
Has someone an idea ?

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Fri May 14 1999 - 02:07:24 CDT