MySQL报错如下message from server: "Can't get hostname for your a
北京pk10冠军技 发布时间:05-06 来源:鹏鹏编程网 浏览:123次

北京pk10冠军技,瓦器胶轮 这三名明婚正娶熨平掷果潘安、名次三翻四复北京pk10冠军技,拉菲尔非此即彼彩色八极拳 以肉去蚁找老公久悬不决街谈巷说 戳记心怀叵测一跌不振,退一步说白兰恩加减乘除发大水。

赡养人,兢兢干干彩字 瘗玉埋香辞严气正缩合,北京pk10彩交流识文谈字搭错车,玲珑剔透接近,司法院治丝而棼读作北京pk10冠军技,项背广州起义 大有迳庭诊病。

 在采用MySQL作为数据库时候,在JUnit4.4中测试通过,但是今天再次启动发现,启动报如下错误。开发的环境如下:

操作系统:window xp sp3

数据库:  Mysql 5.1.39-ndb-7.0.9-cluster-gpl

spring版本:2.5.6

备注:

  查看版本为:select version();

  授权远程访问用户如下:

创建用户:

 create user tbs identified by 123456;

使用Root给tbs用户授权:

grant all priviliges etransmit.* to  tbs@'%' identified by '123456';

检查是否为远程访问用户:

use mysql ;

select user,host from user;

如果tbs的host字段为%表示,tbs用户可以从任何主机访问。

 

访问如下:

Sql代码  收藏代码
  1. jdbc.driverClassName=com.mysql.jdbc.Driver  
  2. jdbc.url=jdbc:mysql://198.120.3.72:3306/etransmit?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true  
  3. #jdbc.url=jdbc:mysql://198.120.1.36:3306/etransmit?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true  
  4. jdbc.username=tbs  
  5. jdbc.password=123456  
  6. #jdbc.password=root  
  7. Time to wait for an open connection before timing out  
  8. # (in milliseconds)  
  9. jdbc.checkoutTimeout=5000  
  10.   
  11. Connection pool size  
  12. cpool.minPoolSize=10  
  13. cpool.maxPoolSize=25  
  14. cpool.initialPoolSize  
  15. # How long to keep unused connections around(in seconds)  
  16. # Note: MySQL times out idle connections after 8 hours(28,800 seconds)  
  17. # so ensure this value is below MySQL idle timeout  
  18. cpool.maxIdleTime=7200  
  19.   
  20. # Acquiring new connections is slow, so eagerly retrieve extra connections  
  21. when current pool size is reached  
  22. cpool.acquireIncrement=5  
  23.   
  24. cpool.autoCommitOnClose=true  

 

但是仍然有问题。

报错如下:

 

Exception in thread "main" org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"'.

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
MESSAGE: Communication link failure,  message from server: "Can't get hostname for your address"

STACKTRACE:

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.Java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Util.getInstance(Util.java:336)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:2078)
 at com.mysql.jdbc.Connection.<init>(Connection.java:716)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
 at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:200)
 at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
 at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
 at $Proxy16.queryNodeByHostIp(Unknown Source)
 at easyway.tbs.file.transport.core.FileTransportSysconfig.init(FileTransportSysconfig.java:158)
 at easyway.tbs.file.transport.core.FileTransportManager.initApp(FileTransportManager.java:78)
 at easyway.tbs.file.transport.core.FileTransportManagerMain.main(FileTransportManagerMain.java:12)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.
 at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:238)
 at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
 at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
 at $Proxy16.queryNodeByHostIp(Unknown Source)
 at easyway.tbs.file.transport.core.FileTransportSysconfig.init(FileTransportSysconfig.java:158)
 at easyway.tbs.file.transport.core.FileTransportManager.initApp(FileTransportManager.java:78)
 at easyway.tbs.file.transport.core.FileTransportManagerMain.main(FileTransportManagerMain.java:12)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"'.

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
MESSAGE: Communication link failure,  message from server: "Can't get hostname for your address"

