[Mondrian] Running the JUnit tests

Patrick Leckey patl at seewind.com
Thu Mar 15 12:49:27 EDT 2012

Ok, we can swap out the tests for MySQL for now.

We run Pg as our primary back-end for all our Mondrian stuff.  Would Pg be something Pentaho would consider supporting if we were to work on making the tests Pg-safe (not necessarily short-term).  We don't plan on moving away from Pg and have quite good results with Mondrian on Pg, so fixing the tests in 4.0 is something we could take on here.

If it's not in the cards, we'll just continue writing / running tests against My and doing our own testing to make sure our changes work for us on Pg.


On 2012-03-15, at 11:38 AM, Luc Boudreau wrote:

> That's one of our skeletons in the closet. The test suite has some
> failures on PgSQL. We don't officially support PgSQL, mostly because
> of a lack of community interest. Seems like everyone uses
> Oracle/MySQL/Greenplum/MsSQL.
> Here's the cotnents of my mondrian.properties file.
> # native stuff
> mondrian.native.crossjoin.enable=true
> mondrian.native.topcount.enable=true
> mondrian.native.filter.enable=true
> mondrian.native.nonempty.enable=true
> mondrian.rolap.groupingsets.enable=true
> #agg stuff
> mondrian.rolap.aggregates.Use=false
> mondrian.rolap.aggregates.Read=false
> # naming stuff
> mondrian.olap.SsasCompatibleNaming=false
> # data stuff
> mondrian.foodmart.jdbcURL=jdbc:oracle:thin:foodmart/foodmart@//:1521/XE
> mondrian.foodmart.jdbcUser=foodmart
> mondrian.foodmart.jdbcPassword=foodmart
> mondrian.jdbcDrivers=oracle.jdbc.OracleDriver
> I personally run the test suite against MySQL and Oracle. It gives me
> a good enough coverage. Not all tests ared designed to run against all
> databases, so it is important to test all changes against at least two
> of the official supported DBs.
> To run the test suite, I usually run it in Eclipse (launch from
> mondrian.test.Main). From ant, I'm not exactly sure what are the exact
> targets to run, but I can guess you will need to setup things by
> running "ant" then call "ant test".
> Luc
> On Wed, Mar 14, 2012 at 6:17 PM, Patrick Leckey <patl at seewind.com> wrote:
>> We're trying to get our CI box to build and test our local working copies of Mondrian, but we're having some issue with the tests.
>> We run PostgreSQL as a back-end and so we're setting up the tests to run against that.
>> Currently our Jenkins job executes:
>> - Drop the current foodmart database
>> - Run the load-foodmart ant task
>> - Run the junit-main ant task
>> This is generating different results from the tests we see run on the public Pentaho CI server.  We get an exception right off the bat (form the PG JDBC driver) saying it can't login as "bogususer".  Then a lot of the output looks similar, and the jobs hang - no processes running on the PG server, but JUnit does not complete.
>> If we change the junit-main task to the test task, it seems to complete but unlike the 8 failures and 0 errors on Pentaho CI, we get 24 failures and 3 errors.  Checking the PostgreSQL logs, it seems to mostly be SQL syntax errors (and the "bogususer" error).
>> I do notice the Pentaho CI build runs the tests against MySQL and not PostgreSQL.  Are they designed to only be run against MySQL?  If I threw JBoss on our CI box, could we run them against the Derby DB? (I mostly just don't want to setup a MySQL instance on that box)
>> test.properties and mondrian.properties are both setup in the Jenkins workspace folder and found by the build, all info in them looks correct (mondrian.test.connectString is picked up, etc.).
>> This is being run on a clean check-out of //open/mondrian from this morning, no changes at all except to the test.properties and mondrian.properties files.
>> Thanks,
>> Pat
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

More information about the Mondrian mailing list