<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">How about making hsqldb the default option? The MySQL regressions can be caught in the nightly build.<div class=""><br class=""></div><div class="">There is a lot to be said for the simplicity of</div><div class=""><br class=""></div><div class="">$ git clone <a href="mailto:git@github.com" class="">git@github.com</a>:pentaho/mondrian.git</div><div class="">$ cd mondrian</div><div class="">$ mvn install</div><div class=""><br class=""><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Nov 1, 2016, at 11:56 AM, Kurtis Walker <<a href="mailto:kwalker@pentaho.com" class="">kwalker@pentaho.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div id="divtagdefaultwrapper" style="font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; font-size: 12pt; font-family: Calibri, Arial, Helvetica, sans-serif;" class=""><div style="margin-top: 0px; margin-bottom: 0px;" class="">Hi Julian,</div><div style="margin-top: 0px; margin-bottom: 0px;" class=""> I considered that option. I elected to stay with MySql because there are a number of tests, specifically around native evaluation, that match specifically to either mysql or oracle sql patterns. The tests are basically a no-op for other dbs. I agree hsqldb would be a more pure option, but would need to come with refactoring lots of tests.</div><div style="margin-top: 0px; margin-bottom: 0px;" class=""><br class=""></div><div style="margin-top: 0px; margin-bottom: 0px;" class="">Kurt</div><br class=""><br class=""><div style="" class=""><hr tabindex="-1" style="display: inline-block; width: 965.296875px;" class=""><div id="divRplyFwdMsg" dir="ltr" class=""><font face="Calibri, sans-serif" style="font-size: 11pt;" class=""><b class="">From:</b><span class="Apple-converted-space"> </span><a href="mailto:mondrian-bounces@pentaho.org" class="">mondrian-bounces@pentaho.org</a> <<a href="mailto:mondrian-bounces@pentaho.org" class="">mondrian-bounces@pentaho.org</a>> on behalf of Julian Hyde <<a href="mailto:julianhyde@gmail.com" class="">julianhyde@gmail.com</a>><br class=""><b class="">Sent:</b><span class="Apple-converted-space"> </span>Tuesday, November 1, 2016 2:06 PM<br class=""><b class="">To:</b><span class="Apple-converted-space"> </span>Mondrian developer mailing list<br class=""><b class="">Subject:</b><span class="Apple-converted-space"> </span>Re: [Mondrian] switching to maven</font><div class=""> </div></div><div class="">I did most of this on the Mondrian 4 branch a while ago. The one thing I did differently was to use an embedded in-memory hsqldb rather than MySQL. It requires a bit more memory but because everything is in-memory and comes a JAR file which is a maven dependency I think it’s simpler than using jcabi-mysql-maven-plugin.<div class=""><br class=""></div><div class="">Julian</div><div class=""><br class=""><div class=""><br class=""><div class=""><blockquote type="cite" class=""><div class="">On Nov 1, 2016, at 10:36 AM, Kurtis Walker <<a href="https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=kwalker@pentaho.com" class="" target="_blank">kwalker@pentaho.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div id="divtagdefaultwrapper" class="" style="font-style: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; font-size: 12pt; font-family: Calibri, Arial, Helvetica, sans-serif;"><div class="" style="margin-top: 0px; margin-bottom: 0px;">FYI</div><div class="" style="margin-top: 0px; margin-bottom: 0px;"><br class=""></div><div class="" style="margin-top: 0px; margin-bottom: 0px;">In the coming weeks we will be switching the Mondrian 3 build from ant to mvn. The proposed changes are in a branch on my fork. <a href="https://github.com/kurtwalker/mondrian/tree/mavenize" class="OWAAutoLink" id="LPlnk59180" previewremoved="true">https://github.com/kurtwalker/mondrian/tree/mavenize</a> Key highlights include:</div><p class="" style="margin-top: 0px; margin-bottom: 0px;"></p><ul class=""><li class="">Integration tests can use an embedded mysql server, thus removing the need to set up foodmart and steelwheels</li><li class="">schema workbench code is separated into a separate sub-module</li><li class="">Generated source gets its own source dir</li></ul><p class="" style="margin-top: 0px; margin-bottom: 0px;"></p><div class="" style="margin-top: 0px; margin-bottom: 0px;">Let me know if you have any concerns.</div><div class="" style="margin-top: 0px; margin-bottom: 0px;"><br class=""></div><div class="" style="margin-top: 0px; margin-bottom: 0px;">Kurt</div><br class=""></div><span class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; float: none; display: inline !important;">_______________________________________________</span><br class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;"><span class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; float: none; display: inline !important;">Mondrian mailing list</span><br class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;"><a href="https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=Mondrian@pentaho.org" class="" target="_blank" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">Mondrian@pentaho.org</a><br class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;"><a href="http://lists.pentaho.org/mailman/listinfo/mondrian" class="" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">http://lists.pentaho.org/mailman/listinfo/mondrian</a></div></blockquote></div><br class=""></div></div></div></div></div><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">_______________________________________________</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Mondrian mailing list</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><a href="mailto:Mondrian@pentaho.org" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">Mondrian@pentaho.org</a><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><a href="http://lists.pentaho.org/mailman/listinfo/mondrian" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">http://lists.pentaho.org/mailman/listinfo/mondrian</a></div></blockquote></div><br class=""></div></div></body></html>