Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/RecyclingApplicationManagerImpl.java =================================================================== diff -u -r17081 -r17095 --- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/RecyclingApplicationManagerImpl.java (.../RecyclingApplicationManagerImpl.java) (revision 17081) +++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/RecyclingApplicationManagerImpl.java (.../RecyclingApplicationManagerImpl.java) (revision 17095) @@ -3340,7 +3340,7 @@ */ private Map getConvertAppAmount(Long borrowApplicationId){ StringBuilder sql = new StringBuilder(). - append("select ti.tousseName,count(ti.amount) convertAmount "). + append("select ti.tousseName as \"tousseName\",count(ti.amount) as \"convertAmount\" "). append("from TousseInstance tis "). append("join Invoice i on tis.invoice_id = i.id "). append("join UseRecord ur on tis.useRecord_id = ur.id "). @@ -3414,7 +3414,7 @@ @Override public Long getBorrowIdByTousseInstanceId(Long tousseInstanceId) { StringBuilder sql = new StringBuilder() - .append("select ip.id borrowId from TousseInstance tis ") + .append("select ip.id as \"borrowId\" from TousseInstance tis ") .append("join Invoice i on tis.invoice_id = i.id ") .append("join RecyclingApplication ip on i.invoicePlan_ID = ip.id ") .append("where tis.id = ?");