解决失误导致grails连接mysql错误

最新推荐文章于 2022-03-19 11:17:14 发布
原创 最新推荐文章于 2022-03-19 11:17:14 发布 · 319 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#MySQL #Grails #Groovy #Bean #JDBC

本文记录了一次Grails应用程序启动失败的问题排查过程，详细解释了由于数据库配置不当导致的异常原因及解决方法。

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

"D:\Program Files\Java\jdk1.6.0_14\bin\java" -Xmx256M "-Dgrails.home=D:\Program Files\grails-1.2.0" -Dbase.dir=E:\Progect\java\Intellij\ScheduledTasks "-Dtools.jar=D:\Program Files\Java\jdk1.6.0_14\lib\tools.jar" "-Dgroovy.starter.conf=D:\Program Files\grails-1.2.0/conf/groovy-starter.conf" -Didea.launcher.port=7532 "-Didea.launcher.bin.path=D:\Program Files\JetBrains\IntelliJ IDEA 9.0\bin" -Dfile.encoding=GBK -classpath "D:\Program Files\grails-1.2.0\lib\groovy-all-1.6.7.jar;D:\Program Files\grails-1.2.0\dist\grails-bootstrap-1.2.0.jar;D:\Program Files\JetBrains\IntelliJ IDEA 9.0\lib\idea_rt.jar" com.intellij.rt.execution.application.AppMain org.codehaus.groovy.grails.cli.support.GrailsStarter --main org.codehaus.groovy.grails.cli.GrailsScriptRunner --conf "D:\Program Files\grails-1.2.0/conf/groovy-starter.conf" run-app
Welcome to Grails 1.2.0 - http://grails.org/
Licensed under Apache Standard License 2.0
Grails home is set to: D:\Program Files\grails-1.2.0

Base Directory: E:\Progect\java\Intellij\ScheduledTasks
Resolving dependencies...
Dependencies resolved in 2092ms.
Running script D:\Program Files\grails-1.2.0\scripts\RunApp.groovy
Environment set to development
  [groovyc] Compiling 1 source file to E:\Progect\java\Intellij\ScheduledTasks\target\classes
   [delete] Deleting directory I:\Users\Jeck\.grails\1.2.0\projects\ScheduledTasks\tomcat
Running Grails application..
2010-01-22 09:30:15,597 [main] ERROR context.ContextLoader  - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageSource': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '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 'sessionFactory': Cannot resolve reference to bean 'hibernateProperties' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 at org.grails.tomcat.TomcatServer.start(TomcatServer.groovy:135)
 at grails.web.container.EmbeddableServer$start.call(Unknown Source)
 at _GrailsRun_groovy$_run_closure5_closure12.doCall(_GrailsRun_groovy:158)
 at _GrailsRun_groovy$_run_closure5_closure12.doCall(_GrailsRun_groovy)
 at _GrailsSettings_groovy$_run_closure10.doCall(_GrailsSettings_groovy:287)
 at _GrailsSettings_groovy$_run_closure10.call(_GrailsSettings_groovy)
 at _GrailsRun_groovy$_run_closure5.doCall(_GrailsRun_groovy:149)
 at _GrailsRun_groovy$_run_closure5.call(_GrailsRun_groovy)
 at _GrailsRun_groovy.runInline(_GrailsRun_groovy:115)
 at _GrailsRun_groovy.this$4$runInline(_GrailsRun_groovy)
 at _GrailsRun_groovy$_run_closure1.doCall(_GrailsRun_groovy:59)
 at RunApp$_run_closure1.doCall(RunApp.groovy:33)
 at gant.Gant$_dispatch_closure4.doCall(Gant.groovy:324)
 at gant.Gant$_dispatch_closure6.doCall(Gant.groovy:334)
 at gant.Gant$_dispatch_closure6.doCall(Gant.groovy)
 at gant.Gant.withBuildListeners(Gant.groovy:344)
 at gant.Gant.this$2$withBuildListeners(Gant.groovy)
 at gant.Gant$this$2$withBuildListeners.callCurrent(Unknown Source)
 at gant.Gant.dispatch(Gant.groovy:334)
 at gant.Gant.this$2$dispatch(Gant.groovy)
 at gant.Gant.invokeMethod(Gant.groovy)
 at gant.Gant.processTargets(Gant.groovy:495)
 at gant.Gant.processTargets(Gant.groovy:480)
 at com.intellij.rt.execution.application.AppMain.main(AppMain.java:110)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '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 'sessionFactory': Cannot resolve reference to bean 'hibernateProperties' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 ... 24 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'hibernateProperties' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 ... 24 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 ... 24 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 ... 24 more
