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

北京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(#替换为@)。期待你的好消息!
北京pk10 聚彩 北京快乐8预测软件下载 北京pk10大特规律 北京pk10的公式怎么算 北京快乐8双盘正码 河南快赢481技巧
北京pk10猜冠军技巧 pk10计划软件5码手机版 北京赛车pk10追号 北京pk10只押冠军技巧
pk10冠军技巧5码公式 北京pk10冠军技巧 北京pk10冠军选号技巧 北京pk10冠军选号技巧 北京pk10冠军技巧
时时乐开奖走势图 什么是时时乐 北京pk10高手计划群 北京pk10在线精准计划 北京中和信
酒店加盟 凡夫子早餐加盟 上海早点加盟 加盟早点 书店加盟
江西早点加盟 早餐加盟排行榜 早餐肠粉加盟 早点快餐加盟 早餐加盟好项目
北京早点小吃培训加盟 包子早点加盟 凡夫子早餐加盟 早点加盟网 早点小吃加盟连锁
小吃早点加盟 早点连锁加盟店 早餐加盟费用 健康早点加盟 早餐连锁店
深圳风采 浙江十一选五开奖记录 体彩11选五 黑龙江快乐十分开奖结果 吉林快3计划
广东11选5开奖记录 广东快乐十分选号技巧 世界杯去哪买彩票 云南十一选五开奖 澳洲幸运10开奖公正吗
白姐六合图库 新疆福彩18选7走势图 快3吧 喜羊羊特码网站 新疆风采35选7开奖
太阳网六合图库 广西快三数据 贵州11选5遗漏号码 吉林快三大小单双软件 重庆时时彩官网骗局