java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement \[delete from REPORTSTATS\] Here is the stack trace:

hsqldb | sreeramrt | 1 decade ago
  1. 0

    Comparison of performance with MySQL

    hsqldb | 1 decade ago | sreeramrt
    java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement \[delete from REPORTSTATS\] Here is the stack trace:
  2. 0

    Hibernate Community • View topic - Exception not throw (java.sql.SQLException)

    hibernate.org | 4 months ago
    java.sql.SQLException: Integrity constraint violation: UG_G_FKEY table: NOM_GROUP in statement [insert into nom_user_group (user_id, group_id) values (30, 1)]
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Errors after DataIntegrityViolationException

    springframework | 1 decade ago | garethmorgan
    java.sql.SQLException: Violation of unique index: SYS\_IDX\_2 in statement \[insert into users (userId, password, name, email, uid) values ('gm2', 'gm2', 'G2 Morgan', 'gaz@test.com', 3)\]
  5. 0

    Cause: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] Stack Trace: [hide] org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeUpdate(Unknown Source) at org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:598) at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2382) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2340) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2204) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)

    Atlassian JIRA | 1 decade ago | Dave Loeng [Atlassian]
    java.sql.SQLException: Integrity constraint violation: FK6382C059598614D0 table: CONTENT in statement [delete from SPACES where SPACEID=3]

    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

      S1000 General error java.lang.NullPointerException in statement \[delete from REPORTSTATS\] Here is the stack trace:

      at org.hsqldb.Index.set()
    2. HSQLDB
      jdbcPreparedStatement.executeUpdate
      1. org.hsqldb.Index.set(Unknown Source)
      2. org.hsqldb.Index.replace(Unknown Source)
      3. org.hsqldb.Index.delete(Unknown Source)
      4. org.hsqldb.Table.deleteNoCheck(Unknown Source)
      5. org.hsqldb.Table.deleteNoRefCheck(Unknown Source)
      6. org.hsqldb.Table.delete(Unknown Source)
      7. org.hsqldb.Table.delete(Unknown Source)
      8. org.hsqldb.CompiledStatementExecutor.executeDeleteStatement(Unknown Source)
      9. org.hsqldb.CompiledStatementExecutor.executeImpl(Unknown Source)
      10. org.hsqldb.CompiledStatementExecutor.execute(Unknown Source)
      11. org.hsqldb.Session.sqlExecute(Unknown Source)
      12. org.hsqldb.Session.execute(Unknown Source)
      13. org.hsqldb.jdbcPreparedStatement.executeUpdate(Unknown Source)
      13 frames