Caused by: org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 ... 24 more
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 ... 24 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
 at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
 ... 24 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
 at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)
 at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)
 at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
 at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
 at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
 at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
 ... 25 more
Caused by: java.net.ConnectException: Connection refused: connect
 at java.net.PlainSocketImpl.socketConnect(Native Method)
 at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
 at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
 at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
 at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
 at java.net.Socket.connect(Socket.java:519)
 at java.net.Socket.connect(Socket.java:469)
 at java.net.Socket.<init>(Socket.java:366)
 at java.net.Socket.<init>(Socket.java:209)
 at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
 at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
 at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027)
 ... 34 more
2010-01-22 09:30:15,605 [main] ERROR [localhost].[/ScheduledTasks]  - Exception sending context initialized event to listener instance of class org.codehaus.groovy.grails.web.context.GrailsContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'messageSource': Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '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 'sessionFactory': Cannot resolve reference to bean 'hibernateProperties' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 at org.grails.tomcat.TomcatServer.start(TomcatServer.groovy:135)
 at grails.web.container.EmbeddableServer$start.call(Unknown Source)
 at _GrailsRun_groovy$_run_closure5_closure12.doCall(_GrailsRun_groovy:158)
 at _GrailsRun_groovy$_run_closure5_closure12.doCall(_GrailsRun_groovy)
 at _GrailsSettings_groovy$_run_closure10.doCall(_GrailsSettings_groovy:287)
 at _GrailsSettings_groovy$_run_closure10.call(_GrailsSettings_groovy)
 at _GrailsRun_groovy$_run_closure5.doCall(_GrailsRun_groovy:149)
 at _GrailsRun_groovy$_run_closure5.call(_GrailsRun_groovy)
 at _GrailsRun_groovy.runInline(_GrailsRun_groovy:115)
 at _GrailsRun_groovy.this$4$runInline(_GrailsRun_groovy)
 at _GrailsRun_groovy$_run_closure1.doCall(_GrailsRun_groovy:59)
 at RunApp$_run_closure1.doCall(RunApp.groovy:33)
 at gant.Gant$_dispatch_closure4.doCall(Gant.groovy:324)
 at gant.Gant$_dispatch_closure6.doCall(Gant.groovy:334)
 at gant.Gant$_dispatch_closure6.doCall(Gant.groovy)
 at gant.Gant.withBuildListeners(Gant.groovy:344)
 at gant.Gant.this$2$withBuildListeners(Gant.groovy)
 at gant.Gant$this$2$withBuildListeners.callCurrent(Unknown Source)
 at gant.Gant.dispatch(Gant.groovy:334)
 at gant.Gant.this$2$dispatch(Gant.groovy)
 at gant.Gant.invokeMethod(Gant.groovy)
 at gant.Gant.processTargets(Gant.groovy:495)
 at gant.Gant.processTargets(Gant.groovy:480)
 at com.intellij.rt.execution.application.AppMain.main(AppMain.java:110)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '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 'sessionFactory': Cannot resolve reference to bean 'hibernateProperties' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 ... 24 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory': Cannot resolve reference to bean 'hibernateProperties' while setting bean property 'hibernateProperties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 ... 24 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateProperties': Cannot resolve reference to bean 'dialectDetector' while setting bean property 'properties' with key [hibernate.dialect]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 ... 24 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dialectDetector': Invocation of init method failed; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 ... 24 more
