<
resultMap id="billingOnCallResult" class="ctrs.reports.components.BillingReport"> <result property="projectGroupName" column="PROJECTGROUPNAME" /> <result property="projectName" column="PROJECT_NAME" /> <result property="contractorName" column="CONTRACTOR_NAME" /> <result property="projectLeadName" column="TIMESHEET_APPROVER_NAME" /> <result property="tsLocation" column="WORKING_FROM" /> <result property="rate" column="ONCALL_RATE" /> <result property="offshore_reg_rate" column="OFFSHORE_ONCALL_RATE" /> <result property="contractorUpi" column="CONTRACTOR_UPI" /> <result property="projectId" column="PROJECT_ID" /> <result property="timesheetType" column="TIMESHEET_TYPE" /> <result property="weekendModel.weekend " column="weekending_date" /> <result property="weekendModel.hours " column="TOTAL_BILLABLE_ONCALL_HOURS" /> <result property="weekendModel.timesheetLocation " column="WORKING_FROM" /> </resultMap>
my query
<
select id="getBillingReportList" resultMap="billingResult">SELECT
( select group_name projectgroupname from project_groups where group_id =
(select group_id from projects where project_id = ta.project_id)
) projectgroupname ,ta.project_id,ta.project_name,ta.contractor_name ,ta.contractor_upi,
ta.projectlead_name TIMESHEET_APPROVER_NAME ,cv.REGULAR_RATE,cv.OFFSHORE_REGULAR_RATE,
decode(ta.working_from, 'Not Applicable' , 'Onsite', ta.working_from) working_from
,ta.total_approved_regular_hours , to_char(ta.weekending_date,'MM/DD/YYYY') weekending_date , cv.TIMESHEET_TYPE
FROM timesheets_approval ta, projects pg ,all_contractors_view cv
WHERE
cv.contractor_upi = ta.contractor_upi
and ta.project_id = pg.project_id
AND ta.APPROVAL_STATUS = 'TIMESHEET APPROVED'
and cv. vendor_id =#selectedVendors#
<dynamic> <isEqual property="isDifferential" compareValue="YES">and ta.locked = 'NO'
</isEqual> </dynamic> <dynamic> <isNotNull prepend="AND" property="selectedProjects"> <iterate property="selectedProjects" open="(" close= ")" conjunction="OR">ta.project_id = #selectedProjects[]#
</iterate> </isNotNull> </dynamic> <dynamic> <isNotNull prepend="AND" property="firstSundayList"> <iterate property="firstSundayList" open="(" close= ")" conjunction="OR">ta.weekending_date BETWEEN TO_DATE(#firstSundayList[].firstSundayDate# , 'MM/DD/YYYY') AND TO_DATE(#firstSundayList[].lastSundayDate# , 'MM/DD/YYYY')
</iterate> </isNotNull> <isEqual property="isWeekEnd" compareValue="TRUE"> <isNotNull prepend="AND" property="startSqlDate">ta.weekending_date BETWEEN TO_DATE(#startSqlDate# , 'MM/DD/YYYY') AND TO_DATE(#endSqlDate# , 'MM/DD/YYYY')
</isNotNull> </isEqual> <isEqual property="isWeekEnd" compareValue="FALSE"> <isNotNull prepend="AND" property="startSqlDate">ta.weekending_date BETWEEN TO_DATE(#startSqlDate# , 'MM/DD/YYYY') AND NEXT_DAY(TO_DATE(#endSqlDate# , 'MM/DD/YYYY') , 'SUNDAY')
</isNotNull> </isEqual> </dynamic>GROUP BY pg.group_name,ta.contractor_name,ta.project_id,ta.project_name,cv.contractor_name,ta.contractor_upi,ta.projectlead_name,cv.REGULAR_RATE,cv.OFFSHORE_REGULAR_RATE,ta.working_from
,ta.total_approved_regular_hours , ta.weekending_date , cv.TIMESHEET_TYPE
ORDER BY pg.group_name,ta.project_id,ta.project_name,cv.contractor_name,ta.contractor_upi, ta.weekending_date
</select>
The same result map works for another query. Can you please explain me what could have actually caused the error? Thanks
java.lang.RuntimeException: There was an error. Cause: com.ibatis.dao.client.DaoException: Failed to queryForList - id [getOnCallBillingReportList], parameterObject [{selectedOperation=Do not lock, selectedVendors=0000000028, selectedProjects=[81, 0000000678, 0000000443, 0000000412, 0000000544, 82, 83, 84, 85, 86, 87, 88, 0000000019, 0000000596, 0000000533, 0000000008, 0000000017, 0000000016, 0000000060, 0000000044, 0000000042, 0000000043, 0000000039, 0000000045, 0000000040, 0000000038, 89, 90, 91, 0000000560, 92, 93, 94, 0000000036, 95, 96, 97, 98, 0000000014, 0000000365, 99, 0000000023, 101, 0000000361, 102, 0000000608, 0000000621, 0000000633, 0000000601, 0000000598, 0000000599, 0000000570, 0000000631, 0000000571, 0000000569, 0000000567, 0000000568, 103, 104, 105, 106, 0000000618, 107, 108, 109, 111, 112, 0000000513, 113, 114, 115, 116, 0000000435, 117, 118, 119, 121, 0000000575, 0000000444, 0000000002, 0000000499, 0000000047, 0000000037, 0000000503, 0000000414, 0000000061, 0000000564, 0000000565, 0000000026, 0000000478, 0000000518, 0000000430, 0000000539, 0000000510, 0000000368, 123, 124, 125, 126, 127, 128, 130, 129, 131, 0000000526, 0000000396, 132, 133, 134, 135, 136, 137, 138, 139, 0000000024, 0000000003, 0000000075, 0000000595, 0000000007, 0000000481, 0000000420, 0000000509, 0000000425, 0000000054, 145, 146, 147, 148, 149, 143, 144, 0000000519, 0000000456, 0000000493, 150, 151, 0000000613, 0000000614, 152, 153, 0000000537, 0000000615, 154, 0000000013, 155, 0000000021, 156, 157, 158, 0000000457, 0000000563, 0000000586, 0000000475, 0000000609, 0000000476, 0000000474, 0000000470, 0000000473, 0000000616, 0000000468, 0000000467, 0000000469, 0000000472, 0000000466, 0000000471, 0000000556, 159, 160, 161, 162, 0000000035, 0000000502, 0000000459, 0000000027, 0000000434, 0000000515, 0000000433, 164, 163, 165, 0000000056, 166, 0000000385, 167, 168, 169, 170, 171, 0000000455, 0000000523, 0000000410, 0000000419, 0000000500, 0000000413, 172, 173, 174, 0000000559, 0000000576, 175, 176, 0000000527, 177, 178, 180, 0000000531, 0000000463, 181, 182, 0000000384, 0000000555, 183, 0000000482, 0000000485, 0000000484, 0000000521, 0000000483, 0000000005, 184, 0000000065, 0000000079, 185, 0000000378, 0000000629, 0000000489, 0000000532, 0000000070, 0000000677, 186, 187, 0000000512, 0000000370, 0000000426, 0000000550, 0000000072, 188, 189, 0000000554, 0000000587, 0000000592, 0000000562, 0000000551, 0000000464, 0000000634, 190, 193, 0000000479, 191, 0000000552, 192, 0000000379, 0000000055, 0000000620, 194, 0000000549, 195, 0000000422, 0000000423, 0000000041, 0000000049, 0000000048, 0000000031, 0000000004, 196, 0000000397, 0000000622, 0000000623, 0000000619, 197, 198, 199, 200, 201, 203, 204, 205, 0000000647, 0000000648, 0000000454, 0000000488, 0000000487, 0000000577, 0000000486, 0000000669, 206, 0000000667, 207, 208, 0000000078, 0000000605, 0000000546, 0000000607, 0000000606, 209, 0000000580, 0000000579, 210, 211, 0000000074, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 0000000520, 226, 0000000417, 227, 0000000033, 228, 229, 0000000432, 0000000492, 0000000358, 0000000446, 0000000498, 0000000447, 0000000491, 231, 0000000610, 0000000602, 0000000666, 0000000617, 0000000448, 0000000449, 0000000067, 0000000578, 338, 0000000664, 0000000632, 232, 0000000001, 0000000548, 0000000069, 0000000006, 235, 0000000418, 0000000528, 0000000465, 0000000581, 0000000356, 0000000372, 236, 237, 238, 0000000445, 239, 240, 241, 242, 0000000062, 0000000077, 243, 245, 0000000626, 246, 247, 0000000630, 248, 0000000494, 0000000668, 0000000362, 249, 250, 251, 0000000604, 0000000012, 0000000360, 0000000584, 0000000588, 279, 280, 281, 282, 0000000522, 0000000636, 284, 285, 286, 287, 0000000359, 0000000670, 288, 289, 0000000389, 0000000511, 0000000366, 0000000427, 0000000536, 0000000508, 0000000553, 0000000025, 0000000591, 0000000517, 0000000382, 0000000080, 0000000052, 290, 291, 0000000572, 0000000574, 292, 0000000674, 293, 0000000028, 0000000011, 0000000516, 0000000395, 294, 0000000480, 295, 296, 297, 0000000566, 0000000675, 0000000557, 298, 299, 300, 301, 0000000643, 0000000642, 0000000640, 0000000644, 0000000646, 0000000638, 0000000645, 0000000641, 0000000639, 0000000367, 0000000504, 302, 303, 0000000051, 0000000458, 0000000030, 304, 0000000415, 0000000363, 305, 306, 307, 308, 309, 310, 311, 0000000386, 0000000409, 0000000408, 0000000402, 0000000391, 0000000390, 0000000407, 0000000394, 0000000589, 0000000401, 0000000403, 0000000388, 0000000411, 0000000392, 0000000404, 0000000387, 0000000399, 0000000405, 0000000406, 0000000393, 0000000400, 312, 313, 314, 315, 316, 317, 318, 319, 320, 0000000059, 0000000058, 321, 322, 0000000657, 323, 0000000534, 0000000635, 0000000383, 0000000665, 0000000637, 0000000600, 0000000535, 0000000547, 0000000440, 0000000441, 0000000076, 0000000442, 0000000439, 0000000437, 0000000438, 0000000529, 0000000524, 326, 324, 325, 327, 328, 0000000015, 0000000376, 329, 330, 332, 333, 335, 336, 0000000651, 0000000477, 0000000009, 0000000593, 0000000050, 0000000625, 0000000624, 0000000357, 0000000655, 0000000653, 0000000654, 0000000652, 253, 254, 255, 257, 0000000429, 258, 259, 260, 261, 0000000431, 0000000612, 262, 263, 0000000542, 0000000649, 264, 266, 267, 268, 0000000505, 0000000506, 0000000543, 0000000421, 0000000416, 0000000501, 0000000369, 0000000540, 0000000573, 0000000497, 0000000377, 0000000071, 0000000018, 0000000538, 0000000022, 0000000545, 0000000380, 0000000046, 0000000066, 270, 271, 272, 273, 274, 275, 0000000453, 276, 0000000029, 277, 278, 339, 0000000611, 0000000064, 0000000057, 0000000541, 0000000585, 0000000558, 0000000053, 0000000020, 0000000594, 0000000582, 0000000583, 0000000676, 0000000507, 340, 341, 342, 343, 0000000603, 0000000375, 0000000063, 0000000461, 0000000462, 0000000460, 0000000073, 345, 0000000656, 0000000495, 346, 347, 348, 349, 0000000436, 350, 351, 354, 0000000428, 0000000371, 0000000530, 0000000034, 0000000514, 0000000398, 0000000628, 0000000561, 0000000590, 0000000424, 0000000381, 0000000373, 0000000452, 0000000451, 355, 0000000597, 0000000374, 0000000525, 0000000496, 0000000450, 142, 0000000627, 0000000650, 0000000364, 0000000068]}]. Cause: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in ctrs/persistence/sql/Reports.xml. --- The error occurred while applying a result map. --- Check the Reports.billingOnCallResult. --- The error happened while setting a property on the result object. --- Cause: com.ibatis.common.beans.ProbeException: Could not set property 'hours' for ctrs.reports.components.WeekendModel. Cause: java.lang.IllegalArgumentException Caused by: java.lang.IllegalArgumentException Caused by: com.ibatis.common.beans.ProbeException : Could not set property 'hours' for ctrs.reports.components.WeekendModel. Cause: java.lang.IllegalArgumentException Caused by: java.lang.IllegalArgumentException Caused by: com.ibatis.common.jdbc.exception.NestedSQLException : --- The error occurred in ctrs/persistence/sql/Reports.xml. --- The error occurred while applying a result map. --- Check the Reports.billingOnCallResult. --- The error happened while setting a property on the result object. --- Cause: com.ibatis.common.beans.ProbeException: Could not set property 'hours' for ctrs.reports.components.WeekendModel. Cause: java.lang.IllegalArgumentException Caused by: java.lang.IllegalArgumentException Caused by: com.ibatis.common.beans.ProbeException : Could not set property 'hours' for ctrs.reports.components.WeekendModel. Cause: java.lang.IllegalArgumentException Caused by: java.lang.IllegalArgumentException at ctrs.domain.logic.ReportsLogic.getOnCallBillingReportList (Unknown Source) at ctrs.actions.ReportAction.generateBillingReportParams(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java :39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java :270) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process (RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java :760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service (StrictLifecycleServlet.java:174) at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch (ServletInstanceReference.java:40) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1171) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java :676) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:203) at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:125) at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook (WebAppInvoker.java:294) at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java :182) at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) at com.ibm.ws.http.HttpConnection.readAndHandleRequest (HttpConnection.java:652) at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:448) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:912)
