Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
Hibernate version: 2.1.8
Name and version of the database you are using: Oracle 10g
The generated SQL (show_sql=true):
Code:
select count(bfo) from com.module.bfo.BFO bfo where bfo.currentStatus = 'AFFIRMED_REJECTED' AND bfo.orderHeaderDetails.communicationType='SWIFT' AND bfo.currentStatusDateTime >= ?, parameter1 = Wed May 02 00:00:00 BST 2007
Full stack trace of any exception that occurs:Code:
INFO | jvm 1 | 2007/05/02 12:21:12 | [02/05/07 12:21:12][olThread-9][ERROR] net.sf.hibernate.util.JDBCExceptionReporter - Could not execute query
INFO | jvm 1 | 2007/05/02 12:21:12 | java.sql.SQLException: ORA-01001: invalid cursor
INFO | jvm 1 | 2007/05/02 12:21:12 |
INFO | jvm 1 | 2007/05/02 12:21:12 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
INFO | jvm 1 | 2007/05/02 12:21:12 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
INFO | jvm 1 | 2007/05/02 12:21:12 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
INFO | jvm 1 | 2007/05/02 12:21:12 | at oracle.jdbc.driver.T4C8Odscrarr.receive(T4C8Odscrarr.java:203)
[02/05/07 12:21:12][olThread-9][ERROR] net.sf.hibernate.util.JDBCExceptionReporter - Could not execute query
java.sql.SQLException: ORA-01001: invalid cursor
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Odscrarr.receive(T4C8Odscrarr.java:203)
at oracle.jdbc.driver.T4CPreparedStatement.do_describe(T4CPreparedStatement.java:364)
at oracle.jdbc.driver.OracleStatement.get_column_index(OracleStatement.java:3037)
at oracle.jdbc.driver.OracleResultSetImpl.findColumn(OracleResultSetImpl.java:1861)
at oracle.jdbc.driver.OracleResultSet.getInt(OracleResultSet.java:1605)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:236)
at net.sf.hibernate.type.IntegerType.get(IntegerType.java:18)
at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62)
at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53)
at net.sf.hibernate.hql.QueryTranslator.getResultColumnOrRow(QueryTranslator.java:1000)
at net.sf.hibernate.loader.Loader.getRowFromResultSet(Loader.java:238)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:281)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1033)
at net.sf.hibernate.loader.Loader.list(Loader.java:1024)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1544)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1521)
at com.ui.core.taglib.QueryTag.doQuery(QueryTag.java:308)
at com.ui.core.taglib.QueryTag.doEndTag(QueryTag.java:154)
Thanks for any help
chucky
----------