Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLException: "Data size bigger than... "
I am seeing a similar problem. If you scan the posts you'll see a few other
users complaining of similar, possibly related items.
Oracle tech suppt says the bug is "already filed" as #814621
I have seen what look like related reports of similar problems in the non-java ODBC drivers too.
Hope they fix this one soon...
B-T-W What the docs _say_ the Java->ODBC->Oracle data type mappings are is not necessarily what is implemented... The size limit looks suspiciously like that of a CHAR or VARCHAR parameter type...
Have you tried setBinaryStream(...) as an alternative? I bet you'll get an interesting exception...
Marc
<ikoerber_at_my-dejanews.com> wrote in message
news:7hgi3c$kia$1_at_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 - 19:25:14 CDT