Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java =================================================================== diff -u -r22181 -r22185 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 22181) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 22185) @@ -845,7 +845,6 @@ }else if(dbConnection.isOracle()){ findSql = getTousseInstanceWithOutBasketByOracle(start,limit,orgUnitCode,departSearchSql,keyWordSearchSql); } - ResultSet rs = objectDao.executeSql(findSql); List tousseList = new ArrayList(); try { @@ -855,7 +854,7 @@ vo.setDepart(rs.getString("depart")); vo.setTousseName(rs.getString("tousseName")); vo.setBarcode(rs.getString("barcode")); - vo.setReviewTime(rs.getDate("reviewTime")); + vo.setReviewTime(rs.getTimestamp("reviewTime")); vo.setAmount(rs.getInt("amount")); tousseList.add(vo); }