Hello, i'm developping a project using appfuse with ibatis. I have a class of procedure and want to load in it a list of policy connected to the procedure.
In the procedure class i have: private List policyList = new ArrayList(); and in the ibatis sql xml i have: <resultMap id="procedureResult" class="procedure"> <result property="comp_id.id" column="id"/> <result property="comp_id.seq" column="seq"/> <result property="startDate" column="start_date"/> <result property="endDate" column="end_date"/> <result property="name" column="name"/> <result property="description" column="description"/> <result property="documentId" column="document_id"/> <result property="documentFileName" column="document_file_name"/> <result property="issuer" column="issuer"/> <result property="policyList" column="id" select="getPoliciesByProcedure"/> </resultMap> <resultMap id="policyResult" class="policy"> <result property="comp_id.id" column="id"/> <result property="comp_id.seq" column="seq"/> <result property="startDate" column="start_date"/> <result property="endDate" column="end_date"/> <result property="name" column="name"/> <result property="description" column="description"/> <result property="documentId" column="document_id"/> <result property="documentFileName" column="document_file_name"/> <result property="issuer" column="issuer"/> </resultMap> <select id="getPoliciesByProcedure" resultMap="policyResult" > <![CDATA[ select pol.id,pol.seq,pol.start_date,pol.end_date,pol.name,pol.description,pol.document_id,pol.document_file_name,pol.issuer from policy as pol inner join map_policy_procedure as mpp on pol.id = mpp.id_policy where mpp.id_procedure = #value# ]]> </select> but when i run the application i get this error: org.springframework.web.util.NestedServletException: Request processing failed; nested exception is com.ibatis.common.exception.NestedRuntimeException: Error lazy loading result. Cause: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in it/sinossi/dao/ibatis/riskanalysis/sql/ProcedureSQL.xml. --- The error occurred while applying a parameter map. --- Check the getPoliciesByProcedure-InlineParameterMap. --- Check the statement (query failed). --- Cause: org.postgresql.util.PSQLException: ERROR: relation "policy" does not exist Caused by: org.postgresql.util.PSQLException: ERROR: relation "policy" does not exist Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in it/sinossi/dao/ibatis/riskanalysis/sql/ProcedureSQL.xml. --- The error occurred while applying a parameter map. --- Check the getPoliciesByProcedure-InlineParameterMap. --- Check the statement (query failed). --- Cause: org.postgresql.util.PSQLException: ERROR: relation "policy" does not exist Caused by: org.postgresql.util.PSQLException: ERROR: relation "policy" does not existwhat's wrong?Thanks in advance andrea cossu --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
