Index: ssts-basedata/src/main/java/com/forgon/disinfectsystem/systemsetting/service/HttpOptionManagerSSTSImpl.java =================================================================== diff -u -r35338 -r35339 --- ssts-basedata/src/main/java/com/forgon/disinfectsystem/systemsetting/service/HttpOptionManagerSSTSImpl.java (.../HttpOptionManagerSSTSImpl.java) (revision 35338) +++ ssts-basedata/src/main/java/com/forgon/disinfectsystem/systemsetting/service/HttpOptionManagerSSTSImpl.java (.../HttpOptionManagerSSTSImpl.java) (revision 35339) @@ -547,7 +547,13 @@ String sql = String.format("select max(po.sequence) from %s po where po.optionListId = '%s'", HttpOption.class.getSimpleName(), HttpOption.SYSTEMSETTING_STERILIZATIONPURPOSE); - int maxOrder = objectDao.countBySql(sql); + int maxOrder = 0; + List list = objectDao.findByHql(sql); + if(CollectionUtils.isNotEmpty(list)){ + if(list.get(0) != null){ + maxOrder = (int) list.get(0); + } + } maxOrder += 1; httpOption.setSequence(maxOrder); }