[Mondrian] error with hsqldb

[hadi ganteng]

i can't understand where is the root of the exception, because i'm very new to tomcat 5.5. maybe this generated log file can help. thank you very much for help me. 
Hadi.

Julian Hyde <jhyde at pentaho.org> wrote:     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    it now._______________________________________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian


       
---------------------------------
Looking for last minute shopping deals?  Find them fast with Yahoo! Search.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080307/bb36c221/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logs.zip
Type: application/x-zip-compressed
Size: 6880 bytes
Desc: 3341900675-logs.zip
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20080307/bb36c221/attachment.bin