Grails Prefixing all Tables (without changing the mapping of each domain class)

Grails Prefix Tables

// in "/src/groovy/MyNamingStrategy.groovy"
import org.hibernate.cfg.ImprovedNamingStrategy

/** Override the default naming strategy to support prefixing tables with the "MY_PREFIX_" */
class MyNamingStrategy extends ImprovedNamingStrategy {
    String classToTableName(String className) {
        "my_prefix_" + super.classToTableName(className)
    }
}


// in "/grails-app/conf/DataSource.groovy"
hibernate {
    cache.use_second_level_cache = true
    // ... other settings ...
    naming_strategy = 'MyNamingStrategy'
}