An error occurred at line: 9 in the jsp file: /WEB-INF/jsp/LOYALTY.jsp
Syntax error, insert ";" to complete LocalVariableDeclarationStatement
6: "where ia.SUBSCRIPTION_ITEM_ID=si.SUBSCRIPTION_ITEM_ID and mi.mi_id=si.dtl_MI_ID "+
7: "and ia.card_id=:cid"+
8: "and mi.code in (select dtl.mi_id from docs_dtl dtl where doc_id=:docid)"+
9: "group by mi.name1 ,mi.code"+"\n"
10: org.hibernate.Session dbSession1 = (org.hibernate.Session)request.getAttribute("dbSession");
11: org.hibernate.SQLQuery query1 = dbSession1.createSQLQuery(q);
12: query1.setMaxResults(2);


An error occurred at line: 13 in the jsp file: /WEB-INF/jsp/LOYALTY.jsp
STRING cannot be resolved or is not a field
10: org.hibernate.Session dbSession1 = (org.hibernate.Session)request.getAttribute("dbSession");
11: org.hibernate.SQLQuery query1 = dbSession1.createSQLQuery(q);
12: query1.setMaxResults(2);
13: query1.addScalar("LN", org.hibernate.Hibernate.STRING);
14: query.setInteger("cid", ((ru.hrs.lassd.club.vo.Card)request.getAttribute("card")).cardId);
15: query.setLong("docid", ((ru.hrs.lassd.club.scripting.DocInfo)request.getAttribute("docInfo")).getDoc().getId());
16: out.println(query1.list().get(0));%>


An error occurred at line: 14 in the jsp file: /WEB-INF/jsp/LOYALTY.jsp
query cannot be resolved
11: org.hibernate.SQLQuery query1 = dbSession1.createSQLQuery(q);
12: query1.setMaxResults(2);
13: query1.addScalar("LN", org.hibernate.Hibernate.STRING);
14: query.setInteger("cid", ((ru.hrs.lassd.club.vo.Card)request.getAttribute("card")).cardId);
15: query.setLong("docid", ((ru.hrs.lassd.club.scripting.DocInfo)request.getAttribute("docInfo")).getDoc().getId());
16: out.println(query1.list().get(0));%>


An error occurred at line: 15 in the jsp file: /WEB-INF/jsp/LOYALTY.jsp
query cannot be resolved
12: query1.setMaxResults(2);
13: query1.addScalar("LN", org.hibernate.Hibernate.STRING);
14: query.setInteger("cid", ((ru.hrs.lassd.club.vo.Card)request.getAttribute("card")).cardId);
15: query.setLong("docid", ((ru.hrs.lassd.club.scripting.DocInfo)request.getAttribute("docInfo")).getDoc().getId());
16: out.println(query1.list().get(0));%>