[Mondrian] error with hsqldb

[hadi ganteng]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080305/a359f020/attachment.html