ERROR in catalina.out, not in the browser

[Bartolomeo Nicolotti]

Hi,

I was evaluating jtrac inserting some issue in a space. From the browser
it seem flawless, but looking at catalina.out of tomcat:

ERROR [org.hibernate.util.JDBCExceptionReporter] - Termine
inaspettato: ) in statement [select top ? this_.id as id0_2_,
this_.version as version0_2_, this_.type as type0_2_, this_.parent_id as
parent4_0_2_, this_.space_id as space5_0_2_, this_.sequence_num as
sequence6_0_2_, this_.time_stamp as time7_0_2_, this_.planned_effort as
planned8_0_2_, this_.logged_by as logged9_0_2_, this_.assigned_to as
assigned10_0_2_, this_.summary as summary0_2_, this_.detail as
detail0_2_, this_.status as status0_2_, this_.severity as severity0_2_,
this_.priority as priority0_2_, this_.cus_dbl_01 as cus16_0_2_,
this_.cus_dbl_02 as cus17_0_2_, this_.cus_dbl_03 as cus18_0_2_,
this_.cus_int_01 as cus19_0_2_, this_.cus_int_02 as cus20_0_2_,
this_.cus_int_03 as cus21_0_2_, this_.cus_int_04 as cus22_0_2_,
this_.cus_int_05 as cus23_0_2_, this_.cus_int_06 as cus24_0_2_,
this_.cus_int_07 as cus25_0_2_, this_.cus_int_08 as cus26_0_2_,
this_.cus_int_09 as cus27_0_2_, this_.cus_int_10 as cus28_0_2_,
this_.cus_str_01 as cus29_0_2_, this_.cus_str_02 as cus30_0_2_,
this_.cus_str_03 as cus31_0_2_, this_.cus_str_04 as cus32_0_2_,
this_.cus_str_05 as cus33_0_2_, this_.cus_tim_01 as cus34_0_2_,
this_.cus_tim_02 as cus35_0_2_, this_.cus_tim_03 as cus36_0_2_,
space1_.id as id8_0_, space1_.version as version8_0_, space1_.type as
type8_0_, space1_.prefix_code as prefix4_8_0_, space1_.name as name8_0_,
space1_.description as descript6_8_0_, space1_.guest_allowed as
guest7_8_0_, space1_.metadata_id as metadata8_8_0_, spaceseque4_.id as
id9_1_, spaceseque4_.next_seq_num as next2_9_1_ from items this_ inner
join spaces space1_ on this_.space_id=space1_.id left outer join
space_sequence spaceseque4_ on space1_.id=spaceseque4_.id where
this_.space_id in () order by space1_.name desc, this_.id desc]
2008-05-23 09:34:06,745 [http-8080-Processor23] ERROR
[org.apache.wicket.RequestCycle] - could not execute query; nested
exception is org.hibernate.exception.SQLGrammarException: could not
execute query
org.springframework.dao.InvalidDataAccessResourceUsageException: could
not execute query; nested exception is
org.hibernate.exception.SQLGrammarException: could not execute query
        at
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:613)
        at
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
        at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:378)
        at
org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1000)
        at
info.jtrac.hibernate.HibernateJtracDao.findItems(HibernateJtracDao.java:97)
        at info.jtrac.JtracImpl.findItems(JtracImpl.java:342)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy1.findItems(Unknown Source)
        at info.jtrac.wicket.ItemListPanel$1.load(ItemListPanel.java:68)
        at
org.apache.wicket.model.LoadableDetachableModel.getObject(LoadableDetachableModel.java:114)
        at info.jtrac.wicket.ItemListPanel.<init>(ItemListPanel.java:74)
        at info.jtrac.wicket.ItemListPage.<init>(ItemListPage.java:25)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
        at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at java.lang.Class.newInstance0(Class.java:355)
        at java.lang.Class.newInstance(Class.java:308)
        at
org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFactory.java:58)
        at
