java.sql.SQLException: ORA-01400: cannot insert NULL into ("PIIUSER_JUNIT"."USAGE"."ID")

Oracle Community | user565514 | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Unique constraint under hibernate

    Oracle Community | 1 decade ago | user565514
    java.sql.SQLException: ORA-01400: cannot insert NULL into ("PIIUSER_JUNIT"."USAGE"."ID")
  2. 0

    [WG: Sakai QA] Trunk is down

    sakaiproject.org | 2 years ago
    java.sql.SQLException: ORA-01408: such column list already indexed
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    OracleDBSupport & sequence exception: bug?

    unitils | 9 years ago | upolin
    org.unitils.core.UnitilsException: Error while performing database update: select "W4SN\_TEST\_JM"."SEQ\_W4SN".NEXTVAL from DUAL
  5. 0

    Disabling constraints referenced by fk

    unitils | 9 years ago | d_richardson
    org.unitils.core.UnitilsException: Error inserting test data from DbUnit dataset for method public void my.services.PersonServiceDbUnitTest.simpleTest()

    3 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

      ORA-01400: cannot insert NULL into ("PIIUSER_JUNIT"."USAGE"."ID")

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OracleStatement.executeUpdate
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
      5. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206)
      6. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:945)
      7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1167)
      8. oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1613)
      9. oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1578)
      9 frames
    3. Commons DBCP
      DelegatingStatement.executeUpdate
      1. org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
      1 frame
    4. com.ericsson.pii
      AccessDaoHibernateImplSpringTest.testAggregateSingleAccesses
      1. com.ericsson.pii.dataaccessor.AccessDaoHibernateImpl.aggregateSingleAccesses(AccessDaoHibernateImpl.java:60)
      2. com.ericsson.pii.dataaccessor.AccessDaoHibernateImplSpringTest.testAggregateSingleAccesses(AccessDaoHibernateImplSpringTest.java:83)
      2 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:585)
      4 frames
    6. JUnit
      TestSuite.run
      1. junit.framework.TestCase.runTest(TestCase.java:154)
      2. junit.framework.TestCase.runBare(TestCase.java:127)
      3. junit.framework.TestResult$1.protect(TestResult.java:106)
      4. junit.framework.TestResult.runProtected(TestResult.java:124)
      5. junit.framework.TestResult.run(TestResult.java:109)
      6. junit.framework.TestCase.run(TestCase.java:118)
      7. junit.framework.TestSuite.runTest(TestSuite.java:208)
      8. junit.framework.TestSuite.run(TestSuite.java:203)
      8 frames
    7. JUnit3 Runner
      RemoteTestRunner.main
      1. org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)
      2. org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
      3. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
      4. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
      5. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
      6. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
      6 frames