Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> java.sql.SQLException: Bigger type length than Maximum

java.sql.SQLException: Bigger type length than Maximum

From: Pavel Klimochkin <pavelk_at_netscape.com>
Date: Tue, 19 Sep 2000 21:07:51 -0700
Message-ID: <39C83816.5A08CA82@netscape.com>

Here's a stack trace. Can anyone explain why this happens and what the remedy is? I'm using Oracle 8.1.6 and JDBC 2.0.

There are 6 queries, that result in 6 files. Same code runs all 6 quries. Last file is not
being exported due to SQLException thrown by ResultSet::next(). If I only run 1
query for the file that failed, than everything is fine. Each query returns over 20000
rows.

Thank you.

java.sql.SQLException: Bigger type length than Maximum

        at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)

        at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)

        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:803)
        at oracle.jdbc.ttc7.MAREngine.buffer2Value(MAREngine.java:1987)
        at oracle.jdbc.ttc7.MAREngine.unmarshalUB4(MAREngine.java:849)
        at oracle.jdbc.ttc7.MAREngine.unmarshalDALC(MAREngine.java:1831)

        at oracle.jdbc.ttc7.NtyTTCItem.unmarshal(NtyTTCItem.java:112)
        at

oracle.jdbc.ttc7.NonPlsqlTTCColumn.unmarshal(NonPlsqlTTCColumn.java:134)

        at
oracle.jdbc.ttc7.NonPlsqlTTCDataSet.unmarshalRow(NonPlsqlTTCDataSet.java:138)

        at oracle.jdbc.ttc7.TTIrxd.unmarshal(TTIrxd.java:138)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:489)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311)

        at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:797)
        at

oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:221)

my code that makes call to next. Received on Tue Sep 19 2000 - 23:07:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US