grails链接mysql_grails 连接Mysql

1 安装这篇文章配置的：

http://blog.csdn.net/carolzhang8406/article/details/7766281

然后直接运行一直报错：

at groo2012-07-27 10:39:05,656 [main] ERROR context.GrailsContextLoader

- Error executing bootstraps: Error creating bean with name 'messageSource': In

itialization of bean failed; nested exception is org.springframework.beans.facto

ry.BeanCreationException: Error creating bean with name 'transactionManager': Ca

nnot resolve reference to bean 'sessionFactory' while setting bean property 'ses

sionFactory'; nested exception is org.springframework.beans.factory.BeanCreation

Exception: Error creating bean with name 'sessionFactory': Cannot resolve refere

nce to bean 'lobHandlerDetector' while setting bean property 'lobHandler'; neste

d exception is org.springframework.beans.factory.BeanCreationException: Error cr

eating bean with name 'lobHandlerDetector': Invocation of init method failed; ne

sted exception is org.springframework.jdbc.support.MetaDataAccessException: Erro

r while extracting DatabaseMetaData; nested exception is org.apache.commons.dbcp

.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'

org.springframework.beans.factory.BeanCreationException: Error creating bean wit

h name 'messageSource': Initialization of bean failed; nested exception is org.s

pringframework.beans.factory.BeanCreationException: Error creating bean with nam

e 'transactionManager': Cannot resolve reference to bean 'sessionFactory' while

setting bean property 'sessionFactory'; nested exception is org.springframework.

beans.factory.BeanCreationException: Error creating bean with name 'sessionFacto

ry': Cannot resolve reference to bean 'lobHandlerDetector' while setting bean pr

operty 'lobHandler'; nested exception is org.springframework.beans.factory.BeanC

reationException: Error creating bean with name 'lobHandlerDetector': Invocation

of init method failed; nested exception is org.springframework.jdbc.support.Met

can not load com.mysql.jdbc.Driver

.............................

..........................

然后google ，baidu  试了很多方法，都不对，人都快崩溃了，无意中看到下面这篇文章，找到问题所在，原来我所参考的文章并不对，下载这个zip包之后需要解压，把mysql-connector-java-5.1.21-bin.jar 这个拷贝到lib下面。

2.将MySql的Jar包放到项目的lib文件夹下

http://www.grsage.com/new/GrailsMysql.html

然后重新运行，搞定 。

dataSource {

pooled = true

driverClassName = "com.mysql.jdbc.Driver"

username = "root"

password = "root"

dialect = org.hibernate.dialect.MySQL5InnoDBDialect

}

hibernate {

cache.use_second_level_cache = true

cache.use_query_cache = true

cache.provider_class = 'net.sf.ehcache.hibernate.EhCacheProvider'

}

// environment specific settings

environments {

development {

dataSource {

dbCreate = "create" // one of 'create', 'create-drop','update'

url = "jdbc:mysql://127.0.0.1/grails?useUnicode=true&characterEncoding=UTF-8"  //你所创建的DB的名称，至于前面写localhost 和127那种都行，如果不在一个机器上，替换为对应的机器名。         }         hibernate {             show_sql = true         }     }     test {         dataSource {             dbCreate = "create-drop" // one of 'create', 'create-drop','update'              url = "jdbc:mysql://127.0.0.1/grails?useUnicode=true&characterEncoding=UTF-8"         }     }     production {         dataSource {             dbCreate = "update"              url = "jdbc:mysql://127.0.0.1/grails?useUnicode=true&characterEncoding=UTF-8"         }     } }