<table cellspacing='0' cellpadding='0' border='0' ><tr><td valign='top' style='font: inherit;'>i have a problem with connecting Mondrian to Sql Server 2000 and Hsqldb 1.8.0.8,<br>i use Apache Tomcat 5.5 as the web server and Mozzila Firefox as the browser<br>the Mondrian version that i use is Mondrian 2.4.2.9831<br>here is the detail for each problem with the connection<br>i do nothing with the FoodMart.xml and mondrian.properties<br><br>---------------<br>SQL Server 2000<br>---------------<br>when i connect Mondrian to sql server, it return no error, but when i do<br>the drill down, Mondrian return a null value in each cell.<br>i connect the Mondrian with SQL Server via ODBC in system DSN, i also do the login in the ODBC. <br>i tested this ODBC with Borland Delphi 7.0, it works fine. <br>i attached file picture when i run the Mondrian. <br>this is the mondrian.jsp i edited to connect to SQL Server:<br>------------------------------------<br><%@ page
session="true" contentType="text/html; charset=ISO-8859-1" %><br><%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %><br><%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %><br><br><%-- uses a dataSource --%><br><%-- jp:mondrianQuery id="query01" dataSource="jdbc/MondrianFoodmart" catalogUri="/WEB-INF/demo/FoodMart.xml" --%><br><br><%-- uses mysql --%><br><%-- jp:mondrianQuery id="query01" jdbcDriver="com.mysql.jdbc.Driver" jdbcUrl="jdbc:mysql://localhost/foodmart" catalogUri="/WEB-INF/queries/FoodMart.xml"--%><br><br><%-- uses a role defined in FoodMart.xml --%><br><%-- jp:mondrianQuery role="California manager" id="query01" jdbcDriver="sun.jdbc.odbc.JdbcOdbcDriver" jdbcUrl="jdbc:odbc:MondrianFoodMart" catalogUri="/WEB-INF/queries/FoodMart.xml" --%><br><br><jp:mondrianQuery id="query01" jdbcDriver="sun.jdbc.odbc.JdbcOdbcDriver" <br>jdbcUser="narou"
jdbcPassword="071185"<br>jdbcUrl="jdbc:odbc:MondrianSQLServer" catalogUri="/WEB-INF/queries/FoodMart.xml"><br>select<br> {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} on columns,<br> {([Promotion Media].[All Media], [Product].[All Products])} ON rows<br>from Sales<br>where ([Time].[1997])<br></jp:mondrianQuery><br><br><c:set var="title01" scope="session">Test Query uses Mondrian OLAP</c:set><br>--------------------------------------<br><br>--------------<br>Hsqldb 1.8.0.8<br>--------------<br>i use HSQL Database Engine Server in Hsqldb for the database. i attached the picture file<br>when i run the Hsqldb server and the manager. Hsqldb has this error:<br>--------------------------------<br>org.apache.jasper.JasperException: javax.servlet.jsp.JspException: javax.servlet.jsp.JspException: <br>Mondrian Error:Internal error: while building member cache; sql=[select "time_by_day"."the_year" as
<br>"c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by "time_by_day".<br>"the_year" ASC]<br><br>org.apache.jasper.JasperException: javax.servlet.jsp.JspException: javax.servlet.jsp.JspException: <br>Mondrian Error:Internal error: while building member cache; sql=[select "time_by_day"."the_year" as <br>"c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by "time_by_day".<br>"the_year" ASC]<br> at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:476)<br> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)<br> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)<br> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br>
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br> at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)<br> at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)<br> at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)<br> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)<br> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)<br> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)<br> at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)<br> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)<br> at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)<br> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)<br> at java.lang.Thread.run(Unknown Source)<br>-----------------------------------<br><br>this is the mondrian.jsp i edited to connect to hsqldb:<br>-----------------------------------<br><%@ page session="true" contentType="text/html; charset=ISO-8859-1" %><br><%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %><br><%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %><br><br><%-- uses a dataSource --%><br><%-- jp:mondrianQuery id="query01" dataSource="jdbc/MondrianFoodmart" catalogUri="/WEB-INF/demo/FoodMart.xml" --%><br><br><%-- uses mysql --%><br><%-- jp:mondrianQuery id="query01" jdbcDriver="com.mysql.jdbc.Driver" jdbcUrl="jdbc:mysql://localhost/foodmart"
catalogUri="/WEB-INF/queries/FoodMart.xml"--%><br><br><%-- uses a role defined in FoodMart.xml --%><br><%-- jp:mondrianQuery role="California manager" id="query01" jdbcDriver="sun.jdbc.odbc.JdbcOdbcDriver" jdbcUrl="jdbc:odbc:MondrianFoodMart" catalogUri="/WEB-INF/queries/FoodMart.xml" --%><br><br><jp:mondrianQuery id="query01" jdbcDriver="org.hsqldb.jdbcDriver" jdbcUser="sa" jdbcPassword="" jdbcUrl="jdbc:hsqldb:hsql://localhost/" catalogUri="/WEB-INF/queries/FoodMart.xml"><br>select<br> {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} on columns,<br> {([Promotion Media].[All Media], [Product].[All Products])} ON rows<br>from Sales<br>where ([Time].[1997])<br></jp:mondrianQuery><br><br><c:set var="title01" scope="session">Test Query uses Mondrian OLAP</c:set><br>------------------------------------<br><br>i think i make a mistake for jdbcUrl in each mondrian.jsp, please
correct this or maybe <br>someone can make a simple tutorial for me to connect to each database engine<br><br>thank you very much,<br>Hadi</td></tr></table><br>