org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.newPage(BookmarkablePageRequestTarget.java:262)
        at
org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.getPage(BookmarkablePageRequestTarget.java:283)
        at
org.apache.wicket.request.target.component.BookmarkablePageRequestTarget.processEvents(BookmarkablePageRequestTarget.java:210)
        at
org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:90)
        at
org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1166)
        at org.apache.wicket.RequestCycle.step(RequestCycle.java:1241)
        at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1316)
        at org.apache.wicket.RequestCycle.request(RequestCycle.java:493)
        at
org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:354)
        at
org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:194)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
        at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
        at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.hibernate.exception.SQLGrammarException: could not
execute query
        at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
        at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.loader.Loader.doList(Loader.java:2223)
        at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
        at org.hibernate.loader.Loader.list(Loader.java:2099)
        at
org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at org.springframework.orm.hibernate3.HibernateTemplate
$36.doInHibernate(HibernateTemplate.java:1010)
        at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373)
        ... 53 more
Caused by: java.sql.SQLException: Termine inaspettato: ) in statement
[select top ? this_.id as id0_2_, this_.version as version0_2_,
this_.type as type0_2_, this_.parent_id as parent4_0_2_, this_.space_id
as space5_0_2_, this_.sequence_num as sequence6_0_2_, this_.time_stamp
as time7_0_2_, this_.planned_effort as planned8_0_2_, this_.logged_by as
logged9_0_2_, this_.assigned_to as assigned10_0_2_, this_.summary as
summary0_2_, this_.detail as detail0_2_, this_.status as status0_2_,
this_.severity as severity0_2_, this_.priority as priority0_2_,
this_.cus_dbl_01 as cus16_0_2_, this_.cus_dbl_02 as cus17_0_2_,
this_.cus_dbl_03 as cus18_0_2_, this_.cus_int_01 as cus19_0_2_,
this_.cus_int_02 as cus20_0_2_, this_.cus_int_03 as cus21_0_2_,
this_.cus_int_04 as cus22_0_2_, this_.cus_int_05 as cus23_0_2_,
this_.cus_int_06 as cus24_0_2_, this_.cus_int_07 as cus25_0_2_,
this_.cus_int_08 as cus26_0_2_, this_.cus_int_09 as cus27_0_2_,
this_.cus_int_10 as cus28_0_2_, this_.cus_str_01 as cus29_0_2_,
this_.cus_str_02 as cus30_0_2_, this_.cus_str_03 as cus31_0_2_,
this_.cus_str_04 as cus32_0_2_, this_.cus_str_05 as cus33_0_2_,
this_.cus_tim_01 as cus34_0_2_, this_.cus_tim_02 as cus35_0_2_,
this_.cus_tim_03 as cus36_0_2_, space1_.id as id8_0_, space1_.version as
version8_0_, space1_.type as type8_0_, space1_.prefix_code as
prefix4_8_0_, space1_.name as name8_0_, space1_.description as
descript6_8_0_, space1_.guest_allowed as guest7_8_0_,
space1_.metadata_id as metadata8_8_0_, spaceseque4_.id as id9_1_,
spaceseque4_.next_seq_num as next2_9_1_ from items this_ inner join
spaces space1_ on this_.space_id=space1_.id left outer join
space_sequence spaceseque4_ on space1_.id=spaceseque4_.id where
this_.space_id in () order by space1_.name desc, this_.id desc]
        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 sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at
org.springframework.jdbc.datasource.SingleConnectionDataSource
$CloseSuppressingInvocationHandler.invoke(SingleConnectionDataSource.java:338)
        at $Proxy0.prepareStatement(Unknown Source)
        at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
        at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
        at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
        at
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
        at org.hibernate.loader.Loader.doQuery(Loader.java:673)
        at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.doList(Loader.java:2220)
        ... 60 more




-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
j-trac-users mailing list
j-trac-users@...
https://lists.sourceforge.net/lists/listinfo/j-trac-users