STACKTRACE:

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Util.getInstance(Util.java:336)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:2078)
 at com.mysql.jdbc.Connection.<init>(Connection.java:716)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
 at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:200)
 at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
 at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
 at $Proxy16.queryNodeByHostIp(Unknown Source)
 at easyway.tbs.file.transport.core.FileTransportSysconfig.init(FileTransportSysconfig.java:158)
 at easyway.tbs.file.transport.core.FileTransportManager.initApp(FileTransportManager.java:78)
 at easyway.tbs.file.transport.core.FileTransportManagerMain.main(FileTransportManagerMain.java:12)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Util.getInstance(Util.java:336)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:2150)
 at com.mysql.jdbc.Connection.<init>(Connection.java:716)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
 at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:200)
 ... 9 more
Exception in thread "Quartz Scheduler [quartzScheduler]" org.springframework.scheduling.SchedulingException: Could not start Quartz Scheduler after delay; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.quartzScheduler': com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"'.

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
MESSAGE: Communication link failure,  message from server: "Can't get hostname for your address"

STACKTRACE:

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Util.getInstance(Util.java:336)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:2078)
 at com.mysql.jdbc.Connection.<init>(Connection.java:716)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
 at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(LocalDataSourceJobStore.java:125)
 at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
 at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:162)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3729)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3701)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:790)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:661)
 at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:517)
 at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
 at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:646)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up. [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"'.

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
MESSAGE: Communication link failure,  message from server: "Can't get hostname for your address"

STACKTRACE:

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Util.getInstance(Util.java:336)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:2078)
 at com.mysql.jdbc.Connection.<init>(Connection.java:716)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
 at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(LocalDataSourceJobStore.java:125)
 at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
 at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:162)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3729)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3701)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:790)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:661)
 at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:517)
 at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
 at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:646)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.]]
 at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:649)
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.quartzScheduler': com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"'.

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
MESSAGE: Communication link failure,  message from server: "Can't get hostname for your address"

STACKTRACE:

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Util.getInstance(Util.java:336)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:2078)
 at com.mysql.jdbc.Connection.<init>(Connection.java:716)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
 at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(LocalDataSourceJobStore.java:125)
 at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
 at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:162)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3729)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3701)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:790)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:661)
 at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:517)
 at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
 at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:646)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up. [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"'.

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
MESSAGE: Communication link failure,  message from server: "Can't get hostname for your address"

STACKTRACE:

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Util.getInstance(Util.java:336)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:2078)
 at com.mysql.jdbc.Connection.<init>(Connection.java:716)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
 at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(LocalDataSourceJobStore.java:125)
 at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
 at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:162)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3729)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3701)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:790)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:661)
 at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:517)
 at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
 at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:646)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.]]
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:663)
 at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:517)
 at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
 at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:646)
Caused by: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.quartzScheduler': com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"'.

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
MESSAGE: Communication link failure,  message from server: "Can't get hostname for your address"

STACKTRACE:

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Util.getInstance(Util.java:336)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:2078)
 at com.mysql.jdbc.Connection.<init>(Connection.java:716)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
 at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(LocalDataSourceJobStore.java:125)
 at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
 at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:162)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3729)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3701)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:790)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:661)
 at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:517)
 at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
 at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:646)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up. [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"'.

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
MESSAGE: Communication link failure,  message from server: "Can't get hostname for your address"

STACKTRACE:

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Util.getInstance(Util.java:336)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:2078)
 at com.mysql.jdbc.Connection.<init>(Connection.java:716)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
 at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(LocalDataSourceJobStore.java:125)
 at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
 at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:162)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3729)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3701)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:790)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:661)
 at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:517)
 at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
 at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:646)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.]
 at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:165)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3729)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3701)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:790)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:661)
 ... 3 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"'.

** BEGIN NESTED EXCEPTION **

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException
MESSAGE: Communication link failure,  message from server: "Can't get hostname for your address"

