[Mondrian] error with hsqldb

[Julian Hyde]

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
<http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8
HDtDypao8Wcj9tAcJ%20> it now.

_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian





  _____  

Looking for last minute shopping deals? Find
<http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/c
ategory.php?category=shopping> them fast with Yahoo! Search.

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