Caused by: org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 ... 24 more
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 ... 24 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure

Last packet sent to the server was 0 ms ago.)
 at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)
 at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
 ... 24 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
 at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)
 at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)
 at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
 at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
 at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247)
 at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)
 ... 25 more
Caused by: java.net.ConnectException: Connection refused: connect
 at java.net.PlainSocketImpl.socketConnect(Native Method)
 at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
 at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
 at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
 at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
 at java.net.Socket.connect(Socket.java:519)
 at java.net.Socket.connect(Socket.java:469)
 at java.net.Socket.<init>(Socket.java:366)
 at java.net.Socket.<init>(Socket.java:209)
 at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
 at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
 at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027)
 ... 34 more
2010-01-22 09:30:15,613 [main] ERROR core.StandardContext  - Error listenerStart
2010-01-22 09:30:15,730 [main] ERROR core.StandardContext  - Context [/ScheduledTasks] startup failed due to previous errors
Server running. Browse to http://localhost:8080/ScheduledTasks

Process finished with exit code 1

 以上是错误的细节部分，引起上述错误的原因是因为在开发模式下，默认的数据库创建模式为create-drop，但是若该成update也不会报错，但是当domain类改变的时候，就汇报上面的错误，原因是domain类与数据库无法对应映射了，解决方法是把update改成create-drop就可以了。

dataSource {
	pooled = true
	driverClassName = "com.mysql.jdbc.Driver"
	username = "root"
	password = "1234"
}
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-drop" // one of 'create', 'create-drop','update'  &autoReconnect=true&failOverReadOnly=false
			url = "jdbc:mysql://localhost:3306/scheduledtasks?useUnicode=true&characterEncoding=UTF-8"
		}
	}
	test {
		dataSource {
			dbCreate = "update"
			url = "jdbc:hsqldb:mem:testDb"
		}
	}
	production {
		dataSource {
			dbCreate = "update"
			url = "jdbc:hsqldb:file:prodDb;shutdown=true"
		}
	}
}

 