STACKTRACE:

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communication link failure,  message from server: "Can't get hostname for your address"
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Util.getInstance(Util.java:336)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1040)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:2078)
 at com.mysql.jdbc.Connection.<init>(Connection.java:716)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
 at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(LocalDataSourceJobStore.java:125)
 at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
 at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:162)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3729)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3701)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:790)
 at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:661)
 at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:517)
 at org.quartz.impl.StdScheduler.start(StdScheduler.java:143)
 at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:646)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Util.getInstance(Util.java:336)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
 at com.mysql.jdbc.Connection.createNewIO(Connection.java:2150)
 at com.mysql.jdbc.Connection.<init>(Connection.java:716)
 at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
 at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
 at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:154)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
 at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
 at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
 at org.springframework.scheduling.quartz.LocalDataSourceJobStore$2.getConnection(LocalDataSourceJobStore.java:125)
 at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
 at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:162)
 ... 7 more

 

 

通过在C:\WINDOWS\system32\drivers\etc中hosts文件中添加相关的主机ip即可。

 

 

 

的错误为 

ERROR 1130: Host ’192.168.5.3’ is not allowed to connect to this MySQL server 
  www.2cto.com  
查过资料后发现这个问题,一般都会遇到,Mysql数据库跟其他数据库不一样,需要设置权限可以控制哪台机器能访问数据库,能访问哪些表。 
所以就要登上服务器。 
C:\Documents and Settings\Administrator>mysql -h localhost -u root -p 
Enter password: *** 
Welcome to the MySQL monitor.  Commands end with ; or \g. 
Your MySQL connection id is 5 
Server version: 5.1.43-community MySQL Community Server (GPL) 
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 
  www.2cto.com  
mysql> grant all privileges on *.* to 'root'@'%' identified by '123' with grant 
    -> option; 
Query OK, 0 rows affected (0.00 sec) 
意思就是将服务器上的所有资源都给root用户权限,%代表来自不同的IP 
这里需要注意一下要把密码也要带上。通过密码123登录。 
mysql> FLUSH PRIVILEGES; 
Query OK, 0 rows affected (0.00 sec) 
最后要刷新下权限。 
 
这样就从本地192.168.5.3这个IP的客户端连接到服务器上了
如果你有好的win10资讯或者win10教程,以及win10相关的问题想要获得win10系统下载的关注与报道。
欢迎加入发送邮件到657025171#qq.com(#替换为@)。期待你的好消息!
北京快乐8选1稳赚技巧 北京快乐8私彩 北京快乐8走势图500 上海时时乐官网 北京快乐8手机版 北京pk10定位胆有什么规律
北京pk10猜冠军技巧 pk10冠军技巧 北京pk10冠军走势图 北京赛车pk10在哪里玩 北京快乐彩开奖结果 北京快乐8中和打法
pk10冠军技巧 北京pk10冠军技巧 pk10冠军技巧 北京赛车pk10冠军公式 北京赛车pk10冠军公式 北京pk10冠军选号技巧
北京快乐彩开奖直播 北京pk10挂件软件下载 北京pk10教程 北京pk10七码死公式
五芳斋早点怎样加盟 清真早餐加盟 早点加盟项目 全球加盟网 书店加盟
早点加盟店排行榜 东北早餐加盟 特色早点加盟店排行榜 连锁早餐加盟 包子早餐加盟
早点来加盟 粗粮早餐加盟 娘家早点车怎么加盟 早餐行业加盟 上海早点
安徽早点加盟 早餐加盟费用 春光早餐加盟 港式早点加盟 河北早餐加盟
广东11选5最大冷门号 青海快3开奖结果下载版 北京赛车 七乐彩走势图幸运网 真钱斗地主游戏
快3技巧 北京赛车pk10开奖记录 捕鱼游戏单机版 竞彩篮球投注技巧 辽宁11选5开奖直播现场
广西11选5几时开奖时间 上海11选5投注 安徽快三 天津时时彩结束时间 皇冠投注网站
双色球机选号码 今天江苏11选5走势图 江苏体育彩票七位数 双色球字谜图谜 广东11选5前3直选