root@yell1-xml1:/usr/local/tsa/pointRadiiMigration/migratorScript# ls -ltr total 20008 -rwxrwxrwx 1 root root 27226 Nov 6 10:24 jboss-saaj.jar -rwxrwxrwx 1 root root 211 Dec 11 08:23 GoogleMigratorPhase2.sh -rwxrwxrwx 1 root root 198 Dec 11 08:24 GoogleMigratorPhase1.sh -rwxrwxrwx 1 root root 1298592 Dec 11 10:03 bing-api.jar -rwxrwxrwx 1 root root 201 Dec 11 10:20 BingMigratorPhase1.sh -rwxrwxrwx 1 root root 312 Dec 11 10:20 BingMigratorPhase2.sh -rwxrwxrwx 1 root root 19079756 Dec 12 09:53 migrator-0.0.1-SNAPSHOT-jar-with-dependencies.jar root@yell1-xml1:/usr/local/tsa/pointRadiiMigration/migratorScript# ./GoogleMigratorPhase1.sh phase1 noPhase2 Starting Google Phase1 with paramters part1: phase1 part2: noPhase2 2013-12-19 09:29:35 INFO ClassPathXmlApplicationContext:411 - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@43256ea2: display name [org.springframework.context.support.ClassPathXmlApplicationContext@43256ea2]; startup date [Thu Dec 19 09:29:35 GMT 2013]; root of context hierarchy 2013-12-19 09:29:35 INFO XmlBeanDefinitionReader:323 - Loading XML bean definitions from class path resource [spring-module.xml] 2013-12-19 09:29:35 INFO XmlBeanDefinitionReader:323 - Loading XML bean definitions from class path resource [spring-datasource.xml] 2013-12-19 09:29:36 INFO XmlBeanDefinitionReader:323 - Loading XML bean definitions from class path resource [spring-beans.xml] 2013-12-19 09:29:37 INFO ClassPathXmlApplicationContext:426 - Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext@43256ea2]: org.springframework.beans.factory.support.DefaultListableBeanFactory@1e2acc65 2013-12-19 09:29:38 INFO DefaultListableBeanFactory:414 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1e2acc65: defining beans [org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,gceDataSource,mmsDataSource,bceDataSource,gtCampaignTargetDAO,gtCampaignManager,GTCampaignDAO,bingGTCampaignTargetDAO,bingGTCampaignManager,bingGTCampaignDAO,bingMigrator,migrator]; root of factory hierarchy 2013-12-19 09:29:38 INFO DriverManagerDataSource:155 - Loaded JDBC driver: com.mysql.jdbc.Driver 2013-12-19 09:29:38 INFO DriverManagerDataSource:155 - Loaded JDBC driver: com.mysql.jdbc.Driver 2013-12-19 09:32:48 INFO DefaultListableBeanFactory:421 - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1e2acc65: defining beans [org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,gceDataSource,mmsDataSource,bceDataSource,gtCampaignTargetDAO,gtCampaignManager,GTCampaignDAO,bingGTCampaignTargetDAO,bingGTCampaignManager,bingGTCampaignDAO,bingMigrator,migrator]; root of factory hierarchy Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'gtCampaignManager': Autowiring of methods failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire method: public void com.thesearchagency.GTCampaignManager.setDAO(com.thesearchagency.GTCampaignDAO,com.thesearchagency.GTCampaignTargetDAO); nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'GTCampaignDAO' defined in URL [jar:file:/usr/local/tsa/pointRadiiMigration/migratorScript/migrator-0.0.1-SNAPSHOT-jar-with-dependencies.jar!/com/thesearchagency/GTCampaignDAO.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.thesearchagency.GTCampaignDAO]: Constructor threw exception; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:256) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:998) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380) at org.springframework.context.support.ClassPathXmlApplicationContext.(ClassPathXmlApplicationContext.java:139) at org.springframework.context.support.ClassPathXmlApplicationContext.(ClassPathXmlApplicationContext.java:83) at com.thesearchagency.GTCampaignManager.main(GTCampaignManager.java:42) Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire method: public void com.thesearchagency.GTCampaignManager.setDAO(com.thesearchagency.GTCampaignDAO,com.thesearchagency.GTCampaignTargetDAO); nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'GTCampaignDAO' defined in URL [jar:file:/usr/local/tsa/pointRadiiMigration/migratorScript/migrator-0.0.1-SNAPSHOT-jar-with-dependencies.jar!/com/thesearchagency/GTCampaignDAO.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.thesearchagency.GTCampaignDAO]: Constructor threw exception; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:543) at org.springframework.beans.factory.annotation.InjectionMetadata.injectMethods(InjectionMetadata.java:117) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:253) ... 16 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'GTCampaignDAO' defined in URL [jar:file:/usr/local/tsa/pointRadiiMigration/migratorScript/migrator-0.0.1-SNAPSHOT-jar-with-dependencies.jar!/com/thesearchagency/GTCampaignDAO.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.thesearchagency.GTCampaignDAO]: Constructor threw exception; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:283) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:671) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:610) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:499) ... 18 more Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.thesearchagency.GTCampaignDAO]: Constructor threw exception; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248) ... 30 more Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:474) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:479) at com.thesearchagency.GTCampaignDAO.getGlobalPointRadiusMultiplier(GTCampaignDAO.java:375) at com.thesearchagency.GTCampaignDAO.(GTCampaignDAO.java:38) 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:494) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:100) ... 32 more Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103) at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:718) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:140) 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.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79) ... 44 more Caused by: java.net.ConnectException: Connection timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:520) at java.net.Socket.connect(Socket.java:470) at java.net.Socket.(Socket.java:367) at java.net.Socket.(Socket.java:209) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:280) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026) ... 55 more root@yell1-xml1:/usr/local/tsa/pointRadiiMigration/migratorScript# root@yell1-xml1:/usr/local/tsa/pointRadiiMigration/migratorScript# ./GoogleMigratorPhase1.sh phase1 phase2 Starting Google Phase1 with paramters part1: phase1 part2: phase2 2013-12-19 09:33:47 INFO ClassPathXmlApplicationContext:411 - Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@43256ea2: display name [org.springframework.context.support.ClassPathXmlApplicationContext@43256ea2]; startup date [Thu Dec 19 09:33:47 GMT 2013]; root of context hierarchy 2013-12-19 09:33:47 INFO XmlBeanDefinitionReader:323 - Loading XML bean definitions from class path resource [spring-module.xml] 2013-12-19 09:33:47 INFO XmlBeanDefinitionReader:323 - Loading XML bean definitions from class path resource [spring-datasource.xml] 2013-12-19 09:33:47 INFO XmlBeanDefinitionReader:323 - Loading XML bean definitions from class path resource [spring-beans.xml] 2013-12-19 09:33:48 INFO ClassPathXmlApplicationContext:426 - Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext@43256ea2]: org.springframework.beans.factory.support.DefaultListableBeanFactory@1e2acc65 2013-12-19 09:33:48 INFO DefaultListableBeanFactory:414 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1e2acc65: defining beans [org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,gceDataSource,mmsDataSource,bceDataSource,gtCampaignTargetDAO,gtCampaignManager,GTCampaignDAO,bingGTCampaignTargetDAO,bingGTCampaignManager,bingGTCampaignDAO,bingMigrator,migrator]; root of factory hierarchy 2013-12-19 09:33:48 INFO DriverManagerDataSource:155 - Loaded JDBC driver: com.mysql.jdbc.Driver 2013-12-19 09:33:48 INFO DriverManagerDataSource:155 - Loaded JDBC driver: com.mysql.jdbc.Driver 2013-12-19 09:36:57 INFO DefaultListableBeanFactory:421 - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1e2acc65: defining beans [org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,gceDataSource,mmsDataSource,bceDataSource,gtCampaignTargetDAO,gtCampaignManager,GTCampaignDAO,bingGTCampaignTargetDAO,bingGTCampaignManager,bingGTCampaignDAO,bingMigrator,migrator]; root of factory hierarchy Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'gtCampaignManager': Autowiring of methods failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire method: public void com.thesearchagency.GTCampaignManager.setDAO(com.thesearchagency.GTCampaignDAO,com.thesearchagency.GTCampaignTargetDAO); nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'GTCampaignDAO' defined in URL [jar:file:/usr/local/tsa/pointRadiiMigration/migratorScript/migrator-0.0.1-SNAPSHOT-jar-with-dependencies.jar!/com/thesearchagency/GTCampaignDAO.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.thesearchagency.GTCampaignDAO]: Constructor threw exception; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:256) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:998) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380) at org.springframework.context.support.ClassPathXmlApplicationContext.(ClassPathXmlApplicationContext.java:139) at org.springframework.context.support.ClassPathXmlApplicationContext.(ClassPathXmlApplicationContext.java:83) at com.thesearchagency.GTCampaignManager.main(GTCampaignManager.java:42) Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire method: public void com.thesearchagency.GTCampaignManager.setDAO(com.thesearchagency.GTCampaignDAO,com.thesearchagency.GTCampaignTargetDAO); nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'GTCampaignDAO' defined in URL [jar:file:/usr/local/tsa/pointRadiiMigration/migratorScript/migrator-0.0.1-SNAPSHOT-jar-with-dependencies.jar!/com/thesearchagency/GTCampaignDAO.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.thesearchagency.GTCampaignDAO]: Constructor threw exception; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:543) at org.springframework.beans.factory.annotation.InjectionMetadata.injectMethods(InjectionMetadata.java:117) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:253) ... 16 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'GTCampaignDAO' defined in URL [jar:file:/usr/local/tsa/pointRadiiMigration/migratorScript/migrator-0.0.1-SNAPSHOT-jar-with-dependencies.jar!/com/thesearchagency/GTCampaignDAO.class]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.thesearchagency.GTCampaignDAO]: Constructor threw exception; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:254) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:283) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:671) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:610) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:499) ... 18 more Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [com.thesearchagency.GTCampaignDAO]: Constructor threw exception; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:248) ... 30 more Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:458) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:466) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:474) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:479) at com.thesearchagency.GTCampaignDAO.getGlobalPointRadiusMultiplier(GTCampaignDAO.java:375) at com.thesearchagency.GTCampaignDAO.(GTCampaignDAO.java:38) 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:494) at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:100) ... 32 more Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure Last packet sent to the server was 0 ms ago. at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103) at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:718) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:140) 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.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79) ... 44 more Caused by: java.net.ConnectException: Connection timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:520) at java.net.Socket.connect(Socket.java:470) at java.net.Socket.(Socket.java:367) at java.net.Socket.(Socket.java:209) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:280) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026) ... 55 more root@yell1-xml1:/usr/local/tsa/pointRadiiMigration/migratorScript#