Oracle Jdbc Exception?

From: Jeffery Cann <Jeffery_Cann_at_mcgraw-hill.com>
Date: Thu, 28 Oct 1999 11:32:49 -0600
Message-ID: <381888C1.6E291016_at_mcgraw-hill.com>



Hello.

[Quoted] I am using the Oracle Jdbc drivers (classes111.zip) and an Oracle 7.3.x database. In the database, I am storing serialized Java objects as byte streams into LONG RAW (binary) columns.

Occasionally, I have observed the following exception:

    java.sql.SQLException: Bigger type length than Maximum

It would appear that a particular serialized object is too big for the LONG RAW column. However, the size of the serialized objects in question is no where near the 2 GB maxmimum size.

Based on the stack trace (below) I suspect that Oracle's Jdbc driver has a maxmimum buffer size for the PreparedStatment.setBytes( ) method.

Has anyone else run into this problem? If so, is there a workaround for Oracle 7.3.x running the JDBC 1.0 drivers (classes111.zip)?

Thanks.
Jeffery Cann

  • stack trace ---------------------------------------- java.sql.SQLException: Bigger type length than Maximum at java.lang.Throwable.fillInStackTrace(Native Method) at java.lang.Throwable.fillInStackTrace(Compiled Code) at java.lang.Throwable.<init>(Compiled Code) at java.lang.Exception.<init>(Compiled Code) at java.sql.SQLException.<init>(SQLException.java:82) at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:425) at oracle.jdbc.ttc7.TTCInBuffer.buffer2Value(Compiled Code) at oracle.jdbc.ttc7.TTCInBuffer.get4Bytes(Compiled Code) at oracle.jdbc.ttc7.TTIMsg.unmarshalUB4(Compiled Code) at oracle.jdbc.ttc7.TTIrid.unmarshal(Compiled Code) at oracle.jdbc.ttc7.TTIoer.unmarshal(Compiled Code) at oracle.jdbc.ttc7.Oopen.receive(Compiled Code) at oracle.jdbc.ttc7.TTC7Protocol.open(Compiled Code) at oracle.jdbc.driver.OracleStatement.<init>(Compiled Code) at oracle.jdbc.driver.OraclePreparedStatement.<init>(Compiled Code) at oracle.jdbc.driver.OracleConnection.prepareStatement(Compiled Code)
Received on Thu Oct 28 1999 - 19:32:49 CEST

Original text of this message