Gentlemen,<br><br>I use Eclipse to work on Mondrian. Here are some tips.<br><br>Once you have imported the project into Eclipse, run the ant targets: "clean compile compile.tests". This will do a few things for you. It will resolve all artifacts and place them in the 'lib' and 'testlib' folders. Then it will generate the parser and the message files. Once you have done that, you can refresh the project from within Eclipse, and everything should build, with the exception of the JDBC4 driver. You can safely ignore it, as the runtime execution path will fork to the proper JDBC driver for the Java version you are running against.<br>
<br>To run the test suite, you need to create a 'Run Configuration' which will execute a single test class: 'mondrian.test.Main'. This test class will in turn configure some stuff and call all the other tests. I suggest adding the following JVM arguments to your run configuration: '-Xms512m -Xmx1024m'. <br>
<br>You should also take a look inside the file called 'mondrian.properties' at the root of the project. You will need to use read this file and uncomment the proper lines so Mondrian can test against a FoodMart database isntalled on your machine. If you don't have the FoodMart database configured, you can easily load it into your RDBMS. Look in Mondrian sources, there should be a folder called 'demo'. Inside that folder are some examples of scripts to import the data. Here's how to import the data for MySQL. First, create a batch file. Call it whatever you fancy, but in there, add the following commands:<br>
<br>-------------------------------------------------------------------------------------------<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">@echo off</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">set CP=../lib/commons-dbcp.jar;../lib/commons-collections.jar;../lib/commons-pool.jar;../lib/commons-logging.jar</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">set CP=%CP%;../lib/eigenbase-properties.jar;../lib/eigenbase-resgen.jar;../lib/eigenbase-xom.jar</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">set CP=%CP%;../lib/javacup.jar;../lib/mondrian.jar</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">set CP=%CP%;../lib/log4j.jar</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">set CP=%CP%;../dev-lib/mysql-connector-java-5.1.5-bin.jar</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">rem set CP=%CP%;../testlib/postgresql-driver-jdbc3-74-214.jar</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">rem set CP=%CP%;../testlib/jtds-1.2.jar</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">java -Xms100m -Xmx500m -cp "%CP%" mondrian.test.loader.MondrianFoodMartLoader -verbose -aggregates -tables -data -indexes -inputFile="C:/workspace-olap4j/luc-mondrian-3.2/open/mondrian-release/3.2/demo/FoodMartCreateData.sql" -jdbcDrivers=com.mysql.jdbc.Driver -outputJdbcURL="jdbc:mysql://localhost:3306/foodmart" -outputJdbcUser=foodmart -outputJdbcPassword=foodmart</span><br>
-------------------------------------------------------------------------------------------<br><br>You might need to change the user/password/host, but you'll manage. If you did deploy the data in MySQL, make sure that the contents of mondrian.properties reflect that.<br>
<br>The only gotcha that I know of is when Eclipse decides to wipe out the class output folders, it erases the generated resources as well. You might need to re-run the ant target called generate.resources. <br><br>This should be it. If you have any other issues, let me know.<br>
<br>Luc<br><br><br><div class="gmail_quote">On Tue, Apr 5, 2011 at 6:42 AM, Michele Rossi <span dir="ltr"><<a href="mailto:michele.rossi@gmail.com">michele.rossi@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi,<div>I am having similar issues, I think it's a bit tricky to work on Mondrian in Eclipse.</div><div>Perhaps most of the problems are to do with the fact that Mondrian supports both JDBC 3.0 and JDBC 4.0 at the same time.</div>
<div><br></div><div>Julian - is supporting JDBC 3.0 and older versions of Java still a strong requirement?</div><div><br></div><div>Perhaps at some point we could drop the support for Java 5.0 and people that don't want to upgrade could always use old versions of Mondrian?</div>
<div>After all Java 6.0 with JDBC 4.0 was released in December 2006, 4 years and 4 months ago.</div><div><br></div><div>If we did that and used Maven we would obtain automatic eclipse integration.</div><div>You could change a line of code, hit ctrl+s and run your tests again from eclipse to verify that your new code works.</div>
<div><br></div><div>I only mean to throw in some ideas, not to criticise - I think that Mondrian is great!</div><div><br></div><div>thanks,</div><div>Michele</div><div><br><br><div class="gmail_quote"><div><div></div><div class="h5">
On 5 April 2011 12:32, Venkatesh U <span dir="ltr"><<a href="mailto:venkatesh20@gmail.com" target="_blank">venkatesh20@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div></div><div class="h5">Hi,<div> I have setup the mondrian code in eclipse and I run the build.xml to build the project. I could debug and run cmdRunner successfully. But when i also link the testsrc folder, there are lot of errors in the project. How to run the standard test suite and verify the test results. I am sorry if this is some thing very simple and obvious.</div>
<div><br></div><div>Thanks,<br>Venki</div>
<br></div></div>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br></div>
<br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div><br>