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

jaspersoft.com | 8 months 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 Update Query | Jaspersoft Community

    jaspersoft.com | 8 months ago
    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 4 months ago
26 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:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.fetch
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
    4. oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1198)
    4 frames
  4. Oracle jdbc
    OracleResultSetImpl.next
    1. oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:276)
    1 frame
  5. dori.jasper.engine
    JRFillSubreport.run
    1. dori.jasper.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:112)
    2. dori.jasper.engine.fill.JRBaseFiller.next(JRBaseFiller.java:736)
    3. dori.jasper.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:167)
    4. dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:496)
    5. dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:405)
    6. dori.jasper.engine.fill.JRFillSubreport.run(JRFillSubreport.java:391)
    6 frames
  6. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:536)
    1 frame