By simply adding schema to your domain classes, you won't be able to get it working in h2 afterwards. Here is how you fix that.
1. Update all your domain classes
grails-app/domain/Person.groovy
class Person {
String name
static mapping = {
table name: 'PERSON', schema:"MYSCHEMA"
}
}
2. Update all your datasource
grails-app/conf/DataSource.groovy:
environments {
development {
dataSource {
dbCreate = "create-drop"
url = "jdbc:h2:mem:devDb;MVCC=TRUE;LOCK_TIMEOUT=10000;INIT=CREATE SCHEMA IF NOT EXISTS MYSCHEMA"
}
repeat that for the test environment also.
Putting this in writing because I wish I had this blog post a while ago.
