I had a problem to configure an h2 mem instace in mysql mode for our unit and semi-integrational tests. I’ve expirienced “no *public* schema” exception. And found simple solution for that on stackoverflow.com
Schema related problems with Flyway / Spring and H2 embedded database
To remember: The schema name in the init script should be quoted or the one you pass to Flyway put in uppercase.