Index: ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/service/JohnsonDataManagerImpl.java =================================================================== diff -u -r29640 -r29649 --- ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/service/JohnsonDataManagerImpl.java (.../JohnsonDataManagerImpl.java) (revision 29640) +++ ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/service/JohnsonDataManagerImpl.java (.../JohnsonDataManagerImpl.java) (revision 29649) @@ -400,7 +400,7 @@ * @return */ private boolean isExistData(String machineNumber, Long cycleCounter){ - String sql = String.format("select count(*) from %s where machineNumber='%s' and cycleCounter=%s ", + String sql = String.format("select count(*) from %s where machineNumber='%s' and totalCycleCounter=%s ", LowTempForJohnsonSterilizerRecord.class.getSimpleName(),machineNumber,cycleCounter); if(objectDao.countBySql(sql) > 0){ return true;