Index: src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java =================================================================== diff -u -rffc132419658ed89bd2fafc31f354c0e66affe13 -r1d9ef851265e0bf03af4cf422928460d98ba0230 --- src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java (.../SessionDAOImpl.java) (revision ffc132419658ed89bd2fafc31f354c0e66affe13) +++ src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java (.../SessionDAOImpl.java) (revision 1d9ef851265e0bf03af4cf422928460d98ba0230) @@ -1628,9 +1628,9 @@ public Exception call ( ) throws Exception { try { jdbcTemplate.batchUpdate ( - "insert into SESSION_MARKET_POSTAL using select ?, ?, mz.MARKET_POSTAL, sum(mz.VEHICLE_COUNT) " - + "from VEHICLE_COUNT_MV mz where mz.MARKET_POSTAL in (select MARKET_POSTAL || '' from SITE_MARKET WHERE SITE_ID = ?) " - + "group by mz.MARKET_POSTAL" , + "insert into SESSION_MARKET_POSTAL using select ?, ?, mp.MARKET_POSTAL, mp.sum_vehicle_count " + + "from MARKET_POSTAL mp where mp.MARKET_POSTAL in (select MARKET_POSTAL || '' from SITE_MARKET WHERE SITE_ID = ?) " + , new BatchPreparedStatementSetter ( ) { @Override