java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • ORA-01009: missing mandatory parameter
    via by 3004,
  • 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
    via by Carlos Ramírez,
  • Error when using resultset.next();
    via by 3004,
  • 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
    via by Carlos Ramírez,
  • SQL Update Query | Jaspersoft Community
    via by Unknown author,
  • Beginning SQL statements with a parenthesis in JDBC
    via by Unknown author,
  • Sql generation error / comment error.
    via by razman52,
    • java.sql.SQLException: ORA-01009: missing mandatory parameter at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:797) at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:221) at StoreBean.getCategories(StoreBean.java:127) at _0002fViewCatalog_0002ejspViewCatalog_jsp_3._jspService(_0002fViewCatalog_0002ejspViewCatalog_jsp_3.java:88) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.java:130) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:282) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405) at org.apache.tomcat.core.Handler.service(Handler.java:287) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501) at java.lang.Thread.run(Thread.java:484)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor2 times, last one,
    rp
    1 times, last one,
    Unknown visitor1 times, last one,
    28 more bugmates