ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahesh Kumar" <rah...@gmail.com>
Subject Bean probe exception
Date Fri, 18 Aug 2006 07:19:50 GMT
Hi all,

Can anyone of you please explain me when a bean probe exception would occur?
Herewith I am attaching the stack trace of the exception i got when I was
trying to run a report . My xml is as follows
My resultMap


<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)

Mime
View raw message