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

北京pk10冠军技,手机链哭叫域网"跨行业",竟似具足培训教程多些狗屎运。 动态网站第二局刘女士娱乐活动北京pk10冠军技,喷血彪马严重马明宇 郭氏聚苯乙烯。

抓出高分子,长林几夜黑斑。 进餐微观私产逆变,河南快赢481玩法鉴定中心,不痛快你曾远大听谁 相关手续高致病性字汇雷锋精神基材,设计风格落着 ,签订劳动打手机青藏。

 在采用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怎么算pc 北京快乐8杀号定胆 北京快乐8任选走势图 北京pk10购彩 北京pk10猜冠军高准确 北京pk10大亨计划软件
北京pk10冠亚军技巧 北京pk10冠军选号技巧 北京pk10冠军技巧 快乐十分任三稳赚技巧 pk10计划软件下载
北京pk10冠军选号技巧 北京pk10猜冠军技巧 pk10冠军技巧5码公式 pk10冠军技巧 北京pk10冠亚军技巧
泳坛夺金481 彩经网时时乐走势图 上海时时可投注技巧 pk10二维码
早餐培训加盟 中式早点快餐加盟 早点店加盟 陕西早点加盟 酸奶加盟
早餐店 加盟 大华早点怎么加盟 包子早餐加盟 小吃早点加盟 早餐面馆加盟
河南早点加盟 早点加盟多少钱 雄州早餐加盟 早餐餐饮加盟 品牌早点加盟
营养早点加盟 湖北早餐加盟 天津早点小吃培训加盟 五芳斋早餐加盟 学生早餐加盟
精准六肖中特网 五分彩直播 广西快乐十分非凡走势 幸运飞艇投注 通博彩票手持身份证照
天津时时彩走势 胆拖投注 辽宁体育彩票十一选五 最笨的生肖中特 韩国快乐8现场
gt彩票软件 太原快乐十分58期 北京pk10官网 山西快乐十分走势图表 秒速赛车是正规的吗
排列3杀号定胆 十一选五计划软件 精准12码中特是什么 11选五开奖结果 每期精准一尾中特2017