[Mondrian] Running the JUnit tests

[Luc Boudreau]

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