[prev in list] [next in list] [prev in thread] [next in thread]
List: mondrian
Subject: Re: [Mondrian] FoodMart database
From: Julian Hyde <jhyde () pentaho ! com>
Date: 2011-12-27 20:20:10
Message-ID: 00421EBE-524A-4438-9036-3F2DB244AECC () pentaho ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
What JDK are you using?
Please post to mondrian@pentaho.org. Not to me personally, or to \
mondrian-devel@lists.sourceforge.net (that list is obsolete).
Julian
On Dec 25, 2011, at 8:01 AM, Gil Stelzer wrote:
> Hi All
>
> I downloaded the latest stable release of Mondrian (mondrian-3.3.0.14703).
> I wanted to install the test data set called FoodMart on MySQL (linux) and followed \
> the instructions carefully. I created the foodmart user with all permissions for \
> the foodmart database. I intended to use MondrianFoodMartLoader to populate the \
> database but when I used the following command java -cp \
> "/mondrian/lib/mondrian.jar:/mondrian/lib/log4j.jar:/mondrian/lib/commons-logging.ja \
> r:/mondrian/lib/eigenbase-xom.jar:/mondrian/lib/eigenbase-resgen.jar:/mondrian/lib/eigenbase-properties.jar:/usr/local/mysql/mysql-connector-java-5.0.5-bin.jar"
> mondrian.test.loader.MondrianFoodMartLoader
> -verbose -tables -data -indexes
> -jdbcDrivers=com.mysql.jdbc.Driver
> -inputFile=/mondrian/demo/FoodMartCreateData.sql
> -outputJdbcURL="jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart"
> I received errors stating there were missing jar files. I downloaded from the web \
> the files missing from /mondrian/lib which were stated in the error message. After \
> MondrianFoodMartLoader stopped complaining about missing jar files I received the \
> following error message Exception in thread "main" java.lang.VerifyError: (class: \
> mondrian/olap/Util, method: matches signature: \
> (Lorg/olap4j/mdx/IdentifierSegment;Ljava/lang/String;)Z) Incompatible argument to \
> function at mondrian.test.loader.MondrianFoodMartLoader.<clinit>(MondrianFoodMartLoader.java:100)
> Could not find the main class: mondrian.test.loader.MondrianFoodMartLoader. \
> Program will exit.
> I also tried using jar files I found after exploding the mondrian.war file \
> (log4j-1.2.8.jar ….) but this did NOT help. I saw that FoodMartCreateData.sql \
> contains the insert statements for the FoodMart db, but no schema for it. The \
> FoodMart.xml seems to contain the schema but I cannot simply use it for creating \
> tables without using MondrianFoodMartLoader, which simply doesn’t work.
> I also created a java project for Mondrian on eclipse and when I ran \
> MondrianFoodMartLoader .java I received an error on line 100,
> java.lang.NoClassDefFoundError: \
> edu/emory/mathcs/backport/java/util/concurrent/ThreadFactory at \
> mondrian.test.loader.MondrianFoodMartLoader.<clinit>(MondrianFoodMartLoader.java:100)
> Caused by: java.lang.ClassNotFoundException: \
> edu.emory.mathcs.backport.java.util.concurrent.ThreadFactory at \
> java.net.URLClassLoader$1.run(Unknown Source) at \
> java.security.AccessController.doPrivileged(Native Method) at \
> java.net.URLClassLoader.findClass(Unknown Source) at \
> java.lang.ClassLoader.loadClass(Unknown Source) at \
> sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at \
> java.lang.ClassLoader.loadClass(Unknown Source)
> ... 1 more
> Exception in thread "main"
> Which is
> private static final String nl = Util.nl;
> It does not seem to be related to threading and clicking the link to line 100 \
> results in an error message stating that 100 is not a valid line number in this \
> file.
> I am really looking forward to seeing Mondrian system capabilities.
>
> Please help me in any way you can.
> Thanks in advance.
>
>
> Gil
>
[Attachment #5 (unknown)]
<html><head><base href="x-msg://1240/"></head><body style="word-wrap: break-word; \
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">What JDK are you \
using?<div><br></div><div>Please post to <a \
href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a>. Not to me personally, or \
to <a href="mailto:mondrian-devel@lists.sourceforge.net">mondrian-devel@lists.sourceforge.net</a> \
(that list is obsolete).</div><div><br></div><div>Julian</div><div><br><div><div>On \
Dec 25, 2011, at 8:01 AM, Gil Stelzer wrote:</div><br \
class="Apple-interchange-newline"><blockquote type="cite"><span \
class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; \
font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: \
normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; \
text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; \
-webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; \
-webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; \
-webkit-text-stroke-width: 0px; font-size: medium; "><div lang="EN-US" link="blue" \
vlink="purple"><div class="WordSection1" style="page: WordSection1; "><div \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; \
">Hi All<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-size: 12pt; "><o:p> </o:p></span></div><div \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; \
">I downloaded the latest stable release of Mondrian \
(mondrian-3.3.0.14703).<o:p></o:p></span></div><div style="margin-top: 0in; \
margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; \
font-family: Calibri, sans-serif; "><span style="font-size: 12pt; ">I wanted to \
install the test data set called FoodMart on MySQL (linux) and followed the \
instructions carefully.<o:p></o:p></span></div><div style="margin-top: 0in; \
margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; \
font-family: Calibri, sans-serif; "><span style="font-size: 12pt; ">I created the \
foodmart user with all permissions for the foodmart \
database.<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-size: 12pt; ">I intended to use \
MondrianFoodMartLoader to populate the database but when I used the following \
command<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-size: 12pt; font-family: 'Courier New'; color: red; \
">java -cp "/mondrian/lib/mondrian.jar:/mondrian/lib/log4j.jar:/mondrian/lib/commons-l \
ogging.jar:/mondrian/lib/eigenbase-xom.jar:/mondrian/lib/eigenbase-resgen.jar:/mondria \
n/lib/eigenbase-properties.jar:/usr/local/mysql/mysql-connector-java-5.0.5-bin.jar"<br> \
mondrian.test.loader.MondrianFoodMartLoader<br> -verbose \
-tables -data -indexes<br> \
-jdbcDrivers=com.mysql.jdbc.Driver<br> \
-inputFile=/mondrian/demo/FoodMartCreateData.sql<span \
class="apple-converted-space"> </span></span><span style="font-size: 12pt; \
font-family: 'Courier New'; color: black; "><br> \
-outputJdbcURL="jdbc:mysql://localhost/foodmart?user=foodmart&password=foodmart"<o:p></o:p></span></div><div \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; \
">I received errors stating there were missing jar files. I downloaded from the \
web the files missing from /mondrian/lib which were stated in the error \
message. After MondrianFoodMartLoader stopped complaining about missing \
jar files I received the following error message<o:p></o:p></span></div><div \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; \
font-family: 'Courier New'; color: red; ">Exception in thread "main" \
java.lang.VerifyError: (class: mondrian/olap/Util, method: matches signature: \
(Lorg/olap4j/mdx/IdentifierSegment;Ljava/lang/String;)Z) Incompatible argument to \
function at mondrian.test.loader.MondrianFoodMartLoader.<clinit>(MondrianFoodMartLoader.java:100)<o:p></o:p></span></div><div \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; \
font-family: 'Courier New'; color: red; ">Could not find the main class: \
mondrian.test.loader.MondrianFoodMartLoader. Program will \
exit.<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-size: 12pt; "><o:p> </o:p></span></div><div \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; \
">I also tried using jar files I found after exploding the mondrian.war file \
(log4j-1.2.8.jar ….) but this did NOT help.<o:p></o:p></span></div><div \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; \
">I saw that FoodMartCreateData.sql contains the insert statements for the FoodMart \
db, but no schema for it. The FoodMart.xml seems to contain the schema but I \
cannot simply use it for creating tables without using MondrianFoodMartLoader, which \
simply doesn’t work.</span><o:p></o:p></div><div style="margin-top: 0in; \
margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; \
font-family: Calibri, sans-serif; "><span style="font-size: 12pt; \
"><o:p> </o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-size: 12pt; ">I also created a java project for \
Mondrian on eclipse and when I ran MondrianFoodMartLoader .java I received an error \
on line 100,<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-family: 'Courier New'; color: red; \
">java.lang.NoClassDefFoundError: \
edu/emory/mathcs/backport/java/util/concurrent/ThreadFactory</span><span \
style="font-family: 'Courier New'; "><o:p></o:p></span></div><div style="margin-top: \
0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; \
font-family: Calibri, sans-serif; "><span style="font-family: 'Courier New'; color: \
red; "> at \
mondrian.test.loader.MondrianFoodMartLoader.<clinit>(</span><u><span \
style="font-family: 'Courier New'; color: navy; \
">MondrianFoodMartLoader.java:100</span></u><span style="font-family: 'Courier New'; \
color: red; ">)</span><span style="font-family: 'Courier New'; \
"><o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-family: 'Courier New'; color: red; ">Caused by:<span \
class="Apple-converted-space"> </span></span><u><span style="font-family: \
'Courier New'; color: navy; ">java.lang.ClassNotFoundException</span></u><span \
style="font-family: 'Courier New'; color: red; ">: \
edu.emory.mathcs.backport.java.util.concurrent.ThreadFactory</span><span \
style="font-family: 'Courier New'; "><o:p></o:p></span></div><div style="margin-top: \
0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; \
font-family: Calibri, sans-serif; "><span style="font-family: 'Courier New'; color: \
red; "> at java.net.URLClassLoader$1.run(Unknown \
Source)</span><span style="font-family: 'Courier New'; "><o:p></o:p></span></div><div \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: \
'Courier New'; color: red; "> at \
java.security.AccessController.doPrivileged(</span><u><span style="font-family: \
'Courier New'; color: navy; ">Native Method</span></u><span style="font-family: \
'Courier New'; color: red; ">)</span><span style="font-family: 'Courier New'; \
"><o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-family: 'Courier New'; color: red; \
"> at java.net.URLClassLoader.findClass(Unknown \
Source)</span><span style="font-family: 'Courier New'; "><o:p></o:p></span></div><div \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: \
'Courier New'; color: red; "> at \
java.lang.ClassLoader.loadClass(Unknown Source)</span><span style="font-family: \
'Courier New'; "><o:p></o:p></span></div><div style="margin-top: 0in; margin-right: \
0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: \
Calibri, sans-serif; "><span style="font-family: 'Courier New'; color: red; \
"> at sun.misc.Launcher$AppClassLoader.loadClass(Unknown \
Source)</span><span style="font-family: 'Courier New'; "><o:p></o:p></span></div><div \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: \
'Courier New'; color: red; "> at \
java.lang.ClassLoader.loadClass(Unknown Source)</span><span style="font-family: \
'Courier New'; "><o:p></o:p></span></div><div style="margin-top: 0in; margin-right: \
0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: \
Calibri, sans-serif; "><span style="font-family: 'Courier New'; color: red; \
"> ... 1 more</span><span style="font-family: 'Courier New'; \
"><o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-family: 'Courier New'; color: red; ">Exception in \
thread "main"<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-size: 12pt; ">Which is<o:p></o:p></span></div><div \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; \
">private static final String nl =<span class="Apple-converted-space"> </span><a \
href="http://Util.nl" style="color: blue; text-decoration: underline; \
">Util.nl</a>;<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-size: 12pt; ">It does not seem to be related to \
threading and clicking the link to line 100 results in an error message stating that \
100 is not a valid line number in this file.<o:p></o:p></span></div><div \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; \
"><o:p> </o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-size: 12pt; ">I am really looking forward to seeing \
Mondrian system capabilities.<o:p></o:p></span></div><div style="margin-top: 0in; \
margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; \
font-family: Calibri, sans-serif; "><span style="font-size: 12pt; \
"><o:p> </o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-size: 12pt; ">Please help me in any way you can. \
<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-size: 12pt; ">Thanks in \
advance.<o:p></o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-size: 12pt; "><o:p> </o:p></span></div><div \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; \
"><o:p> </o:p></span></div><div style="margin-top: 0in; margin-right: 0in; \
margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, \
sans-serif; "><span style="font-size: 12pt; ">Gil<o:p></o:p></span></div><div \
style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; \
font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; \
"><o:p> </o:p></span></div></div></div></span></blockquote></div><br></div></body></html>
_______________________________________________
Mondrian mailing list
Mondrian@pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic