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