grails 连接mysql
08-07
这个例子实现了用grails 连接mysql 数据库，并且把内容显示出来，可以增删除改，下载这个例子后大家要把jdk tomcat grails环境搭好，然后用grails run-app来执行，也可以用其它的开发工具，本人用的是netbeans
idea连接mysql数据库.docx
06-14
- **代码分析**：实时检测代码中的错误和潜在问题，并提供解决方案。 - **重构功能**：支持多种重构操作，如重命名、提取方法、改变方法签名等，确保代码的一致性和可维护性。 2. **丰富的插件生态**：拥有一个...
grails 连接Mysql
从菜鸟到菜菜鸟
07-27 4253
1 安装这篇文章配置的： http://blog.youkuaiyun.com/carolzhang8406/article/details/7766281 然后直接运行一直报错：         at groo2012-07-27 10:39:05,656 [main] ERROR context.GrailsContextLoader  - Error executing bootst
grails链接mysql_grails 连接Mysql
weixin_39860260的博客
01-26 119
1 安装这篇文章配置的：http://blog.youkuaiyun.com/carolzhang8406/article/details/7766281然后直接运行一直报错：at groo2012-07-27 10:39:05,656 [main] ERROR context.GrailsContextLoader- Error executing bootstraps: Error creating be...
grails mysql_Grails：连接mysql数据库
weixin_36116008的博客
01-19 215
Grails切换到mysql数据库需要做如下的配置：1、将mysql-connector-java-5.1.22-bin.jar驱动复制到Grails应用的根目录lib下面。2、修改conf/DataSource.groovy;Grails默认用的是H2数据库，我们需要将driverClassName = "org.h2.Driver" 改成 driverClassName = 'com.mysq...
grails mysql,Grails和MySQL连接异常
weixin_35892206的博客
03-19 98
我有一个正在生产的grails应用程序.今天早上,我被告知服务器无法解析的事实. Tomcat在旋转.我进行了研究,发现它与MySQL有关,导致闲置8个小时后连接超时. I have found examples on stackoverflow人有类似的问题.但是,所有这些人都提到,如果他们再次命中服务器并刷新了连接.对我来说,该站点完全关闭了,Tomcat无法响应.听起来这里还有其他作用吗？T...
Grails, MySQL : Cannot create PoolableConnectionFactory
蛋疼先生的手札
08-29 243
Ok, You read this post I assume you face the same problem I faced. Quick Solution : If this is your MySQL Connection URL : “jdbc:mysql://localhost/DN_NAME” Change it to “jdbc:mysql://127....
Grails连接MySQL数据库操作示例教程
在本示例中，将介绍如何使用Grails框架来连接和操作MySQL数据库。Grails是一个基于Groovy语言的开源框架，用于快速开发Web应用程序。它遵循模型-视图-控制器（MVC）架构模式，提供了一套完整的开发工具，使得开发...
grails连接mysql的配置文件
05-23
在 Grails 中，连接 MySQL 的配置文件为 `DataSource.groovy`，位于 `grails-app/conf/` 目录下。以下是一个简单的示例： ``` dataSource { pooled = true driverClassName = "com.mysql.jdbc.Driver" dialect =...
grails mysql
最新发布
07-16
**配置**: Grails项目创建后，默认会包含一个DataSource.groovy配置文件，你可以在这里设置数据库URL、用户名和密码等信息，将`driverClassName`设置为`com.mysql.jdbc.Driver`，`url`设置为你MySQL服务器的连接字符...
Cannot create PoolableConnectionFactory (Could not create connection to database server.)
weixin_30443747的博客
09-06 457
是由于mysql驱动版本太低导致。 本人 jdk版本是1.8.0_211，mysql版本是8.0.17，mysql-connector-java版本是5.1.39， 后来把mysql-connector-java改为最新版mysql-connector-java-8.0.17.jar后，运行成功。 pom文件为： <!-- https://mvnreposito...
Could not get JDBC Connection； nested exception is java.sql.SQLException: Access denied for user ‘ro
weixin_46475607的博客
03-19 3675
Could not get JDBC Connection; nested exception is java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: NO) 分析原因：没有用密码登陆root 1、我是有设置密码的，而且Navicat也能连接成功 2、配置文件没有语法错误，username和password编写正确 3、用户权限也都加了 但还是连接不上TAT 既然不要密码，那干脆把mysql的密
ssh连接mysql遇到的一些问题
有梦的少年
07-04 6871
  问题1：连接高版本的MySQL的会要求建立SSL连接 警告: Error while extracting database product name - falling back to empty error codes org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection...
Could not get JDBC Connection; nested exception is java.sql.SQLException: The server time zone value
lgwer88的博客
03-18 2886
@TOC** 在连接MySQL的时候报错 ** 一、Mysql安装时设置设置时区与当前电脑系统时区不符。 报错：Could not get JDBC Connection; nested exception is java.sql.SQLException: The server time zone value ‘Öйú±ê׼ʱ¼ä’ is unrecognized or represent...
项目中mysql数据库连接问题：这里用的是jdbc，c3p0
小冷
10-16 1957
出现这种错： org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta-data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Fail...
could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could
MrZhang的博客
03-20 9487
1报错： could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet // 标记资源的statu为 -999 basResourceRepo.updateStatusByResId(recId); 就一个upda...
mysql数据库面试题红包_我这个数据库用户名密码都正确，却提示错误,解决问题发10元红包童叟无欺...
weixin_36180385的博客
02-18 144
java.sql.SQLException:Accessdeniedforuser'root'@'localhost'(usingpassword:YES)2018-03-2119:34:14.281WARN8036---[main]o.s.b.a.orm.jpa.DatabaseLookup:Unabletodete...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值