Hi
In our web application we are trying
to update a table. our query is,
<update
id="updateProjectMasterDetails"
parameterClass="com.tracker.dto.project.ProjectMasterDTO">
UPDATE PROJECT_MASTER
SET
ORG_HIERARCHY_ID =
#orgHierarchyId#,
PMO_NUMBER =
#pmoNumber#,
STAR_PRO_NUMBER =
#starProNumber#,
DESCRIPTION =
#description#,
IMPACT_DETAIL =
#impactDetail#,
STATUS =
#status#,
PRIORITY =
#priority#,
CATEGORY =
#category#,
ESUBMIT_MODEL =
#esubmitModel#,
QUARTER_OF_IMPLEMENTATION = #quaterOfImpl#,
MODEL_OFFICE_1 =
#modelOffice1#,
MODEL_OFFICE_2 =
#modelOffice2#,
SIZE_OF_EFFORT =
#sizeOfEffort#,
MEASUREMENT_VER_DETAIL =
#measurementVerDetail#,
DEPARTMENT_INVL_DETAIL =
#invlOtherDepartments#,
NINTY_DAY_ACTION_PLAN =
#nintyDayActionPlan#,
PRIMARY_SYSTEM =
#primarySystem#,
SECONDARY_SYSTEM =
#secondarySystem#,
BUSINESS_OWNER =
#businessOwner#,
PROJECT_OWNER =
#projectOwner#,
BUSINESS_AREA_LEAD =
#businessAreaLead#,
PROJECT_LEAD =
#projectLead#,
IT_LEAD_1 =
#itLead1#,
IT_LEAD_2 =
#itLead2#,
IT_LEAD_3 =
#itLead3#,
DATE_PLAN_CREATED =
#datePlanCreated:DATE#,
COMPLETION_DATE_IMPACT =
#completionDateImpact:DATE#,
QUARTER_OF_UPDATE =
#quarterOfUpdate#,
PERCENTAGE_COMPLETE =
#percentageComplete#,
PLANNED_START_DATE =
#plannedStartDate:DATE#,
PLANNED_END_DATE =
#plannedEndDate:DATE#,
ACTUAL_START_DATE =
#actualStartDate:DATE#,
ACTUAL_END_DATE =
#actualEndDate:DATE#,
MODIFIED_USER_ID =
#modifiedUserId#,
MODIFIED_DATE = SYSDATE
WHERE
PROJECT_ID =
#projectId#
</update>
some times this query is executed without any error, particularly for the first
request after the
application being started. For all the subsequent
requests we run in to following error. The error messages also not
consistent, most of the time error messages are either of the
following.
--- Check the parameter mapping for the 'actualStartDate'
property.
--- Check the parameter mapping for the 'actualEndDate'
property.
--- Check the parameter mapping for the 'projectId'
property.
The data type in the DTO are
actualStartDate -
java.util.Date
actualEndDate - java.util.Date
projectId - BigDecimal
The date type of the corresoponding fields in tabel
are (Data base is Oracle 9i)
actualStartDate - Date
actualEndDate - Date
projectId - Number
The stack trace is as follow,
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
com/tracker/dao/conf/sqlMap/projectMap.xml.
--- The error occurred
while applying a parameter map.
--- Check the
updateProjectMasterDetails-InlineParameterMap.
--- Check the
parameter mapping for the 'actualEndDate' property.
--- Cause:
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
Caused by:
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
[2/15/06
23:08:24:225 GMT+05:30] 282fda15 SystemErr
Caused by:
[2/15/06 23:08:24:225 GMT+05:30] 282fda15
SystemErr java.lang.IndexOutOfBoundsException:
Index: 0, Size: 0
our working environment is webspher application server 5.0. we dont understand the cause of the problem
any help could be really
appreciated.
thanks in advance
Manikandan
