SEVERE: ORA-01009: missing mandatory parameter ---------------------------------------------- Key: HHH-125 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-125 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.0 beta 3 Environment: Hibernate 3 beta 3, Oracle 9i Reporter: Carlos Ramírez Assignee: Max Rydahl Andersen Attachments: CategoryData.java.zip, CategoryData21.zip 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