Index: src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java =================================================================== diff -u -rcf22aacb2ff06b9fa87e331263212774cda14dc9 -r09fdf9246f391c0159a92c4ab71065d853add128 --- src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java (.../SessionDAOImpl.java) (revision cf22aacb2ff06b9fa87e331263212774cda14dc9) +++ src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java (.../SessionDAOImpl.java) (revision 09fdf9246f391c0159a92c4ab71065d853add128) @@ -2574,10 +2574,7 @@ } @Override - public List> getSessionSiteList ( User user , String userAccessSites, Integer userId ) { - String delete = "DELETE FROM SESSION_BULK_EDIT_NEW WHERE USER_ID= "+userId; - jdbcTemplate.update(delete); - + public List> getSessionSiteList ( User user , String userAccessSites ) { if ( user.getRoleId ( ) == ROLE.ADMIN.getNumVal ( ) || user.getRoleId ( ) == ROLE.XO.getNumVal ( ) ) { return jdbcTemplate.queryForList ( "SELECT " + "DISTINCT(SITE.SITE_ID) AS \"siteId\", " + "SITE.SITE_NAME AS \"siteName\" " + "FROM " + "SITE, " + "SESSION_SITE SS " + "WHERE "