[Mondrian] JPivot Error

Luna, Enrique e-luna1 at sensata.com
Thu Mar 29 16:47:17 EDT 2007

Yes, but this is not what I'm looking for...


I have done the change in the mondrian.jsp to show the following:


<%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp" %>

<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>

<jp:mondrianQuery id="query01" jdbcDriver="com.mysql.jdbc.Driver"




{[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store
Sales]} on columns,

{([Promotion Media].[All Media], [Product].[All Products])} ON rows

from Sales

where ([Time].[1997])


<c:set var="title01" scope="session">Test Query uses Mondrian



But not working...



From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Julian Hyde
Sent: Thursday, March 29, 2007 2:40 PM
To: 'Mondrian developer mailing list'
Subject: RE: [Mondrian] JPivot Error


Did you search for the error message? You would have found







	From: mondrian-bounces at pentaho.org
[mailto:mondrian-bounces at pentaho.org] On Behalf Of Luna, Enrique
	Sent: Thursday, March 29, 2007 1:14 PM
	To: mondrian at pentaho.org
	Subject: [Mondrian] JPivot Error



	I've just installed Mondrian on a Linux Fedora 6 with Tomcat and
MySql 5. I'm trying to execute the samples (FoodMart) for MySql, I
loaded the data into MySql with no issues, and reconfigured the
mondrian.jsp to include the user and password (foodmart)


	I try to run the first example but I get the following error:


	Error while creating SQL Dialect 


	Then I go down on the web page and I see 



	MESSAGE : Connection refused



	I can login to mysql using the foodmart account and can run
queries from the command line.


	Any idea of what am I doing wrong?




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070329/6648f4d8/attachment.html 

More information about the Mondrian mailing list