[Mondrian] error with hsqldb

Julian Hyde jhyde at pentaho.org
Wed Mar 5 10:36:13 EST 2008


What's the root cause exception? You will find the full stack trace in
apache's log.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of hadi ganteng
Sent: Wednesday, March 05, 2008 5:07 AM
To: mondrian at pentaho.org
Subject: [Mondrian] error with hsqldb


when i changed the database into hsqldb i got an error, the error is:
JPivot had an error ...

org.apache.jasper.JasperException: javax.servlet.jsp.JspException:
javax.servlet.jsp.JspException: Mondrian Error:Internal error: while
building member cache; sql=[select "time_by_day"."the_year" as "c0" from
"time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by
"time_by_day"."the_year" ASC]

org.apache.jasper.JasperException: javax.servlet.jsp.JspException:
javax.servlet.jsp.JspException: Mondrian Error:Internal error: while
building member cache; sql=[select "time_by_day"."the_year" as "c0" from
"time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by
"time_by_day"."the_year" ASC]
at org.apache.jasper.servlet.JspServletWrapper.handle
JspException(JspServletWrapper.java:476)
at org.apache.jasper.servlet.JspServletWrapper.servic
e(JspServletWrapper.java:371)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:315)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at org.apache.catalina.core.ApplicationFilterChain.in
ternalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.do
Filter(ApplicationFilterChain.java:188)
at com.tonbeller.wcf.controller.RequestFilter$MyHandl
er.normalRequest(RequestFilter.java:139)
at com.tonbeller.wcf.controller.RequestSynchronizer.h
andleRequest(RequestSynchronizer.java:127)
at com.tonbeller.wcf.controller.RequestFilter.doFilte
r(RequestFilter.java:263)
at org.apache.catalina.core.ApplicationFilterChain.in
ternalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.do
Filter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invo
ke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invo
ke(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.invok
e(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.servic
e(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(H
ttp11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11
ConnectionHandler.processConnection(Http11BaseProt ocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.process
Socket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThr
ead.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlR
unnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Unknown Source)

maybe the " in the sql caused the error, because hsqldb don't accept " in
the sql statement.
how can i fix this error? thx...for helping me 



  _____  

Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try
<http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8
HDtDypao8Wcj9tAcJ> it now.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080305/e4d74360/attachment.html 


More information about the Mondrian mailing list