Pattern selector

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

  1. OracleStatementWrapper.executeBatch() has thrown a BatchUpdateException
    Oracle JDBC Driver
    21
    3
    1
  2. Failed to execute batch
    Oracle JDBC Driver
    22
    3
    1

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
java.sql.BatchUpdateException: ORA-01400: Einfügen von NULL in ("TEST"."CONTENT_SLOT"."ID") nicht möglich
    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
    at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
    at org.eclipse.persistence.platform.database.oracle.Oracle10Platform.executeBatch(Oracle10Platform.java:69)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeJDK12BatchStatement(DatabaseAccessor.java:920)

Solution

Liam2 months ago

Exception message: ORA-01722: invalid number the number of update counts is 0 Count of no info success -2 Count of failed records -3

  • Problem during the conversion of String to Number.
  • This typically due to the supplied string value is not a number.
  • Ensure the string of characters are numbers, and not containing any letter, symbols or spaces.

External results for this pattern (10)

  1. OFR-IIASAvia GitHub2 months ago
    ORA-00001: unique constraint (ENE_IXMP.SYS_C0065938) violated
    Show stack trace
  2. ORA-01722: invalid number the number of update counts is 0 Count of no info success -2 Count of failed records -3
    Show stack trace
  3. Bruce Phillipsvia Apereo Issues3 months ago
    JDBC exception on Hibernate data access: SQLException for SQL [insert into UP_SEARCH_REQ_AGGR (AGGR_GROUP_ID, DATE_DIMENSION_ID, DURATION, AGGR_INTERVAL, TIME_DIMENSION_ID, STATS_COMPLETE, SEARCH_COUNT, SEARCH_TERM, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [12899]; could not execute batch; nested exception is org.hibernate.exception.GenericJDBCException: could not execute batch
    Show stack trace
  4. sgelabert-dgticvia GitHub3 months ago
    Could not execute JDBC batch update
    Show stack trace
  5. Gercek Advia Stack Overflow4 months ago
    Could not execute JDBC batch update
    Show stack trace
  6. TV Nathvia Stack Overflow4 months ago
    ORA-00001: unique constraint (QA_VPP.UX_TVPPC_TRAN_LOG_1) violated
    Show stack trace
  7. jezekpvia GitHub4 months ago
    Could not execute JDBC batch update; SQL [insert into EEGTEST.PERSON (FB_UID, GIVENNAME, SURNAME, DATE_OF_BIRTH, GENDER, LATERALITY, PHONE_NUMBER, NOTE, USERNAME, PASSWORD, AUTHORITY, REGISTRATION_DATE, CONFIRMED, AUTHENTICATION, DEFAULT_GROUP_ID, EDUCATION_LEVEL_ID, PERSON_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
    Show stack trace
  8. Vincent Chinvia Atlassian JIRA4 months ago
    There was an error during import/export with <unknown plugin> (table AO_ED979B_EVENTPROPERTY):
    Show stack trace