将Oracle数据库连接到Grails 3

我正在尝试将Oracle数据库用于Grails项目.我使用命令行工具.

至今：

>我已将ojdb6放入我必须自己创建的lib目录中,位于我的应用程序的根目录下
>我修改了application.yml如下：

dataSource:
    pooled: true
    jmxExport: true
    driverClassName: oracle.jdbc.OracleDriver
    username: usrname
    password: pwd

environments:
    development:
        dataSource:
            dbCreate: create-drop
            url: jdbc:oracle:thin:@//url:port/db
    test:
        dataSource:
            dbCreate: update
            url: jdbc:oracle:thin:@//url:port/db
    production:
        dataSource:
            dbCreate: update
            url: jdbc:oracle:thin:@//url:port/db
            properties:
                jmxEnabled: true
                initialSize: 5
                maxActive: 50
                minIdle: 5
                maxIdle: 25
                maxWait: 10000
                maxAge: 600000
                timeBetweenEvictionRunsMillis: 5000
                minEvictableIdleTimeMillis: 60000
                validationQuery: SELECT 1
                validationQueryTimeout: 3
                validationInterval: 15000
                testOnBorrow: true
                testWhileIdle: true
                testOnReturn: false
                jdbcInterceptors: ConnectionState
                defaultTransactionIsolation: 2 # TRANSACTION_READ_COMMITTED

>我还创建了一个具有Integer属性的域类,只是为了试一试.

但是,它似乎不起作用.我收到一条巨大的错误消息,甚至不适合我的命令窗口.当我使用–stacktrace时,第一条消息是“无法启动服务器”.

我一直试图解决这个问题三天,欢迎任何想法/评论.非常感谢你.

旁注：当我使用默认数据库时,everythink工作正常,不会改变配置中的任何内容.

解决方法

尝试以下,它应该工作.如果它没有发布堆栈跟踪.下面的片段为我工作.

添加依赖：
????runtime’oracle：ojdbc6：11.2.0.4.0′

application.yml中的变化：

environments:
    dataSource:
        pooled: true
        jmxExport: true
        driverClassName: org.h2.Driver
        username: sa
        password:


development:
    dataSource:
        dbCreate: validate
        url: jdbc:oracle:thin:@xxxx:1521:xx
        driverClassName: oracle.jdbc.OracleDriver
        dialect: org.hibernate.dialect.Oracle10gDialect
        username: "XXXXXX"
        password: "XXXXXX"
        properties:
           ***: **
           ***: **
test:
    dataSource:
        dbCreate: update
        url: jdbc:h2:mem:testDb;MVCC=TRUE;LOCK_TIMEOUT=10000;DB_CLOSE_ON_EXIT=FALSE

production:
    dataSource:
        dbCreate: update
        url: jdbc:h2:prodDb;MVCC=TRUE;LOCK_TIMEOUT=10000;DB_CLOSE_ON_EXIT=FALSE
        properties:
            jmxEnabled: true
            initialSize: 5
            maxActive: 50
            minIdle: 5
            maxIdle: 25
            maxWait: 10000
            maxAge: 600000
            timeBetweenEvictionRunsMillis: 5000
            minEvictableIdleTimeMillis: 60000
            validationQuery: SELECT 1
            validationQueryTimeout: 3
            validationInterval: 15000
            testOnBorrow: true
            testWhileIdle: true
            testOnReturn: false
            jdbcInterceptors: ConnectionState
            defaultTransactionIsolation: 2 # TRANSACTION_READ_COMMITTED