Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver grails-优快云博客

本文详细介绍了如何在Grails项目中配置Oracle数据库连接，包括修改DataSource配置，解决加载Oracle JDBC驱动类的问题，并通过命令清理和刷新依赖来确保项目正确运行。最后验证了项目在本地环境的正确性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

将ojdbc14.jar加到grails项目中的lib下，将conf包下的DataSource.groovy文件改为dataSource {

    pooled = true
    driverClassName = "oracle.jdbc.driver.OracleDriver"
    username = "scott"
    password = "xx"
}
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 {
    development {
        dataSource {
            dbCreate = "create-drop" // one of 'create', 'create-drop', 'update', 'validate', ''
            url = "jdbc:oracle:thin:@localhost:1521:orcl"
        }
    }
    test {
        dataSource {
            dbCreate = "update"
            url = "jdbc:oracle:thin:@localhost:1521:orcl"
        }
    }
    production {
        dataSource {
            dbCreate = "update"
            url = "jdbc:oracle:thin:@localhost:1521:orcl"
            pooled = true
            properties {
               maxActive = -1
               minEvictableIdleTimeMillis=1800000
               timeBetweenEvictionRunsMillis=1800000
               numTestsPerEvictionRun=3
               testOnBorrow=true
               testWhileIdle=true
               testOnReturn=true
               validationQuery="SELECT 1"
            }
        }
    }
}

运行run as grails command(run-app)后提示Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver

解决方法是（通过stackoverflow找到答案)

右击项目-grails tools-open gails command prompt(alt+shift+ctrl+G) 输入clean 然后输入compile --refresh-dependencies

此时再运行项目，并没有报错，在浏览器能正常打开 http://localhost:8080/testgrails说明项目运行成功

在pl/sql查看项目中的表是否存在于oracle数据库中

  显示表：

select  * from tab                
显示表结构：
  　select   *   from   user_tab_columns   where   table_name   =   upper('race')   在sqlplus输入desc race即可