java.sql.SQLException: Data size bigger than max size for this type: 4036

Oracle Community | 3004 | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    ClassCastException w/ BLOB

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: Data size bigger than max size for this type: 4036
  2. 0

    Store a Blob from Java to BD: Data size bigger than max size for this type when is clearly not

    Stack Overflow | 4 years ago | jsedano
    java.sql.SQLException: Data size bigger than max size for this type</strong> </p> <p>That is oh so very frustrating..</p> <p>I have tried to do the following and fails...</p> <pre><code>oracleCallableStatement.setBinaryStream(3, new ByteArrayInputStream(someByteArray), someByteArray.length); </code></pre> <p>I get the same error with:</p> <pre><code>oracleCallableStatement.setBytes(3, someByteArray); </code></pre> <p>I also changed the oracle driver, since I read web pages like this:</p> <p><a href="http://www.coderanch.com/t/457770/JDBC/databases/java-sql-sqlexception-data-size" rel="nofollow">http://www.coderanch.com/t/457770/JDBC/databases/java-sql-sqlexception-data-size</a></p> <p>Says that there's a bug, I updated it to ojdbc5.jar From: <a href="http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html" rel="nofollow">http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html</a></p> <p>But the problem is persistent</p> <p>The DB is an Oracle 11g JavaEE is 1.5 running in Glassfish 2.1</p> <p>Well, I guess that's it, my someByteArray is not bigger than 4Gb! it has a length of 38678 </p> <p>EDIT: The exception is firing before the execute.. it fires when I set an attribute for the OracleCallableStatement</p> <p>Portion of the stack trace:</p> <pre><code>at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
  3. 0

    Mapping BLOB fields in Oracle

    Google Groups | 1 decade ago | owe...@us.ibm.com
    java.sql.SQLException: La taille des données est supérieure à la taille max. pour ce type: 9892DSRA0010E: Etat SQL = null, Code d'erreur = 17,070
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Java Netbeans stacktrace encoding

    Stack Overflow | 4 days ago | abc
    java.sql.SQLException: Ïðåâûøåí ðàçìåð äàííûõ, ðàçðåøåííûé äëÿ ýòîãî òèïà: 45804
  6. 0

    Java upload zip with entries (BLOB) to Oracle

    Stack Overflow | 4 days ago | I use apache stuff a lot
    java.sql.SQLException: Ïðåâûøåí ðàçìåð äàííûõ, ðàçðåøåííûé äëÿ ýòîãî òèïà: 45804
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Data size bigger than max size for this type: 4036

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    2. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
    2 frames
  3. oracle.jdbc.ttc7
    TTCItem.setArrayData
    1. oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:95)
    1 frame
  4. oracle.jdbc.dbaccess
    DBDataSetImpl.setBytesBindItem
    1. oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2413)
    1 frame
  5. Oracle jdbc
    OraclePreparedStatement.setBinaryStream
    1. oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1166)
    2. oracle.jdbc.driver.OraclePreparedStatement.setBinaryStream(OraclePreparedStatement.java:2598)
    2 frames
  6. weblogic.jdbc.wrapper
    PreparedStatement.setBinaryStream
    1. weblogic.jdbc.wrapper.PreparedStatement.setBinaryStream(PreparedStatement.java:289)
    1 frame
  7. com.iits.pulsar
    OracleDictionary.blobToPreparedParameter
    1. com.iits.pulsar.jdo.OracleDictionary.blobToPreparedParameter(OracleDictionary.java:76)
    1 frame