ed=0 and externalCampaignJobTypeID in (1,2) order by id asc limit 1] 2012-10-25 22:18:50.525 (4) [pool-4-thread-2]: time=0.0020 2012-10-25 22:18:50.525 (4) [pool-4-thread-2]: Query executed in 0.002s 2012-10-25 22:18:50.525 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (1,2) order by id asc limit 1] 2012-10-25 22:18:50.526 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:50.526 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:50.526 (4) [pool-4-thread-2]: spike: SQL->[select t.id, t.description, t.maxJobSize from externalCampaignJobItem i join externalCampaignJobType t on (t.id = i.externalCampaignJobTypeID) where i.externalCampaignJobID is null and t.id in(1,2) and (unix_timestamp() - unix_timestamp(i.createTime)) > t.initialDelaySec order by i.id asc limit 1] 2012-10-25 22:18:50.527 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:50.527 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:50.527 (3) [pool-4-thread-2]: No new jobs to execute for type: [1,2] 2012-10-25 22:18:50.527 (4) [pool-4-thread-2]: Finished managing jobs. 2012-10-25 22:18:50.528 (4) [pool-4-thread-2]: Returning Object to Pool 2012-10-25 22:18:52.494 (4) [pool-4-thread-2]: Start managing jobs... 2012-10-25 22:18:52.494 (4) [pool-4-thread-2]: DataCache: Found key global-clients 2012-10-25 22:18:52.494 (4) [pool-4-thread-2]: Took Existing Object from Pool 2012-10-25 22:18:52.494 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2012-10-25 22:18:52.495 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:52.495 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:52.495 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-10-25 22:18:52.496 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (4) order by id asc limit 1] 2012-10-25 22:18:52.497 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:52.497 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:52.497 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (4) order by id asc limit 1] 2012-10-25 22:18:52.498 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:52.498 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:52.498 (4) [pool-4-thread-2]: spike: SQL->[select t.id, t.description, t.maxJobSize from externalCampaignJobItem i join externalCampaignJobType t on (t.id = i.externalCampaignJobTypeID) where i.externalCampaignJobID is null and t.id in(4) and (unix_timestamp() - unix_timestamp(i.createTime)) > t.initialDelaySec order by i.id asc limit 1] 2012-10-25 22:18:52.499 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:52.499 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:52.499 (3) [pool-4-thread-2]: No new jobs to execute for type: [4] 2012-10-25 22:18:52.499 (4) [pool-4-thread-2]: Finished managing jobs. 2012-10-25 22:18:52.499 (4) [pool-4-thread-2]: Returning Object to Pool 2012-10-25 22:18:54.494 (4) [pool-4-thread-2]: Start managing jobs... 2012-10-25 22:18:54.494 (4) [pool-4-thread-2]: DataCache: Found key global-clients 2012-10-25 22:18:54.494 (4) [pool-4-thread-2]: Took Existing Object from Pool 2012-10-25 22:18:54.494 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2012-10-25 22:18:54.495 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:54.496 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:54.496 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-10-25 22:18:54.496 (4) [pool-4-thread-2]: spike: SQL->[select id, externalCampaignJobTypeID, tryCount, isFailed, isFinished from externalCampaignJob where isFinished=0 and externalCampaignJobTypeID in (6) order by id asc limit 1] 2012-10-25 22:18:54.497 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:54.497 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:54.498 (3) [pool-4-thread-2]: Retrying job ID: 29 jobTypeID 6 tryCount: 2 isFailed: false isFinished: false 2012-10-25 22:18:54.498 (4) [pool-4-thread-2]: preparing SQL statement [update externalCampaignJob set trycount=?, isFailed=?, isFinished=? where id=?] 2012-10-25 22:18:54.501 (3) [pool-4-thread-2]: Executing job: ID: 29 jobTypeID 6 tryCount: 2 isFailed: false isFinished: false 2012-10-25 22:18:54.501 (4) [pool-4-thread-2]: no account, or instance for databaseInstance, skipping lookup... 2012-10-25 22:18:54.511 (4) [pool-4-thread-2]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-10-25 22:18:54.511 (4) [pool-4-thread-2]: Created new Object 2012-10-25 22:18:54.511 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2012-10-25 22:18:54.512 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:54.512 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:54.512 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-10-25 22:18:54.512 (4) [pool-4-thread-2]: preparing SQL statement [select c.id, c.externalCampaignParentID, c.gceCampaignID, c.searchEngineAccountID, c.accountID, c.enabled from externalCampaign c join externalCampaignJobItem j on (c.id = j.externalCampaignID) where j.externalCampaignJobTypeID =? and j.externalCampaignJobID = ? ] 2012-10-25 22:18:54.513 (3) [pool-4-thread-2]: 3 campaigns for job externalCampaignJob-6-29 2012-10-25 22:18:54.513 (4) [pool-4-thread-2]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where id = ?] 2012-10-25 22:18:54.514 (3) [pool-4-thread-2]: Using parent in job...[radprox1.5_GM->radprox1.5] 2012-10-25 22:18:54.514 (4) [pool-4-thread-2]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where id = ?] 2012-10-25 22:18:54.516 (3) [pool-4-thread-2]: Using parent in job...[radprox1.5_GT->radprox1.5] 2012-10-25 22:18:54.516 (4) [pool-4-thread-2]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where id = ?] 2012-10-25 22:18:54.517 (3) [pool-4-thread-2]: Using parent in job...[radprox1.5_MO->radprox1.5] 2012-10-25 22:18:54.517 (4) [pool-4-thread-2]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=6185) limit 1] 2012-10-25 22:18:54.518 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:54.519 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:54.519 (4) [pool-4-thread-2]: Record Loaded 2012-10-25 22:18:54.519 (3) [pool-4-thread-2]: -------- Updating account ProxTarradboost1.5test1 (6185) 2012-10-25 22:18:54.519 (3) [pool-4-thread-2]: Fetching data from SMB Callback Service for account ProxTarradboost1.5test1 2012-10-25 22:18:54.519 (3) [pool-4-thread-2]: Fetching account info for 6185 2012-10-25 22:18:54.519 (4) [pool-4-thread-2]: DataCache: Found key global-clients 2012-10-25 22:18:54.560 (2) [Finalizer]: CampaignTargetDAO calling close() in finalize: creator of DAO forgot to call close(). 2012-10-25 22:18:54.560 (4) [Finalizer]: Returning Object to Pool 2012-10-25 22:18:54.560 (4) [pool-4-thread-2]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-10-25 22:18:54.560 (4) [pool-4-thread-2]: Created new Object 2012-10-25 22:18:54.560 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2012-10-25 22:18:54.562 (4) [pool-4-thread-2]: time=0.0020 2012-10-25 22:18:54.562 (4) [pool-4-thread-2]: Query executed in 0.002s 2012-10-25 22:18:54.562 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-10-25 22:18:54.562 (4) [pool-4-thread-2]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=6185) limit 1] 2012-10-25 22:18:54.564 (4) [pool-4-thread-2]: time=0.0020 2012-10-25 22:18:54.565 (4) [pool-4-thread-2]: Query executed in 0.002s 2012-10-25 22:18:54.565 (4) [pool-4-thread-2]: Record Loaded 2012-10-25 22:18:54.571 (3) [pool-4-thread-2]: Queue worker session created. 2012-10-25 22:18:54.793 (4) [pool-4-thread-2]: Returning Object to Pool 2012-10-25 22:18:54.793 (4) [pool-4-thread-2]: no account, or instance for databaseInstance, skipping lookup... 2012-10-25 22:18:54.803 (4) [pool-4-thread-2]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-10-25 22:18:54.803 (4) [pool-4-thread-2]: Created new Object 2012-10-25 22:18:54.803 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2012-10-25 22:18:54.804 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:54.804 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:54.804 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-10-25 22:18:54.804 (4) [pool-4-thread-2]: DataCache: Found key global-clients 2012-10-25 22:18:54.804 (4) [pool-4-thread-2]: Took Existing Object from Pool 2012-10-25 22:18:54.804 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2012-10-25 22:18:54.805 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:54.805 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:54.805 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-10-25 22:18:54.805 (4) [pool-4-thread-2]: spike: SQL->[SELECT GET_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.ProxTarradboost1.5test1', 7200)] 2012-10-25 22:18:54.806 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:54.806 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:54.806 (4) [pool-4-thread-2]: spike: SQL->[select * from `tsacommon`.`accounts` where ((`description`="ProxTarradboost1.5test1")) limit 1] 2012-10-25 22:18:54.808 (4) [pool-4-thread-2]: time=0.0020 2012-10-25 22:18:54.808 (4) [pool-4-thread-2]: Query executed in 0.002s 2012-10-25 22:18:54.808 (4) [pool-4-thread-2]: Record Loaded 2012-10-25 22:18:54.850 (4) [pool-4-thread-2]: DataCache: Key acct-st-tracker 6185 expired. 2012-10-25 22:18:54.850 (4) [pool-4-thread-2]: no account, or instance for databaseInstance, skipping lookup... 2012-10-25 22:18:54.861 (4) [pool-4-thread-2]: opened [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-10-25 22:18:54.861 (4) [pool-4-thread-2]: spike: SQL->[select * from `tsacommon`.`accounts` where (`id`=6185) limit 1] 2012-10-25 22:18:54.862 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:54.862 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:54.863 (4) [pool-4-thread-2]: Record Loaded 2012-10-25 22:18:54.863 (4) [pool-4-thread-2]: DataCache: put key acct-st-tracker 6185 2012-10-25 22:18:54.863 (4) [pool-4-thread-2]: DataCache: Key acct-st-tracker-1 expired. 2012-10-25 22:18:54.863 (4) [pool-4-thread-2]: spike: SQL->[select * from `tsacommon`.`databaseInstances` where ((`name`="acct-st-tracker-1") and (`type`="mysql")) limit 1] 2012-10-25 22:18:54.864 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:54.864 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:54.864 (4) [pool-4-thread-2]: Record Loaded 2012-10-25 22:18:54.864 (4) [pool-4-thread-2]: DataCache: put key acct-st-tracker-1 2012-10-25 22:18:54.864 (4) [pool-4-thread-2]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-10-25 22:18:54.874 (4) [pool-4-thread-2]: opened [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-10-25 22:18:54.874 (4) [pool-4-thread-2]: Created new Object 2012-10-25 22:18:54.874 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2012-10-25 22:18:54.875 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:54.875 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:54.875 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1" 2012-10-25 22:18:54.875 (4) [pool-4-thread-2]: preparing SQL statement [select id from clients.externalCampaignParent where typeID = ? and accountID = ? and status != ?] 2012-10-25 22:18:54.876 (4) [pool-4-thread-2]: preparing SQL statement [select admaxNominalMonthlyBudgets.ID,admaxCampaignID,startDate,endDate,budget from `st-tracker`.admaxCampaigns join `st-tracker`.admaxNominalMonthlyBudgets on admaxCampaigns.ID=admaxNominalMonthlyBudgets.admaxCampaignID where accountID=? and startDate<=? and (endDate is null or endDate>=?)] 2012-10-25 22:18:54.878 (4) [pool-4-thread-2]: No budget changes 2012-10-25 22:18:54.878 (4) [pool-4-thread-2]: preparing SQL statement [select id, description, accountID, admaxCampaignID, status, typeID from clients.externalCampaignParent where accountID = ? and typeID=1] 2012-10-25 22:18:54.880 (1) [pool-4-thread-2]: Exception [Unhandled exception, failing request]:java.lang.NullPointerException at com.thesearchagency.admaxlistener.worker.RequestWorker.preProcessCampaigns(RequestWorker.java:718) at com.thesearchagency.admaxlistener.worker.RequestWorker.processRequest(RequestWorker.java:505) at com.thesearchagency.admaxlistener.worker.RequestWorker.call(RequestWorker.java:191) at com.thesearchagency.admaxlistener.task.ExternalCampaignTaskDeploy.processAccount(ExternalCampaignTaskDeploy.java:66) at com.thesearchagency.admaxlistener.task.ExternalCampaignTaskDeploy.executeJob(ExternalCampaignTaskDeploy.java:131) at com.thesearchagency.admaxlistener.task.ExternalCampaignTask.manageJobs(ExternalCampaignTask.java:427) at com.thesearchagency.admaxlistener.task.ExternalCampaignTask.run(ExternalCampaignTask.java:217) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:204) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) 2012-10-25 22:18:54.880 (4) [pool-4-thread-2]: DataCache: Found key global-clients 2012-10-25 22:18:54.892 (4) [pool-4-thread-2]: opened [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-10-25 22:18:54.892 (4) [pool-4-thread-2]: Created new Object 2012-10-25 22:18:54.892 (4) [pool-4-thread-2]: spike: SQL->[select @@version] 2012-10-25 22:18:54.893 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:54.893 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:54.893 (4) [pool-4-thread-2]: test query succeeded, returned "5.1.60-rel13.1-log" 2012-10-25 22:18:54.893 (2) [pool-4-thread-2]: No parent result for radprox1.5, using message result. 2012-10-25 22:18:54.893 (3) [pool-4-thread-2]: Updating deployment status to 'Failure' for campaignID: radprox1.5 2012-10-25 22:18:54.893 (4) [pool-4-thread-2]: preparing SQL statement [update clients.externalCampaignParentDeployStatus set status = ? where description = ?] 2012-10-25 22:18:54.895 (3) [pool-4-thread-2]: Finished UPDATE request for radprox1.5: FAILED 2012-10-25 22:18:54.895 (3) [pool-4-thread-2]: Finished UPDATE request, deploymentID (kw4TbWkD0RwulmtFQCuv), account ProxTarradboost1.5test1 2012-10-25 22:18:54.895 (3) [pool-4-thread-2]: Request removed from map for customerID ProxTarradboost1.5test1 2012-10-25 22:18:54.896 (4) [pool-4-thread-2]: spike: SQL->[SELECT RELEASE_LOCK('com.thesearchagency.admaxlistener.dao.TSACommonDAO.ProxTarradboost1.5test1')] 2012-10-25 22:18:54.897 (4) [pool-4-thread-2]: time=0.0010 2012-10-25 22:18:54.897 (4) [pool-4-thread-2]: Query executed in 0.001s 2012-10-25 22:18:54.897 (4) [pool-4-thread-2]: Released account lock: ProxTarradboost1.5test1 2012-10-25 22:18:54.897 (4) [pool-4-thread-2]: Returning Object to Pool 2012-10-25 22:18:54.897 (4) [pool-4-thread-2]: Returning Object to Pool 2012-10-25 22:18:54.897 (4) [pool-4-thread-2]: Returning Object to Pool 2012-10-25 22:18:54.897 (4) [pool-4-thread-2]: Returning Object to Pool 2012-10-25 22:18:54.897 (3) [pool-4-thread-2]: Queue worker close() called. 2012-10-25 22:18:54.904 (3) [pool-4-thread-2]: Queue worker tmp queue deleted. 2012-10-25 22:18:54.906 (3) [pool-4-thread-2]: Queue worker session closed. 2012-10-25 22:18:54.906 (1) [pool-4-thread-2]: Error while managing jobs: ID: 29 jobTypeID 6 tryCount: 2 isFailed: false isFinished: false account 6185 failed. 2012-10-25 22:18:54.906 (4) [pool-4-thread-2]: Returning Object to Pool 2012-10-25 22:19:04.458 (4) [Timer-13]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2012-10-25 22:19:20.511 (4) [ConnectionCloser]: 4 DatabasePools remaining : 6 pending closure 2012-10-25 22:19:46.480 (4) [Timer-0]: ContentEditorPropertiesRefresher: contenteditor.properties last modified 1337941320000 2012-10-25 22:19:50.516 (4) [ConnectionCloser]: 4 DatabasePools remaining : 6 pending closure 2012-10-25 22:20:04.461 (4) [Timer-13]: LicensingFileRefresher: licensing.properties last modified 1337940573000 2012-10-25 22:20:20.517 (4) [ConnectionCloser]: closing db conn 2012-10-25 22:20:20.518 (4) [ConnectionCloser]: closed [jdbc:mysql://acctdb-01-write:3307/st-tracker?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-10-25 22:20:20.519 (4) [ConnectionCloser]: closing db conn 2012-10-25 22:20:20.519 (4) [ConnectionCloser]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-10-25 22:20:20.519 (4) [ConnectionCloser]: closing db conn 2012-10-25 22:20:20.519 (4) [ConnectionCloser]: closed [jdbc:mysql://tsacommon-01-write/tsacommon?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-10-25 22:20:20.519 (4) [ConnectionCloser]: closing db conn 2012-10-25 22:20:20.520 (4) [ConnectionCloser]: closed [jdbc:mysql://acctdb-01-write:3307/content_editor_google?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-10-25 22:20:20.520 (4) [ConnectionCloser]: closing db conn 2012-10-25 22:20:20.520 (4) [ConnectionCloser]: closed [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false] 2012-10-25 22:20:20.520 (4) [ConnectionCloser]: closing db conn 2012-10-25 22:20:20.521 (4) [ConnectionCloser]: closed [jdbc:mysql://clients-01-write:3306/clients?useUnicode=true&characterEncoding=UTF8&zeroDateTimeBehavior=convertToNull&dontTrackOpenResources=true&jdbcCompliantTruncation=false]