Condition: No courses joined
2010-01-12 13:04:43,611 [http-8080-1] ERROR util.JDBCExceptionReporter - Unexpected token: ) in statement [select this_.id as id6_0_, this_.version as version6_0_, this_.course_id as course3_6_0_, this_.description as descript4_6_0_, this_.date as date6_0_ from todo this_ where this_.course_id in () and this_.date between ? and ? order by this_.date asc]
2010-01-12 13:04:43,659 [http-8080-1] ERROR errors.GrailsExceptionResolver - Executing action [agenda] of controller [org.lecturious.MenuController] caused exception: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id6_0_, this_.version as version6_0_, this_.course_id as course3_6_0_, this_.description as descript4_6_0_, this_.date as date6_0_ from todo this_ where this_.course_id in () and this_.date between ? and ? order by this_.date asc]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
org.codehaus.groovy.grails.web.servlet.mvc.exceptions.ControllerExecutionException: Executing action [agenda] of controller [org.lecturious.MenuController] caused exception: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id6_0_, this_.version as version6_0_, this_.course_id as course3_6_0_, this_.description as descript4_6_0_, this_.date as date6_0_ from todo this_ where this_.course_id in () and this_.date between ? and ? order by this_.date asc]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at java.lang.Thread.run(Thread.java:619)
Caused by: org.codehaus.groovy.runtime.InvokerInvocationException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id6_0_, this_.version as version6_0_, this_.course_id as course3_6_0_, this_.description as descript4_6_0_, this_.date as date6_0_ from todo this_ where this_.course_id in () and this_.date between ? and ? order by this_.date asc]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
... 1 more
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id6_0_, this_.version as version6_0_, this_.course_id as course3_6_0_, this_.description as descript4_6_0_, this_.date as date6_0_ from todo this_ where this_.course_id in () and this_.date between ? and ? order by this_.date asc]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
at org.lecturious.CalendarService.courseElements(CalendarService.groovy:73)
at org.lecturious.CalendarService$courseElements.callCurrent(Unknown Source)
at org.lecturious.CalendarService.calendar(CalendarService.groovy:23)
at org.lecturious.CalendarService$calendar$0.callCurrent(Unknown Source)
at org.lecturious.CalendarService.calendar(CalendarService.groovy:15)
at org.lecturious.CalendarService$$FastClassByCGLIB$$3614c15e.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.lecturious.CalendarService$$EnhancerByCGLIB$$4c12497d.calendar(<generated>)
at org.lecturious.CalendarService$calendar.call(Unknown Source)
at org.lecturious.MenuController$_closure1.doCall(MenuController.groovy:13)
at org.lecturious.MenuController$_closure1.doCall(MenuController.groovy)
... 1 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
... 12 more
Caused by: java.sql.SQLException: Unexpected token: ) in statement [select this_.id as id6_0_, this_.version as version6_0_, this_.course_id as course3_6_0_, this_.description as descript4_6_0_, this_.date as date6_0_ from todo this_ where this_.course_id in () and this_.date between ? and ? order by this_.date asc]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:248)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:302)
... 12 more