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

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: 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

    Image insertion into database through JPA

    Coderanch | 6 years ago | Gvn Karthik
    java.sql.SQLException: Data size bigger than max size for this type: 180140 Error Code: 17070 Call: INSERT INTO ImageExample (ID, IMAGEFILE) VALUES (?, ?) bind => [987, [B@49d67c] Query: InsertObjectQuery(ImageExample@b25b9d)
  6. 0

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

    nabble.com | 2 years 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
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