java.sql.SQLException: ORA-01009: missing mandatory parameter

Google Groups | razman52 | 8 years 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

    Sql generation error / comment error.

    Google Groups | 8 years ago | razman52
    java.sql.SQLException: ORA-01009: missing mandatory parameter
  2. 0

    SEVERE: ORA-01009: missing mandatory parameter This error ocurs when I try to load an object with a many-to-many relationship with itself. This task worked in Hibernate 2.1.7 with and Hibernate 3 beta 3 with Hypersonic but no with Hibernate beta 3 Oracle. This is the stack trace: INFO: Error performing load command org.hibernate.exception.GenericJDBCException: could not load an entity: [CategoryData#5] at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92) at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.loadEntity(Loader.java:1180) at org.hibernate.loader.EntityLoader.load(EntityLoader.java:135) at org.hibernate.loader.EntityLoader.load(EntityLoader.java:121) at org.hibernate.persister.BasicEntityPersister.load(BasicEntityPersister.java:2339) at org.hibernate.event.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:359) at org.hibernate.event.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:340) at org.hibernate.event.DefaultLoadEventListener.load(DefaultLoadEventListener.java:159) at org.hibernate.event.DefaultLoadEventListener.load(DefaultLoadEventListener.java:132) at org.hibernate.event.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:111) at org.hibernate.impl.SessionImpl.immediateLoad(SessionImpl.java:737) at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:59) at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:80) at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:115) at CategoryData$$EnhancerByCGLIB$$26b33c88.toString(<generated>) at java.lang.String.valueOf(String.java:2577) at java.io.PrintStream.print(PrintStream.java:616) at java.io.PrintStream.println(PrintStream.java:753) at CategoryData.getData(CategoryData.java:330) at CategoryData.main(CategoryData.java:250) Caused by: java.sql.SQLException: ORA-01009: missing mandatory parameter at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1199) at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:295) at org.hibernate.loader.Loader.doQuery(Loader.java:366) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:195) at org.hibernate.loader.Loader.loadEntity(Loader.java:1171) ... 18 more

    Hibernate JIRA | 1 decade ago | Carlos Ramírez
    org.hibernate.exception.GenericJDBCException: could not load an entity: [CategoryData#5]
  3. 0

    ORA-01009: missing mandatory parameter

    Oracle Community | 2 decades ago | 843833
    java.sql.SQLException: ORA-01009: missing mandatory parameter
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ORA-01009: missing mandatory parameter

    Oracle Community | 2 decades ago | 843833
    java.sql.SQLException: ORA-01009: missing mandatory parameter
  6. 0

    Error when using resultset.next();

    Oracle Community | 2 decades ago | 3004
    java.sql.SQLException: ORA-01009: missing mandatory parameter

  1. rp 1 times, last 5 months ago
27 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-01009: missing mandatory parameter

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.fetch
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
    4. oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
    4 frames
  4. Oracle jdbc
    OracleResultSetImpl.next
    1. oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:244)
    1 frame
  5. workbench.storage
    DataStore.initData
    1. workbench.storage.DataStore.initData(DataStore.java:1111)
    1 frame
  6. workbench.sql
    SqlCommand.processResults
    1. workbench.sql.SqlCommand.processResults(SqlCommand.java:410)
    1 frame
  7. workbench.sql.commands
    SelectCommand.execute
    1. workbench.sql.commands.SelectCommand.execute(SelectCommand.java:126)
    1 frame
  8. workbench.sql
    StatementRunner.runStatement
    1. workbench.sql.StatementRunner.runStatement(StatementRunner.java:380)
    1 frame
  9. workbench.gui.sql
    SqlPanel$11.run
    1. workbench.gui.sql.SqlPanel.displayResult(SqlPanel.java:2586)
    2. workbench.gui.sql.SqlPanel.runStatement(SqlPanel.java:1707)
    3. workbench.gui.sql.SqlPanel$11.run(SqlPanel.java:1675)
    3 frames