[Mondrian] error with hsqldb

[hadi ganteng]

do you mean by the loader is the server? if the answer is yes, then i've ran the server when this error generated.
thank you very much.
Hadi.

Julian Hyde <jhyde at pentaho.org> wrote:     This error in the stdout log:
  
 Caused by: java.sql.SQLException: Table not found in  statement [select "time_by_day"."the_year" as "c0" from  "time_by_day"]

 is the cause. Apparently there is no table with that name.  Did you run the loader?
  
 Julian

       
---------------------------------
   From: hadi ganteng    [mailto:narou71185 at yahoo.com] 
Sent: Friday, March 07, 2008 3:20    AM
To: jhyde at pentaho.org; Mondrian developer mailing    list
Subject: RE: [Mondrian] error with hsqldb


   
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.

       
---------------------------------
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/20080309/de0b803d/attachment.html