[Mondrian] error with hsqldb

hadi ganteng narou71185 at yahoo.com
Fri Mar 7 06:22:08 EST 2008


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

        

---------------------------------
Be a better friend, newshound, and  know-it-all with Yahoo! Mobile.  Try it now.        

---------------------------------
Be a better friend, newshound, and  know-it-all with Yahoo! Mobile.  Try it now.
       
---------------------------------
Never miss a thing.   Make Yahoo your homepage.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080307/1e333481/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/1e333481/attachment.bin 


More information about the Mondrian mailing list