root@yell1-xml1:/usr/local/tsa/proximityTargetEditor/proximity-target-editor-1.0.0-SNAPSHOT# cat /usr/local/tsa/proximityTargetEditor/1158_3.log Java HotSpot(TM) 64-Bit Server VM warning: Can't detect initial thread stack location - find_vma failed [16 Jul 2014 17:52:17,374-ClassPathXmlApplicationContext:INFO:pool-1-thread-1] Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@693a317a: startup date [Wed Jul 16 17:52:17 BST 2014]; root of context hierarchy [16 Jul 2014 17:52:17,471-XmlBeanDefinitionReader:INFO:pool-1-thread-1] Loading XML bean definitions from class path resource [dao-beans.xml] [16 Jul 2014 17:52:18,114-DefaultListableBeanFactory:INFO:pool-1-thread-1] Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@15af33d6: defining beans [searchEngineUserDAO,gceCampaignDAO,gceCampaignProximityTargetDAO,gceTargetDAO]; root of factory hierarchy [16 Jul 2014 17:52:18,262-Version:INFO:pool-1-thread-1] Hibernate Annotations 3.2.1.GA [16 Jul 2014 17:52:18,274-Environment:INFO:pool-1-thread-1] Hibernate 3.2.4 [16 Jul 2014 17:52:18,277-Environment:INFO:pool-1-thread-1] hibernate.properties not found [16 Jul 2014 17:52:18,278-Environment:INFO:pool-1-thread-1] Bytecode provider name : cglib [16 Jul 2014 17:52:18,281-Environment:INFO:pool-1-thread-1] using JDK 1.4 java.sql.Timestamp handling [16 Jul 2014 17:52:18,351-Configuration:INFO:pool-1-thread-1] configuring from resource: hibernate-developer-content_editor_google.cfg.xml [16 Jul 2014 17:52:18,351-Configuration:INFO:pool-1-thread-1] Configuration resource: hibernate-developer-content_editor_google.cfg.xml [16 Jul 2014 17:52:18,437-Configuration:INFO:pool-1-thread-1] Configured SessionFactory: null [16 Jul 2014 17:52:18,542-AnnotationBinder:INFO:pool-1-thread-1] Binding entity from annotated class: com.thesearchagency.tools.persistence.google.entities.GceCampaign [16 Jul 2014 17:52:18,577-EntityBinder:INFO:pool-1-thread-1] Bind entity com.thesearchagency.tools.persistence.google.entities.GceCampaign on table gce_campaign [16 Jul 2014 17:52:18,700-AnnotationBinder:INFO:pool-1-thread-1] Binding entity from annotated class: com.thesearchagency.tools.persistence.google.entities.GceCampaignProximityTargetMap [16 Jul 2014 17:52:18,701-EntityBinder:INFO:pool-1-thread-1] Bind entity com.thesearchagency.tools.persistence.google.entities.GceCampaignProximityTargetMap on table gce_campaignProximityTargetMap [16 Jul 2014 17:52:18,705-AnnotationBinder:INFO:pool-1-thread-1] Binding entity from annotated class: com.thesearchagency.tools.persistence.google.entities.GceTarget [16 Jul 2014 17:52:18,706-EntityBinder:INFO:pool-1-thread-1] Bind entity com.thesearchagency.tools.persistence.google.entities.GceTarget on table gce_target [16 Jul 2014 17:52:18,816-DriverManagerConnectionProvider:INFO:pool-1-thread-1] Using Hibernate built-in connection pool (not for production use!) [16 Jul 2014 17:52:18,816-DriverManagerConnectionProvider:INFO:pool-1-thread-1] Hibernate connection pool size: 20 [16 Jul 2014 17:52:18,816-DriverManagerConnectionProvider:INFO:pool-1-thread-1] autocommit mode: false [16 Jul 2014 17:52:18,822-DriverManagerConnectionProvider:INFO:pool-1-thread-1] using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://acctdb-01-write:3306/content_editor_google [16 Jul 2014 17:52:18,822-DriverManagerConnectionProvider:INFO:pool-1-thread-1] connection properties: {user=spike, password=****} [16 Jul 2014 17:52:19,001-SettingsFactory:INFO:pool-1-thread-1] RDBMS: MySQL, version: 5.1.68-rel14.5 [16 Jul 2014 17:52:19,001-SettingsFactory:INFO:pool-1-thread-1] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ ) [16 Jul 2014 17:52:19,020-Dialect:INFO:pool-1-thread-1] Using dialect: org.hibernate.dialect.MySQLDialect [16 Jul 2014 17:52:19,024-TransactionFactoryFactory:INFO:pool-1-thread-1] Using default transaction strategy (direct JDBC transactions) [16 Jul 2014 17:52:19,026-TransactionManagerLookupFactory:INFO:pool-1-thread-1] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended) [16 Jul 2014 17:52:19,026-SettingsFactory:INFO:pool-1-thread-1] Automatic flush during beforeCompletion(): disabled [16 Jul 2014 17:52:19,026-SettingsFactory:INFO:pool-1-thread-1] Automatic session close at end of transaction: disabled [16 Jul 2014 17:52:19,026-SettingsFactory:INFO:pool-1-thread-1] JDBC batch size: 15 [16 Jul 2014 17:52:19,026-SettingsFactory:INFO:pool-1-thread-1] JDBC batch updates for versioned data: disabled [16 Jul 2014 17:52:19,027-SettingsFactory:INFO:pool-1-thread-1] Scrollable result sets: enabled [16 Jul 2014 17:52:19,027-SettingsFactory:INFO:pool-1-thread-1] JDBC3 getGeneratedKeys(): enabled [16 Jul 2014 17:52:19,027-SettingsFactory:INFO:pool-1-thread-1] Connection release mode: auto [16 Jul 2014 17:52:19,028-SettingsFactory:INFO:pool-1-thread-1] Maximum outer join fetch depth: 2 [16 Jul 2014 17:52:19,028-SettingsFactory:INFO:pool-1-thread-1] Default batch fetch size: 1 [16 Jul 2014 17:52:19,028-SettingsFactory:INFO:pool-1-thread-1] Generate SQL with comments: disabled [16 Jul 2014 17:52:19,028-SettingsFactory:INFO:pool-1-thread-1] Order SQL updates by primary key: disabled [16 Jul 2014 17:52:19,028-SettingsFactory:INFO:pool-1-thread-1] Order SQL inserts for batching: disabled [16 Jul 2014 17:52:19,028-SettingsFactory:INFO:pool-1-thread-1] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory [16 Jul 2014 17:52:19,030-ASTQueryTranslatorFactory:INFO:pool-1-thread-1] Using ASTQueryTranslatorFactory [16 Jul 2014 17:52:19,030-SettingsFactory:INFO:pool-1-thread-1] Query language substitutions: {} [16 Jul 2014 17:52:19,030-SettingsFactory:INFO:pool-1-thread-1] JPA-QL strict compliance: disabled [16 Jul 2014 17:52:19,030-SettingsFactory:INFO:pool-1-thread-1] Second-level cache: enabled [16 Jul 2014 17:52:19,030-SettingsFactory:INFO:pool-1-thread-1] Query cache: disabled [16 Jul 2014 17:52:19,031-SettingsFactory:INFO:pool-1-thread-1] Cache provider: org.hibernate.cache.NoCacheProvider [16 Jul 2014 17:52:19,031-SettingsFactory:INFO:pool-1-thread-1] Optimize cache for minimal puts: disabled [16 Jul 2014 17:52:19,031-SettingsFactory:INFO:pool-1-thread-1] Structured second-level cache entries: disabled [16 Jul 2014 17:52:19,035-SettingsFactory:INFO:pool-1-thread-1] Echoing all SQL to stdout [16 Jul 2014 17:52:19,035-SettingsFactory:INFO:pool-1-thread-1] Statistics: disabled [16 Jul 2014 17:52:19,035-SettingsFactory:INFO:pool-1-thread-1] Deleted entity synthetic identifier rollback: disabled [16 Jul 2014 17:52:19,035-SettingsFactory:INFO:pool-1-thread-1] Default entity-mode: pojo [16 Jul 2014 17:52:19,035-SettingsFactory:INFO:pool-1-thread-1] Named query checking : enabled [16 Jul 2014 17:52:19,058-SessionFactoryImpl:INFO:pool-1-thread-1] building session factory [16 Jul 2014 17:52:19,556-SessionFactoryObjectFactory:INFO:pool-1-thread-1] Not binding factory to JNDI, no JNDI name configured Hibernate: select gcecampaig0_.id as id0_, gcecampaig0_.name as name0_, gcecampaig0_.searchEngineIdentifier as searchEn3_0_, gcecampaig0_.searchEngineUserID as searchEn4_0_, gcecampaig0_.budgetAmount as budgetAm5_0_, gcecampaig0_.budgetPeriod as budgetPe6_0_, gcecampaig0_.budgetSearchEngineIdentifier as budgetSe7_0_, gcecampaig0_.contentTargeting as contentT8_0_, gcecampaig0_.startDay as startDay0_, gcecampaig0_.endDay as endDay0_, gcecampaig0_.status as status0_ from content_editor_google.gce_campaign gcecampaig0_ where (gcecampaig0_.name like '%\_1158\_%GT') and gcecampaig0_.status<>'Deleted' and (gcecampaig0_.searchEngineIdentifier is not null) [16 Jul 2014 17:52:19,856-Configuration:INFO:pool-1-thread-1] configuring from resource: hibernate-developer-tsacommon.cfg.xml [16 Jul 2014 17:52:19,857-Configuration:INFO:pool-1-thread-1] Configuration resource: hibernate-developer-tsacommon.cfg.xml [16 Jul 2014 17:52:19,864-Configuration:INFO:pool-1-thread-1] Configured SessionFactory: null [16 Jul 2014 17:52:19,865-AnnotationBinder:INFO:pool-1-thread-1] Binding entity from annotated class: com.thesearchagency.tools.persistence.entities.SearchEngineUser [16 Jul 2014 17:52:19,865-EntityBinder:INFO:pool-1-thread-1] Bind entity com.thesearchagency.tools.persistence.entities.SearchEngineUser on table searchEngineUsers [16 Jul 2014 17:52:19,876-DriverManagerConnectionProvider:INFO:pool-1-thread-1] Using Hibernate built-in connection pool (not for production use!) [16 Jul 2014 17:52:19,876-DriverManagerConnectionProvider:INFO:pool-1-thread-1] Hibernate connection pool size: 20 [16 Jul 2014 17:52:19,876-DriverManagerConnectionProvider:INFO:pool-1-thread-1] autocommit mode: false [16 Jul 2014 17:52:19,876-DriverManagerConnectionProvider:INFO:pool-1-thread-1] using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://acctdb-01-write:3306/tsacommon [16 Jul 2014 17:52:19,876-DriverManagerConnectionProvider:INFO:pool-1-thread-1] connection properties: {user=spike, password=****} [16 Jul 2014 17:52:19,900-SettingsFactory:INFO:pool-1-thread-1] RDBMS: MySQL, version: 5.1.68-rel14.5 [16 Jul 2014 17:52:19,900-SettingsFactory:INFO:pool-1-thread-1] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ ) [16 Jul 2014 17:52:19,900-Dialect:INFO:pool-1-thread-1] Using dialect: org.hibernate.dialect.MySQLDialect [16 Jul 2014 17:52:19,901-TransactionFactoryFactory:INFO:pool-1-thread-1] Using default transaction strategy (direct JDBC transactions) [16 Jul 2014 17:52:19,901-TransactionManagerLookupFactory:INFO:pool-1-thread-1] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended) [16 Jul 2014 17:52:19,901-SettingsFactory:INFO:pool-1-thread-1] Automatic flush during beforeCompletion(): disabled [16 Jul 2014 17:52:19,901-SettingsFactory:INFO:pool-1-thread-1] Automatic session close at end of transaction: disabled [16 Jul 2014 17:52:19,901-SettingsFactory:INFO:pool-1-thread-1] JDBC batch size: 15 [16 Jul 2014 17:52:19,901-SettingsFactory:INFO:pool-1-thread-1] JDBC batch updates for versioned data: disabled [16 Jul 2014 17:52:19,901-SettingsFactory:INFO:pool-1-thread-1] Scrollable result sets: enabled [16 Jul 2014 17:52:19,901-SettingsFactory:INFO:pool-1-thread-1] JDBC3 getGeneratedKeys(): enabled [16 Jul 2014 17:52:19,901-SettingsFactory:INFO:pool-1-thread-1] Connection release mode: auto [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] Maximum outer join fetch depth: 2 [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] Default batch fetch size: 1 [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] Generate SQL with comments: disabled [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] Order SQL updates by primary key: disabled [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] Order SQL inserts for batching: disabled [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory [16 Jul 2014 17:52:19,902-ASTQueryTranslatorFactory:INFO:pool-1-thread-1] Using ASTQueryTranslatorFactory [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] Query language substitutions: {} [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] JPA-QL strict compliance: disabled [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] Second-level cache: enabled [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] Query cache: disabled [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] Cache provider: org.hibernate.cache.NoCacheProvider [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] Optimize cache for minimal puts: disabled [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] Structured second-level cache entries: disabled [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] Echoing all SQL to stdout [16 Jul 2014 17:52:19,902-SettingsFactory:INFO:pool-1-thread-1] Statistics: disabled [16 Jul 2014 17:52:19,903-SettingsFactory:INFO:pool-1-thread-1] Deleted entity synthetic identifier rollback: disabled [16 Jul 2014 17:52:19,903-SettingsFactory:INFO:pool-1-thread-1] Default entity-mode: pojo [16 Jul 2014 17:52:19,903-SettingsFactory:INFO:pool-1-thread-1] Named query checking : enabled [16 Jul 2014 17:52:19,907-SessionFactoryImpl:INFO:pool-1-thread-1] building session factory [16 Jul 2014 17:52:19,938-SessionFactoryObjectFactory:INFO:pool-1-thread-1] Not binding factory to JNDI, no JNDI name configured Hibernate: select searchengi0_.id as id6_0_, searchengi0_.description as descript2_6_0_, searchengi0_.searchEngineIdentifier as searchEn3_6_0_, searchengi0_.password as password6_0_, searchengi0_.accountID as accountID6_0_, searchengi0_.distributionID as distribu6_6_0_, searchengi0_.username as username6_0_, searchengi0_.enabled as enabled6_0_, searchengi0_.inTsaMcc as inTsaMcc6_0_, searchengi0_.apiKey as apiKey6_0_, searchengi0_.managerUsernames as manager11_6_0_, searchengi0_.managerIDs as managerIDs6_0_, searchengi0_.lastChecked as lastChe13_6_0_, searchengi0_.lastInMcc as lastInMcc6_0_ from tsacommon.searchEngineUsers searchengi0_ where searchengi0_.id=? Hibernate: select searchengi0_.id as id6_0_, searchengi0_.description as descript2_6_0_, searchengi0_.searchEngineIdentifier as searchEn3_6_0_, searchengi0_.password as password6_0_, searchengi0_.accountID as accountID6_0_, searchengi0_.distributionID as distribu6_6_0_, searchengi0_.username as username6_0_, searchengi0_.enabled as enabled6_0_, searchengi0_.inTsaMcc as inTsaMcc6_0_, searchengi0_.apiKey as apiKey6_0_, searchengi0_.managerUsernames as manager11_6_0_, searchengi0_.managerIDs as managerIDs6_0_, searchengi0_.lastChecked as lastChe13_6_0_, searchengi0_.lastInMcc as lastInMcc6_0_ from tsacommon.searchEngineUsers searchengi0_ where searchengi0_.id=? Hibernate: select searchengi0_.id as id6_0_, searchengi0_.description as descript2_6_0_, searchengi0_.searchEngineIdentifier as searchEn3_6_0_, searchengi0_.password as password6_0_, searchengi0_.accountID as accountID6_0_, searchengi0_.distributionID as distribu6_6_0_, searchengi0_.username as username6_0_, searchengi0_.enabled as enabled6_0_, searchengi0_.inTsaMcc as inTsaMcc6_0_, searchengi0_.apiKey as apiKey6_0_, searchengi0_.managerUsernames as manager11_6_0_, searchengi0_.managerIDs as managerIDs6_0_, searchengi0_.lastChecked as lastChe13_6_0_, searchengi0_.lastInMcc as lastInMcc6_0_ from tsacommon.searchEngineUsers searchengi0_ where searchengi0_.id=? Hibernate: select searchengi0_.id as id6_0_, searchengi0_.description as descript2_6_0_, searchengi0_.searchEngineIdentifier as searchEn3_6_0_, searchengi0_.password as password6_0_, searchengi0_.accountID as accountID6_0_, searchengi0_.distributionID as distribu6_6_0_, searchengi0_.username as username6_0_, searchengi0_.enabled as enabled6_0_, searchengi0_.inTsaMcc as inTsaMcc6_0_, searchengi0_.apiKey as apiKey6_0_, searchengi0_.managerUsernames as manager11_6_0_, searchengi0_.managerIDs as managerIDs6_0_, searchengi0_.lastChecked as lastChe13_6_0_, searchengi0_.lastInMcc as lastInMcc6_0_ from tsacommon.searchEngineUsers searchengi0_ where searchengi0_.id=? Hibernate: select searchengi0_.id as id6_0_, searchengi0_.description as descript2_6_0_, searchengi0_.searchEngineIdentifier as searchEn3_6_0_, searchengi0_.password as password6_0_, searchengi0_.accountID as accountID6_0_, searchengi0_.distributionID as distribu6_6_0_, searchengi0_.username as username6_0_, searchengi0_.enabled as enabled6_0_, searchengi0_.inTsaMcc as inTsaMcc6_0_, searchengi0_.apiKey as apiKey6_0_, searchengi0_.managerUsernames as manager11_6_0_, searchengi0_.managerIDs as managerIDs6_0_, searchengi0_.lastChecked as lastChe13_6_0_, searchengi0_.lastInMcc as lastInMcc6_0_ from tsacommon.searchEngineUsers searchengi0_ where searchengi0_.id=? Hibernate: select gcecampaig0_.id as id0_, gcecampaig0_.name as name0_, gcecampaig0_.searchEngineIdentifier as searchEn3_0_, gcecampaig0_.searchEngineUserID as searchEn4_0_, gcecampaig0_.budgetAmount as budgetAm5_0_, gcecampaig0_.budgetPeriod as budgetPe6_0_, gcecampaig0_.budgetSearchEngineIdentifier as budgetSe7_0_, gcecampaig0_.contentTargeting as contentT8_0_, gcecampaig0_.startDay as startDay0_, gcecampaig0_.endDay as endDay0_, gcecampaig0_.status as status0_ from content_editor_google.gce_campaign gcecampaig0_ where gcecampaig0_.searchEngineUserID=84888 and gcecampaig0_.status<>'Deleted' and (gcecampaig0_.name like '%GT') and (gcecampaig0_.searchEngineIdentifier is not null) Hibernate: select gcecampaig0_.id as id0_, gcecampaig0_.name as name0_, gcecampaig0_.searchEngineIdentifier as searchEn3_0_, gcecampaig0_.searchEngineUserID as searchEn4_0_, gcecampaig0_.budgetAmount as budgetAm5_0_, gcecampaig0_.budgetPeriod as budgetPe6_0_, gcecampaig0_.budgetSearchEngineIdentifier as budgetSe7_0_, gcecampaig0_.contentTargeting as contentT8_0_, gcecampaig0_.startDay as startDay0_, gcecampaig0_.endDay as endDay0_, gcecampaig0_.status as status0_ from content_editor_google.gce_campaign gcecampaig0_ where gcecampaig0_.searchEngineUserID=84907 and gcecampaig0_.status<>'Deleted' and (gcecampaig0_.name like '%GT') and (gcecampaig0_.searchEngineIdentifier is not null) [16 Jul 2014 17:52:20,072-ClassPathXmlApplicationContext:INFO:pool-2-thread-1] Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@39abdac9: startup date [Wed Jul 16 17:52:20 BST 2014]; root of context hierarchy [16 Jul 2014 17:52:20,072-XmlBeanDefinitionReader:INFO:pool-2-thread-1] Loading XML bean definitions from class path resource [dao-beans.xml] Hibernate: select gcecampaig0_.id as id0_, gcecampaig0_.name as name0_, gcecampaig0_.searchEngineIdentifier as searchEn3_0_, gcecampaig0_.searchEngineUserID as searchEn4_0_, gcecampaig0_.budgetAmount as budgetAm5_0_, gcecampaig0_.budgetPeriod as budgetPe6_0_, gcecampaig0_.budgetSearchEngineIdentifier as budgetSe7_0_, gcecampaig0_.contentTargeting as contentT8_0_, gcecampaig0_.startDay as startDay0_, gcecampaig0_.endDay as endDay0_, gcecampaig0_.status as status0_ from content_editor_google.gce_campaign gcecampaig0_ where gcecampaig0_.searchEngineUserID=85270 and gcecampaig0_.status<>'Deleted' and (gcecampaig0_.name like '%GT') and (gcecampaig0_.searchEngineIdentifier is not null) Hibernate: select gcecampaig0_.id as id0_, gcecampaig0_.name as name0_, gcecampaig0_.searchEngineIdentifier as searchEn3_0_, gcecampaig0_.searchEngineUserID as searchEn4_0_, gcecampaig0_.budgetAmount as budgetAm5_0_, gcecampaig0_.budgetPeriod as budgetPe6_0_, gcecampaig0_.budgetSearchEngineIdentifier as budgetSe7_0_, gcecampaig0_.contentTargeting as contentT8_0_, gcecampaig0_.startDay as startDay0_, gcecampaig0_.endDay as endDay0_, gcecampaig0_.status as status0_ from content_editor_google.gce_campaign gcecampaig0_ where gcecampaig0_.searchEngineUserID=85264 and gcecampaig0_.status<>'Deleted' and (gcecampaig0_.name like '%GT') and (gcecampaig0_.searchEngineIdentifier is not null) Hibernate: select gcecampaig0_.id as id0_, gcecampaig0_.name as name0_, gcecampaig0_.searchEngineIdentifier as searchEn3_0_, gcecampaig0_.searchEngineUserID as searchEn4_0_, gcecampaig0_.budgetAmount as budgetAm5_0_, gcecampaig0_.budgetPeriod as budgetPe6_0_, gcecampaig0_.budgetSearchEngineIdentifier as budgetSe7_0_, gcecampaig0_.contentTargeting as contentT8_0_, gcecampaig0_.startDay as startDay0_, gcecampaig0_.endDay as endDay0_, gcecampaig0_.status as status0_ from content_editor_google.gce_campaign gcecampaig0_ where gcecampaig0_.searchEngineUserID=85265 and gcecampaig0_.status<>'Deleted' and (gcecampaig0_.name like '%GT') and (gcecampaig0_.searchEngineIdentifier is not null) [16 Jul 2014 17:52:20,277-DefaultListableBeanFactory:INFO:pool-2-thread-1] Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@12746ad0: defining beans [searchEngineUserDAO,gceCampaignDAO,gceCampaignProximityTargetDAO,gceTargetDAO]; root of factory hierarchy SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/local/tsa/proximityTargetEditor/proximity-target-editor-1.0.0-SNAPSHOT/lib/goole-adwords-api-1.26.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/local/tsa/proximityTargetEditor/proximity-target-editor-1.0.0-SNAPSHOT/lib/slf4j-log4j12-1.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. [16 Jul 2014 17:52:21,486-OAuthServiceComponent:INFO:pool-2-thread-1] [oauth] Cache initialized to size: 5 , Life Time: 2700 Seconds [16 Jul 2014 17:52:21,494-OAuthTokenCreator:INFO:pool-2-thread-1] [oauth] Getting new access token [16 Jul 2014 17:52:27,528-OAuthTokenCreator:INFO:pool-2-thread-1] [oauth] New access token generated [16 Jul 2014 17:52:27,532-OAuthServiceComponent:INFO:pool-2-thread-1] [oauth] Access token retrieved from cache, AccessToken:ya29.RAC1gAf85ibEPSMAAABer5q86x5Y1Eu5W3fbg0mFfaDyAc9hqzouL00lvuYIoDPPU2gmeBzB6HrYcDf5J3E, Expiration Date :2014-07-16 18:52:26,Expiry Seconds:3599, Cache Expiration Date:2014-07-16 18:37:27, Cache Expiry seconds:2700 [16 Jul 2014 17:52:27,545-OAuthServiceComponent:INFO:pool-2-thread-2] [oauth] Access token retrieved from cache, AccessToken:ya29.RAC1gAf85ibEPSMAAABer5q86x5Y1Eu5W3fbg0mFfaDyAc9hqzouL00lvuYIoDPPU2gmeBzB6HrYcDf5J3E, Expiration Date :2014-07-16 18:52:26,Expiry Seconds:3599, Cache Expiration Date:2014-07-16 18:37:27, Cache Expiry seconds:2700 [16 Jul 2014 17:52:27,546-OAuthServiceComponent:INFO:pool-2-thread-3] [oauth] Access token retrieved from cache, AccessToken:ya29.RAC1gAf85ibEPSMAAABer5q86x5Y1Eu5W3fbg0mFfaDyAc9hqzouL00lvuYIoDPPU2gmeBzB6HrYcDf5J3E, Expiration Date :2014-07-16 18:52:26,Expiry Seconds:3599, Cache Expiration Date:2014-07-16 18:37:27, Cache Expiry seconds:2700 [16 Jul 2014 17:52:29,231-requestInfoLogger:INFO:pool-2-thread-1] Request made: Service: "CampaignCriterionServiceInterfacePort" Method: "mutate" URL: "https://adwords.google.com/api/adwords/cm/v201402/CampaignCriterionService" [16 Jul 2014 17:52:29,249-soapXmlLogger:INFO:pool-2-thread-1] SOAP Request: 7523557281 ojCnjZaM6RD1h0yt_DOJZg Hibu SMS Test - Session Pool (AwApi-Java, AdWords-Axis/1.26.0, Common-Java/1.26.0, Axis/1.4, Java/1.5.0_14, maven) false false ADD 168684629 51437090 -408079 KILOMETERS 1.0 0.5 ADD 168684869 51437090 -408079 KILOMETERS 1.0 0.5 [16 Jul 2014 17:52:29,249-soapXmlLogger:INFO:pool-2-thread-1] SOAP Response: 0004fe52597c95a80a8068d83f009871 CampaignCriterionService mutate 0 180 CampaignCriterionReturnValue 168684629 false 74557556789 PROXIMITY Proximity 51437090 -408079 KILOMETERS 1.0 0.5 CampaignCriterion 168684869 false 74557556909 PROXIMITY Proximity 51437090 -408079 KILOMETERS 1.0 0.5 CampaignCriterion Hibernate: select gcetarget0_.id as id2_, gcetarget0_.description as descript2_2_, gcetarget0_.targetType as targetType2_, gcetarget0_.criterionID as criterio4_2_, gcetarget0_.code as code2_ from content_editor_google.gce_target gcetarget0_ where gcetarget0_.code='51437090,-408079' [16 Jul 2014 17:52:29,260-GoogleContentEditorProximityService:INFO:pool-2-thread-1] Mapping campaignId: 1007465 targetId: 2837 latitude: 51437090 longitude: -408079 radius: 2.0 Hibernate: select gcecampaig0_.campaignID as campaignID1_, gcecampaig0_.targetID as targetID1_, gcecampaig0_.criterionID as criterio3_1_, gcecampaig0_.latitudeInMicroDegrees as latitude4_1_, gcecampaig0_.longitudeInMicroDegrees as longitud5_1_, gcecampaig0_.radius as radius1_, gcecampaig0_.radiusUnits as radiusUn7_1_ from content_editor_google.gce_campaignProximityTargetMap gcecampaig0_ where gcecampaig0_.campaignID=1007465 and gcecampaig0_.targetID=2837 [16 Jul 2014 17:52:29,287-requestInfoLogger:INFO:pool-2-thread-2] Request made: Service: "CampaignCriterionServiceInterfacePort" Method: "mutate" URL: "https://adwords.google.com/api/adwords/cm/v201402/CampaignCriterionService" [16 Jul 2014 17:52:29,294-soapXmlLogger:INFO:pool-2-thread-2] SOAP Request: 5614933175 ojCnjZaM6RD1h0yt_DOJZg Hibu SMS Test - Session Pool (AwApi-Java, AdWords-Axis/1.26.0, Common-Java/1.26.0, Axis/1.4, Java/1.5.0_14, maven) false false ADD 150568886 51437090 -408079 KILOMETERS 1.0 0.5 ADD 150569126 51437090 -408079 KILOMETERS 1.0 0.5 [16 Jul 2014 17:52:29,294-soapXmlLogger:INFO:pool-2-thread-2] SOAP Response: 0004fe52597c91c00a8059c65000ba2e CampaignCriterionService mutate 0 255 CampaignCriterionReturnValue 150568886 false 69060350606 PROXIMITY Proximity 51437090 -408079 KILOMETERS 1.0 0.5 CampaignCriterion 150569126 false 69060350726 PROXIMITY Proximity 51437090 -408079 KILOMETERS 1.0 0.5 CampaignCriterion [16 Jul 2014 17:52:29,329-GoogleContentEditorProximityService:INFO:pool-2-thread-1] Mapping campaignId: 1007467 targetId: 2837 latitude: 51437090 longitude: -408079 radius: 2.0 Hibernate: select gcecampaig0_.campaignID as campaignID1_, gcecampaig0_.targetID as targetID1_, gcecampaig0_.criterionID as criterio3_1_, gcecampaig0_.latitudeInMicroDegrees as latitude4_1_, gcecampaig0_.longitudeInMicroDegrees as longitud5_1_, gcecampaig0_.radius as radius1_, gcecampaig0_.radiusUnits as radiusUn7_1_ from content_editor_google.gce_campaignProximityTargetMap gcecampaig0_ where gcecampaig0_.campaignID=1007467 and gcecampaig0_.targetID=2837 [16 Jul 2014 17:52:29,335-AddEditableBehaviour:INFO:pool-2-thread-1] Number of proximities added: 2 [16 Jul 2014 17:52:29,372-requestInfoLogger:INFO:pool-2-thread-3] Request made: Service: "CampaignCriterionServiceInterfacePort" Method: "mutate" URL: "https://adwords.google.com/api/adwords/cm/v201402/CampaignCriterionService" [16 Jul 2014 17:52:29,378-soapXmlLogger:INFO:pool-2-thread-3] SOAP Request: 5825683428 ojCnjZaM6RD1h0yt_DOJZg Hibu SMS Test - Session Pool (AwApi-Java, AdWords-Axis/1.26.0, Common-Java/1.26.0, Axis/1.4, Java/1.5.0_14, maven) false false ADD 216160811 51437090 -408079 KILOMETERS 1.0 0.5 [16 Jul 2014 17:52:29,378-soapXmlLogger:INFO:pool-2-thread-3] SOAP Response: 0004fe52597d1e600a804984400078ee CampaignCriterionService mutate 0 289 CampaignCriterionReturnValue 216160811 false 103565627531 PROXIMITY Proximity 51437090 -408079 KILOMETERS 1.0 0.5 CampaignCriterion Hibernate: select gcetarget0_.id as id2_, gcetarget0_.description as descript2_2_, gcetarget0_.targetType as targetType2_, gcetarget0_.criterionID as criterio4_2_, gcetarget0_.code as code2_ from content_editor_google.gce_target gcetarget0_ where gcetarget0_.code='51437090,-408079' [16 Jul 2014 17:52:29,381-GoogleContentEditorProximityService:INFO:pool-2-thread-3] Mapping campaignId: 1007976 targetId: 2837 latitude: 51437090 longitude: -408079 radius: 2.0 Hibernate: select gcecampaig0_.campaignID as campaignID1_, gcecampaig0_.targetID as targetID1_, gcecampaig0_.criterionID as criterio3_1_, gcecampaig0_.latitudeInMicroDegrees as latitude4_1_, gcecampaig0_.longitudeInMicroDegrees as longitud5_1_, gcecampaig0_.radius as radius1_, gcecampaig0_.radiusUnits as radiusUn7_1_ from content_editor_google.gce_campaignProximityTargetMap gcecampaig0_ where gcecampaig0_.campaignID=1007976 and gcecampaig0_.targetID=2837 [16 Jul 2014 17:52:29,387-AddEditableBehaviour:INFO:pool-2-thread-3] Number of proximities added: 1 Hibernate: select gcetarget0_.id as id2_, gcetarget0_.description as descript2_2_, gcetarget0_.targetType as targetType2_, gcetarget0_.criterionID as criterio4_2_, gcetarget0_.code as code2_ from content_editor_google.gce_target gcetarget0_ where gcetarget0_.code='51437090,-408079' [16 Jul 2014 17:52:29,670-GoogleContentEditorProximityService:INFO:pool-2-thread-2] Mapping campaignId: 1007495 targetId: 2837 latitude: 51437090 longitude: -408079 radius: 2.0 Hibernate: select gcecampaig0_.campaignID as campaignID1_, gcecampaig0_.targetID as targetID1_, gcecampaig0_.criterionID as criterio3_1_, gcecampaig0_.latitudeInMicroDegrees as latitude4_1_, gcecampaig0_.longitudeInMicroDegrees as longitud5_1_, gcecampaig0_.radius as radius1_, gcecampaig0_.radiusUnits as radiusUn7_1_ from content_editor_google.gce_campaignProximityTargetMap gcecampaig0_ where gcecampaig0_.campaignID=1007495 and gcecampaig0_.targetID=2837 [16 Jul 2014 17:52:29,676-GoogleContentEditorProximityService:INFO:pool-2-thread-2] Mapping campaignId: 1007497 targetId: 2837 latitude: 51437090 longitude: -408079 radius: 2.0 Hibernate: select gcecampaig0_.campaignID as campaignID1_, gcecampaig0_.targetID as targetID1_, gcecampaig0_.criterionID as criterio3_1_, gcecampaig0_.latitudeInMicroDegrees as latitude4_1_, gcecampaig0_.longitudeInMicroDegrees as longitud5_1_, gcecampaig0_.radius as radius1_, gcecampaig0_.radiusUnits as radiusUn7_1_ from content_editor_google.gce_campaignProximityTargetMap gcecampaig0_ where gcecampaig0_.campaignID=1007497 and gcecampaig0_.targetID=2837 [16 Jul 2014 17:52:29,691-AddEditableBehaviour:INFO:pool-2-thread-2] Number of proximities added: 2 [16 Jul 2014 17:52:29,944-requestInfoLogger:INFO:pool-2-thread-3] Request made: Service: "CampaignCriterionServiceInterfacePort" Method: "mutate" URL: "https://adwords.google.com/api/adwords/cm/v201402/CampaignCriterionService" [16 Jul 2014 17:52:29,949-soapXmlLogger:INFO:pool-2-thread-3] SOAP Request: 3656959530 ojCnjZaM6RD1h0yt_DOJZg Hibu SMS Test - Session Pool (AwApi-Java, AdWords-Axis/1.26.0, Common-Java/1.26.0, Axis/1.4, Java/1.5.0_14, maven) false false ADD 195582655 51437090 -408079 KILOMETERS 1.0 0.5 [16 Jul 2014 17:52:29,949-soapXmlLogger:INFO:pool-2-thread-3] SOAP Response: 0004fe525987ec000a8066575e004eeb CampaignCriterionService mutate 0 181 CampaignCriterionReturnValue 195582655 false 96229898935 PROXIMITY Proximity 51437090 -408079 KILOMETERS 1.0 0.5 CampaignCriterion Hibernate: select gcetarget0_.id as id2_, gcetarget0_.description as descript2_2_, gcetarget0_.targetType as targetType2_, gcetarget0_.criterionID as criterio4_2_, gcetarget0_.code as code2_ from content_editor_google.gce_target gcetarget0_ where gcetarget0_.code='51437090,-408079' [16 Jul 2014 17:52:29,953-GoogleContentEditorProximityService:INFO:pool-2-thread-3] Mapping campaignId: 1007966 targetId: 2837 latitude: 51437090 longitude: -408079 radius: 2.0 Hibernate: select gcecampaig0_.campaignID as campaignID1_, gcecampaig0_.targetID as targetID1_, gcecampaig0_.criterionID as criterio3_1_, gcecampaig0_.latitudeInMicroDegrees as latitude4_1_, gcecampaig0_.longitudeInMicroDegrees as longitud5_1_, gcecampaig0_.radius as radius1_, gcecampaig0_.radiusUnits as radiusUn7_1_ from content_editor_google.gce_campaignProximityTargetMap gcecampaig0_ where gcecampaig0_.campaignID=1007966 and gcecampaig0_.targetID=2837 [16 Jul 2014 17:52:29,959-AddEditableBehaviour:INFO:pool-2-thread-3] Number of proximities added: 1 [16 Jul 2014 17:52:30,094-requestInfoLogger:INFO:pool-2-thread-1] Request made: Service: "CampaignCriterionServiceInterfacePort" Method: "mutate" URL: "https://adwords.google.com/api/adwords/cm/v201402/CampaignCriterionService" [16 Jul 2014 17:52:30,099-soapXmlLogger:INFO:pool-2-thread-1] SOAP Request: 8883381877 ojCnjZaM6RD1h0yt_DOJZg Hibu SMS Test - Session Pool (AwApi-Java, AdWords-Axis/1.26.0, Common-Java/1.26.0, Axis/1.4, Java/1.5.0_14, maven) false false ADD 187873629 51437090 -408079 KILOMETERS 1.0 0.5 [16 Jul 2014 17:52:30,099-soapXmlLogger:INFO:pool-2-thread-1] SOAP Response: 0004fe52598884580a802943c20010bc CampaignCriterionService mutate 0 292 CampaignCriterionReturnValue 187873629 false 91007514549 PROXIMITY Proximity 51437090 -408079 KILOMETERS 1.0 0.5 CampaignCriterion Hibernate: select gcetarget0_.id as id2_, gcetarget0_.description as descript2_2_, gcetarget0_.targetType as targetType2_, gcetarget0_.criterionID as criterio4_2_, gcetarget0_.code as code2_ from content_editor_google.gce_target gcetarget0_ where gcetarget0_.code='51437090,-408079' [16 Jul 2014 17:52:30,103-GoogleContentEditorProximityService:INFO:pool-2-thread-1] Mapping campaignId: 1007964 targetId: 2837 latitude: 51437090 longitude: -408079 radius: 2.0 Hibernate: select gcecampaig0_.campaignID as campaignID1_, gcecampaig0_.targetID as targetID1_, gcecampaig0_.criterionID as criterio3_1_, gcecampaig0_.latitudeInMicroDegrees as latitude4_1_, gcecampaig0_.longitudeInMicroDegrees as longitud5_1_, gcecampaig0_.radius as radius1_, gcecampaig0_.radiusUnits as radiusUn7_1_ from content_editor_google.gce_campaignProximityTargetMap gcecampaig0_ where gcecampaig0_.campaignID=1007964 and gcecampaig0_.targetID=2837 [16 Jul 2014 17:52:30,108-AddEditableBehaviour:INFO:pool-2-thread-1] Number of proximities added: 1 [16 Jul 2014 17:52:30,109-ProximityTargetEditor:INFO:main] Elapsed Time: 12 seconds [16 Jul 2014 17:52:30,115-ProximityTargetEditor:INFO:ProximityTargetEditor Shutdown Hook] ProximityTargetEditor Stopped