[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"
jdbcUrl="jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart
"
catalogUri="/WEB-INF/queries/FoodMart.xml">
select
{[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])
</jp:mondrianQuery>
<c:set var="title01" scope="session">Test Query uses Mondrian
OLAP</c:set>
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
http://forums.pentaho.org/showthread.php?p=152315
Julian
________________________________
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
Hi,
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
Java.net.ConnectException
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?
Regards,
Enrique
-------------- 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