[Mondrian] begining with olap4j

Kezern kezern at gmail.com
Fri Jun 19 03:29:33 EDT 2009

Hi all,
I have just started with mondrian and olap4j. I'm trying to build a java 
class which connects to my mondrian and extract some data.
I have deployed the mondrian-embedded.war into my tomcat and I have made 
some test with jpivot.
Now I'm building the new class in eclipse following the instrucions of 
the olap4j functional specifications.
I have written this class.

package olap;

import java.sql.DriverManager;
import java.sql.SQLException;
import org.apache.log4j.Logger;

import org.olap4j.*;

public class App
    public static void main( String[] args ) throws 
ClassNotFoundException, SQLException
        System.out.println( "Hello World!" );
        OlapConnection connection =
            (OlapConnection) DriverManager.getConnection(
            "jdbc:mondrian:local:jdbcURL=jdbc:odbc:MondrianFoodMart;" +
            "Catalog=/WEB-INF/queries/FoodMart.xml;" +
            "Role='California manager'");
        OlapWrapper wrapper = (OlapWrapper) connection;
        OlapConnection olapConnection = (OlapConnection) 
        OlapStatement statement = olapConnection.createStatement();

//        OlapResult result =
//            statement.execute(
//                "SELECT {[Measures].[Unit Sales]} ON COLUMNS,\n" +
//                "  {[Product].Members} ON ROWS\n" +
//                "FROM [Sales]");

And I get this error when the class tries to make de connection:
Exception in thread "main" mondrian.olap.MondrianException: Mondrian 
Error:Internal error: Connect string 
Catalog=/WEB-INF/queries/FoodMart.xml; Role=California manager' must 
contain either 'Jdbc' or 'DataSource'
I have been looking for a solution but I couldn't find one.
Thanks every body.

More information about the Mondrian mailing list