每当我启动Grails应用程序时，所有域类都会收到这些错误。

ERROR hbm2ddl.SchemaExport  - HHH000389: Unsuccessful: drop table domain_class cascade constraints
ERROR hbm2ddl.SchemaExport  -ORA-01031: insufficient privileges

ERROR hbm2ddl.SchemaExport  -ORA-00942: table or view does not exist

dataSource {
    pooled = true
    driverClassName = "org.h2.Driver"
    username = "sa"
    password = ""
}
hibernate {
    cache.use_second_level_cache = true
    cache.use_query_cache = false
    cache.region.factory_class = 'net.sf.ehcache.hibernate.EhCacheRegionFactory'
}
// environment specific settings
environments {
    local {
        dataSource {
            dbCreate = "create-drop" // one of 'create', 'create-drop', 'update', 'validate', ''
            url = "jdbc:h2:mem:devDb;MVCC=TRUE;LOCK_TIMEOUT=10000"
        }
    }
    development {
        dataSource {
            dbCreate = "update" // one of 'create', 'create-drop', 'update', 'validate', ''
            url = "jdbc:h2:mem:devDb;MVCC=TRUE;LOCK_TIMEOUT=10000"
        }
    }
    test {
        dataSource {
            dbCreate = "update"
            url = "jdbc:h2:mem:testDb;MVCC=TRUE;LOCK_TIMEOUT=10000"
        }
    }

最佳答案

我们找到了答案。 resources文件夹中dataSource文件中的instanceConfig.local.properties指向Oracle数据库，但我没有配置为在该数据库中创建或删除表的角色。因此，权限不足错误。

即使DataSource.groovy具有内存数据库设置，我仍认为instanceConfig.local.properties覆盖了它。无论如何，感谢您的帮助!

https://stackoverflow.com/questions/29285521/