grails(二)简单项目示例

最新推荐文章于 2025-08-10 13:40:07 发布

原创最新推荐文章于 2025-08-10 13:40:07 发布 · 136 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Grails #MySQL #JDBC #Groovy #Hibernate

Scripts 专栏收录该内容

299 篇文章

订阅专栏

本文介绍了Grails框架中数据库配置的具体方法，并详细展示了针对MySQL的数据源配置示例。此外，还解决了因未正确配置数据库驱动而导致的应用启动失败问题。

grails(二)简单项目示例

1.数据库配置
配置文件 grails-app/conf/DataSource.groovy
A typical configuration for MySQL may be something like:
dataSource {
pooled = true
dbCreate = "update"
url = "jdbc:mysql://localhost/yourDB"
driverClassName = "com.mysql.jdbc.Driver"
username = "yourUser"
password = "yourPassword"
}

my configuration:
dataSource {
pooled = true
dbCreate = "update"
driverClassName = "com.mysql.jdbc.Driver"
username = "easygrails"
password = "easygrails"
}
hibernate {
cache.use_second_level_cache=true
cache.use_query_cache=true
cache.provider_class='com.opensymphony.oscache.hibernate.OSCacheProvider'
}
// environment specific settings
environments {
development {
dataSource {
dbCreate = "create-drop" // one of 'create', 'create-drop','update'
url = "jdbc:mysql://www.sillycat.com/grails_dev"
}
}
test {
dataSource {
dbCreate = "update"
url = "jdbc:mysql://www.sillycat.com/grails_test"
}
}
production {
dataSource {
dbCreate = "update"
url = "jdbc:mysql://www.sillycat.com/grails_product"
}
}
}

启动报错：
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at org.codehaus.groovy.tools.RootLoader.findClass(RootLoader.java:146)

检查发现太兴奋了，数据库的驱动程序没有拷贝过来
拷贝文件mysql-connector-java-5.1.6.jar到lib目录下