HQL Editor and max results

steinrr · **Joined:** Tue Mar 13, 2007 9:46 am **Posts:** 20

I have been using the HQL editor and it works great! The only problem I have is when I try to set the max results drop down to something else than blank. When running a query with e.g. the value 10 in the max results drop down, the Oracle driver returns an error.

The error is unfortunately in Norwegian, so I won't quote it here, but it says something generic about the IN and OUT parameters.

Any experiences with this?

max · **Posted:** Sun Apr 15, 2007 1:03 am

show the full stacktrace - i can read norwegian.

steinrr · **Joined:** Tue Mar 13, 2007 9:46 am **Posts:** 20

This is the stacktrace from the console in Eclipse:

Code:

2007-04-16 07:07:31,620 ERROR main org.hibernate.hql.PARSER - line 2:1: expecting IDENT, found 'null'
2007-04-16 07:07:31,698 WARN main org.hibernate.hql.ast.HqlParser - processEqualityExpression() : No expression to process!
2007-04-16 07:07:32,559 ERROR main org.hibernate.hql.PARSER - <AST>:1:68: unexpected AST node: .
2007-04-16 07:07:34,062 ERROR main org.hibernate.hql.PARSER - <AST>:1:68: unexpected AST node: .
2007-04-16 07:07:37,583 ERROR main org.hibernate.hql.PARSER - <AST>:1:68: unexpected AST node: .
2007-04-16 07:08:10,062 WARN main org.hibernate.util.JDBCExceptionReporter - SQL Error: 17041, SQLState: null
2007-04-16 07:08:10,062 ERROR main org.hibernate.util.JDBCExceptionReporter - Manglende IN- eller OUT-parameter i indeks:: 1

It might seem that Oracle expects some parameters that are not fed to it.

max · **Posted:** Mon Apr 16, 2007 2:42 am

looks like no query was even found.....could you show some more of that log ?

steinrr · **Joined:** Tue Mar 13, 2007 9:46 am **Posts:** 20

More trace:

Code:

!SUBENTRY 2 org.hibernate.eclipse.console 4 150 2007-04-13 22:58:28.527
!MESSAGE java.sql.SQLException: Manglende IN- eller OUT-parameter i indeks:: 1
!STACK 0
java.sql.SQLException: Manglende IN- eller OUT-parameter i indeks:: 1
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
   at oracle.jdbc.driver.OracleStatement.checkBindsInAndOut(OracleStatement.java:2000)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2924)
   at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
   at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:584)
   at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
   at org.hibernate.loader.Loader.getResultSet(Loader.java:1724)
   at org.hibernate.loader.Loader.doQuery(Loader.java:662)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
   at org.hibernate.loader.Loader.doList(Loader.java:2157)
   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2041)
   at org.hibernate.loader.Loader.list(Loader.java:2036)
   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:388)
   at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
   at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
   at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
   at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
   at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:49)
   at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:110)

max · **Posted:** Mon Apr 16, 2007 2:52 am

would be good with more from the error log from before those lines. should show the actual sql being executed

steinrr · **Joined:** Tue Mar 13, 2007 9:46 am **Posts:** 20

This is the complete stacktrace from the Eclipse log. No SQL here:

Code:

Removed

max · **Posted:** Mon Apr 16, 2007 3:15 am

hmmm...what about the console log you posted from initially ? does it only contain those 6-7 lines ?

if yes, then please locate the hibernate-log4j.properties in plugins/org.hibernate.eclipse/ and turn up the log level to get some more ;)

steinrr · **Joined:** Tue Mar 13, 2007 9:46 am **Posts:** 20

Here you go:

Code:

Removed

max · **Posted:** Mon Apr 16, 2007 4:22 am

thanks - now i know where to look.

surprised that oracle fails on this since hsqldb and mysql works fine. Guess i'll need to investigate directly on oracle db now.

steinrr · **Joined:** Tue Mar 13, 2007 9:46 am **Posts:** 20

Hi!

Ok - thx. Is it correct to assume that no value is provided for the rownum-parameter?

max · **Posted:** Mon Apr 16, 2007 5:10 am

well that is how it looks like, but the logic in the code is to only start doing "select * (original query)" if we actually call the setMaxResults....so something is weird ;)

steinrr · **Joined:** Tue Mar 13, 2007 9:46 am **Posts:** 20

Anything new on this?

max · **Posted:** Thu Apr 26, 2007 6:05 am

i have not had time to look into it and now you have removed the stacktraces so i can't recall where the error was.

Could you please put it in jira so i/we won't forget it ?