Hi Armin,
> It could be a jdbc-driver problem
It seems that it is really a driver problem.
We changed the driver to the latest version and the exception changed too. ;)
The exception comes directly from the jdbc driver.
Here is the stack trace in full:
11.11.2005 18:06:41 [ERROR]
de.mhr.wis.DBAdapter.ojbAdapter.management.OjbLogBook - getFirstEntry(Integer
weaId):
org.apache.ojb.broker.PersistenceBrokerSQLException: SQLException during the
execution of the query (for de.mhr.wis.DBAdapter.rawdata.analyses.Logbuch):
Cannot write sorted rows.
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:349)
at
org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:185)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1918)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1493)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1620)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(DelegatingPersistenceBroker.java:307)
at
de.mhr.wis.DBAdapter.ojbAdapter.management.OjbLogBook.getFirstEntry(OjbLogBook.java:5017)
at
de.mhr.wis.DBAdapter.ojbAdapter.management.OjbLogBook.getStartTermCalculation(OjbLogBook.java:2268)
at
de.mhr.wis.businessLayer.logic.management.LogBook.calculateTermForEachStatus(LogBook.java:194)
at
de.mhr.wis.businessLayer.logic.management.LogBookQueue.run(LogBookQueue.java:115)
Caused by: java.sql.SQLException: Cannot write sorted rows.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3208)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3518)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2353)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2269)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:1532)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1471)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1401)
at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:204)
at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1192)
at
com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:369)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:312)
... 12 more
Regards,
Thomas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]