'Exception on DateTimeListener' every hour

Functionality discussions and feature requests

Moderators: hugo, alexandre, rmvanarkel

Post Reply
niek
Posts: 77
Joined: Sat Sep 24, 2005 11:51 am
Location: The Netherlands
Contact:

'Exception on DateTimeListener' every hour

Post by niek »

This is an error occurring in Cyclos 20060324, exactly every hour: is this a bug? Which function is running every hour? Seems that it has to do with taxes. Maybe someone from the development team could shed some light on this.
Java version is 1.5.0-p2. MySQL is 5.0.18.

2006-04-05 19:59:11,056 - Exception on DateTimeListener
nl.strohalm.cyclos.entities.application.exceptions.ApplicationException: could not execute query
at nl.strohalm.cyclos.entities.application.dao.TransactionExecutor.handleException(TransactionExecutor.java:116)
at nl.strohalm.cyclos.entities.application.dao.TransactionExecutor.executeInTransaction(TransactionExecutor.java:67)
at nl.strohalm.cyclos.entities.application.dao.TransactionExecutor.executeInTransaction(TransactionExecutor.java:40)
at nl.strohalm.cyclos.entities.application.TaxesManagement.update(TaxesManagement.java:143)
at java.util.Observable.notifyObservers(Observable.java:142)
at java.util.Observable.notifyObservers(Observable.java:98)
at nl.strohalm.cyclos.entities.application.DateTimeListener.callObservers(DateTimeListener.java:73)
at nl.strohalm.cyclos.entities.application.DateTimeListener.access$2(DateTimeListener.java:72)
at nl.strohalm.cyclos.entities.application.DateTimeListener$1.run(DateTimeListener.java:46)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2148)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1129)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at nl.strohalm.cyclos.entities.taxes.TaxList.searchTaxToRun(TaxList.java:79)
at nl.strohalm.cyclos.entities.application.TaxesManagement$1.run(TaxesManagement.java:145)
at nl.strohalm.cyclos.entities.application.TaxesManagement$1.run(TaxesManagement.java:1)
at nl.strohalm.cyclos.entities.application.dao.TransactionExecutor.executeInTransaction(TransactionExecutor.java:57)
... 9 more
Caused by: java.sql.SQLException: Statement parameter 2 not set.
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1031)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
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:2145)
... 20 more

hugovanderzee
Posts: 98
Joined: Wed Apr 06, 2005 9:56 am

Post by hugovanderzee »

Yes this is a bug. It has been solved with the current version 07/04/2006

From the change log:
Hibernate migration caused an error on timer avoid taxes to run automatically. However, if the instance was shutdown en restarted, it would detect and create recovery logs.
Hugo van der Zee
Cyclos development team

Post Reply