Pattern selector

Most relevant patterns first. Most helpful ones displayed. Click here to show all.

  1. AbstractBatcher.prepareStatement() has thrown a GenericJDBCException
    Hibernate
    0
    0
    0
  2. Failed Batch Update
    Oracle JDBC Driver
    25
    2
    4

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
java.sql.BatchUpdateException: ORA-12899: value too large for column "KSDEV"."KSLU_CLU_PUBL_VARI"."VARI_VALUE" (actual: 757, maximum: 255)
    at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343)
    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10768)
    at org.enhydra.jdbc.core.CorePreparedStatement.executeBatch(CorePreparedStatement.java:410)
    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
151 frames hidden

Solution

Liam2 months ago

Exception message: cannot insert NULL into ("SYSTEM"."USER_APPLICATION_ROLE"."ROLE_ID")

Problem: A null value of the columns cannot be inserted into the database table.

Solution:

  • The columns do not accept null value with the update statement to the database. Change the columns to a non-null value.
  • Use the “desc table_name” to check the descriptor of the table, and its columns definition.

Exception message: inconsistent datatypes: expected NUMBER got BINARY

Problem: Datatypes mismatch of what is being used on the update statement and what is being expected in the database.

Solution:

  • Change the data type being used to match the data type expected by the database table.
  • Verify the column data value and the data type from the database statement is not getting converted before reaching the database.

External results for this pattern (10)

  1. guchengodvia GitHub1 month ago
    ORA-00001: unique constraint (表A) violated
    Show stack trace
  2. Jemruvia Stack Overflow4 months ago
    Could not execute JDBC batch update
    Show stack trace
  3. Unknown authorvia ibm.com4 months ago
    ORA-04098: trigger 'MALL.USTG_MEMBER' is invalid is invalid and failed re-validation
    Show stack trace
  4. Unknown authorvia java2s.com4 months ago
    ORA-01407: cannot update ("MY_SCHEMA"."PAY"."EVENT_DT") to NULL
    Show stack trace
  5. giuliusvia Stack Overflow4 months ago
    org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
    Show stack trace
  6. Thomas Mortagnevia XWiki.org JIRA4 months ago
    ORA-01400: impossible d'insérer NULL dans ("WPR_PINT2_XWIKI"."XWIKIATTACHMENT_CONTENT"."XWA_CONTENT") ]]
    Show stack trace
  7. Renan Battaglinvia Atlassian JIRA4 months ago
    ORA-00001: unique constraint (SYSTEM.SYS_C005829) violated
    Show stack trace
  8. Arno Koehlervia Atlassian JIRA4 months ago
    Hibernate flushing: Could not execute JDBC batch update; uncategorized SQLException for SQL [update "SERVERPROPERTY" set "NAME"=?, "VALUE"=? where "ID"=?]; SQL state [72000]; error code [12899]; ORA-12899: value too large for column "CROWDUSER"."SERVERPROPERTY"."VALUE" (actual: 257, maximum: 255) ; nested exception is java.sql.BatchUpdateException: ORA-12899: value too large for column "CROWDUSER"."SERVERPROPERTY"."VALUE" (actual: 257, maximum: 255)
    Show stack trace