[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-125) SEVERE: ORA-01009: missing mandatory parameter

[Oliver Soul (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_29557 ] 

Oliver Soul commented on HHH-125:
---------------------------------

This issue also seems to occur when comments are within the sql statement itself.
Remove the inline comments and the issue goes away.

> 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
>  

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira