Hi all. Has anyone use OLAP on LINUX before? I tried to install Mondrian OLAP, and it seems there's a problem during installing it. From the error that I got, I think it has to do something with the classpath ...here's the error messages;

Exception in thread "main" java.lang.NoClassDefFoundError: opt.mondrian-1.1.5.test.loader.MondrianFoodLoader.class
at gnu.gcj.runtime.FirstThread.run() (/usr/lib/libgcj.so.5.0.0)
at _Jv_ThreadRun(java.lang.Thread) (/usr/lib/libgcj.so.5.0.0)
at _Jv_RunMain(java.lang.Class, byte const, int, byte const, boolean) (/usr/lib/libgcj.so.5.0.0)
at __gcj_personality_v0 (/opt/mondrian-1.1.5/java.home=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre)
at __libc_start_main (/lib/tls/libc-2.3.3.so)
at _Jv_RegisterClasses (/opt/mondrian-1.1.5/java.home=/usr/lib/jvm/java-1.4.2-gcj-1.4.2.0/jre)

The command line I wrote this,
java -cp "/opt/mondrian-1.1.5/lib/mondrian.jar:/opt/mondrian-1.1.5/lib/log4j-1.2.9.jar:/opt/mondrian-1.1.5/lib/eigenbase-xom.jar:/opt/mondrian-1.1.5/lib/eigenbase-resgen.jar:/opt/mysql-connector-java-3.1.8/mysql-connector-java-3.1.8-bin.jar" opt.mondrian-1.1.5.lib.mondrian.test.loader.MondrianFoodLoader -verbos -tables -data -indexes rs=com.mysql.jd bc.Driver -inputFile=/opt/mondrian-1.1.5/demo/FoodMartCreateData.sql -outputJdbc URL="jdbc:mysql://localhost/foodmar?user=root&password= "

What is actually happening ? Do I need to insert classpath to point mondrian.jar in my /root/.bashrc file?
Bye

I created the test database using the following:

java -cp './lib/mondrian.jar:./lib/log4j-1.2.9.jar:./lib/eigenbase-xom.jar:./lib/eigenbase-resgen.jar:/usr/local/mysql/mysql-connector-java-3.1.9-bin.jar' \
mondrian.test.loader.MondrianFoodMartLoader \
-verbose -tables -data -indexes \
-jdbcDrivers=com.mysql.jdbc.Driver \
-inputFile=./demo/FoodMartCreateData.sql \
-outputJdbcURL="jdbc:mysql://localhost/foodmart?user=root&password="

I got a few errors on conflicting timestamps, but the data looks ok.


Now I'm stuck on the next step. When I go to the test page get the test page:
http://localhost:8080/mondrian/testpage.jsp?query=mondrian

I get the following error:
error: Error while creating connection from data source

This is the connect info from the mondrian.properties file:
mondrian.test.connectString=\
Provider=mondrian;\
Jdbc="jdbc:mysql://localhost/foodmart?user-root&password=";\
Catalog=/WEB-INF/FoodMart.xml;\
JdbcDrivers=com.mysql.jdbc.Driver;\
RoleXX='California manager';
mondrian.foodmart.jdbcURL=jdbcdbc:MondrianFoodMart
mondrian.jdbcDrivers=com.mysql.jdbc.Driver

Did you fix it???? i have the same problem right now and need an urgent solution.

Thanks a lot

Irrelevant Spam deleted by mod.

thanks a lot i was looking for it