problem when using setStartAtIndex and setEndAtIndex for ReportQueryByCriteria

[Gao Jun <ga...@silicomp.com.sg>]

Hi,

I'm using the setStartAtIndex and setEndAtIndex for ReportQueryByCriteria.

Result set can be returned with the correct size. But a sql exception thrown
at the same time also.

 

The following the details of my environment/code/exception.

Anybody knows the reason please advice.

 

My environment:

Oralce: 9.2.0.6

Weblogic:  7.1 sp3

OJB: 1.0.2

 

Code:

ReportQueryByCriteria query  = QueryFactory.newReportQuery(someclass.class,
crit);

query.setColumns(array of columns);

query.setStartAtIndex(startAtIndex);

query.setEndAtIndex(endAtIndex);

Iterator iter = broker.getReportQueryIteratorByQuery(query);

 

(The code works fine. I can get the result set with the correct size.)

 

Exception:

SQLException: SQLState(null) vendor code(17068)

java.sql.SQLException: Invalid argument(s) in call: absolute (0)

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

        at
oracle.jdbc.driver.ScrollableResultSet.absolute(ScrollableResultSet.java:552
)

        at weblogic.jdbc.pool.ResultSet.absolute(ResultSet.java:478)

        at
weblogic.jdbc.rmi.internal.ResultSetImpl.absolute(ResultSetImpl.java:712)

        at
weblogic.jdbc.rmi.SerialResultSet.absolute(SerialResultSet.java:831)

        at
org.apache.ojb.broker.accesslayer.RsIterator.absolute(RsIterator.java:685)

        at
org.apache.ojb.broker.accesslayer.PagingIterator.<init>(PagingIterator.java:
81)

        at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIteratorFromQ
uery(PersistenceBrokerImpl.java:1969)

        at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIteratorByQue
ry(PersistenceBrokerImpl.java:1893)

        at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getReportQueryIterato
rByQuery(DelegatingPersistenceBroker.java:317)

        at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getReportQueryIterato
rByQuery(DelegatingPersistenceBroker.java:317)

        ....

 

Thanks!

Gao Jun