Hi Chaps, I have a persistent failing set of tests - see http://bamboo.internal.opennms.com:8085/browse/OPENNMS-FEATUREREPORTINGAPI-23/test/org.opennms.web.svclayer.DefaultOutageServiceIntegrationTest for and example of what I mean.
I think my create.sql foo is not up to the job. I'm missing a some rows that I reckon I should have inserted by opennms-base-assembly/src/ main/filtered/etc/create.sql with the following lines: --################################################################## --# The following command should populate the qrtz_locks table --# are no categories in the category table --################################################################## --# criteria: SELECT count(*) = 0 from qrtz_locks insert into qrtz_locks values('TRIGGER_ACCESS'); --# criteria: SELECT count(*) = 0 from qrtz_locks insert into qrtz_locks values('JOB_ACCESS'); --# criteria: SELECT count(*) = 0 from qrtz_locks insert into qrtz_locks values('CALENDAR_ACCESS'); --# criteria: SELECT count(*) = 0 from qrtz_locks insert into qrtz_locks values('STATE_ACCESS'); --# criteria: SELECT count(*) = 0 from qrtz_locks insert into qrtz_locks values('MISFIRE_ACCESS'); It's driving my quietly crazy. I know this works with liquibase, so I wonder what could be the issue? I could really use some help from anyone who's more familiar with those tests, and with create.sql syntax in general. Cheers ... J ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ Please read the OpenNMS Mailing List FAQ: http://www.opennms.org/index.php/Mailing_List_FAQ opennms-devel mailing list To *unsubscribe* or change your subscription options, see the bottom of this page: https://lists.sourceforge.net/lists/listinfo/opennms-devel