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

Oracle Community | 3004 | 1 decade ago
  1. 0

    ClassCastException w/ BLOB

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

    Large data inserts cause exception

    Oracle Community | 1 decade ago | 843859
    java.sql.SQLException: Data size bigger than max size for this type: 319629
  3. 0

    Problem While Storing BLOB

    Oracle Community | 1 decade ago | 430026
    java.sql.SQLException: Data size bigger than max size for this type: 6084
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ActiveMQ - User - Data size bigger than max size for this type

    nabble.com | 1 year ago
    javax.jms.JMSException: Failed to broker message: ID:abc2-2257-1175204828244-0:8:1:1:1 in container: java.sql.SQLException: Data size bigger than max size for this type: 63268
  6. 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)

    26 unregistered visitors
    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: 4009

      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.setObject
      1. oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1166)
      2. oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedStatement.java:2208)
      3. oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:3002)
      4. oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:3217)
      4 frames
    6. weblogic.jdbc.wrapper
      PreparedStatement.setObject
      1. weblogic.jdbc.wrapper.PreparedStatement.setObject(PreparedStatement.java:172)
      1 frame
    7. com.solarmetric.kodo
      PersistenceManagerImpl.commit
      1. com.solarmetric.kodo.impl.jdbc.schema.dict.AbstractDictionary.blobToPreparedParameter(AbstractDictionary.java:1110)
      2. com.solarmetric.kodo.impl.jdbc.schema.dict.OracleDictionary.blobToPreparedParameter(OracleDictionary.java:203)
      3. com.solarmetric.kodo.impl.jdbc.schema.dict.AbstractDictionary.toPreparedParameter(AbstractDictionary.java:840)
      4. com.solarmetric.kodo.impl.jdbc.sql.SQLValue.applyParameter(SQLValue.java:129)
      5. com.solarmetric.kodo.impl.jdbc.sql.SQLBuffer.setParameters(SQLBuffer.java:239)
      6. com.solarmetric.kodo.impl.jdbc.sql.SQLBuffer.setParameters(SQLBuffer.java:222)
      7. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.prepareStatementInternal(SQLExecutionManagerImpl.java:753)
      8. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executePreparedStatementNonBatch(SQLExecutionManagerImpl.java:445)
      9. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executePreparedStatement(SQLExecutionManagerImpl.java:423)
      10. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.executeInternal(SQLExecutionManagerImpl.java:381)
      11. com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.flush(SQLExecutionManagerImpl.java:255)
      12. com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.flush(JDBCStoreManager.java:554)
      13. com.solarmetric.kodo.runtime.PersistenceManagerImpl.flushInternal(PersistenceManagerImpl.java:697)
      14. com.solarmetric.kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:422)
      14 frames
    8. com.iits.sdb
      MaintainProducerRequestFacade.addProducerRequest
      1. com.iits.sdb.app.facade.MaintainProducerRequestFacade.addProducerRequest(MaintainProducerRequestFacade.java:106)
      1 frame