RE: Error message - com.ibatis.common.jdbc.exception.NestedSQLEx cepti on

["Manikandan.R, ISDC Chennai" <ma...@hcl.in>]

Thanks for your response vincent. we checked the projectId, it is not
null and also we think java.sql.Date is not required if there is a real
problem then how come it updata the data during first time. we come to
know, nature of the error message is not consistent with particular
field.
 
 -----Original Message-----
From: Vincent NICOLAS [mailto:vincent.nicolas@teamlog.com]
Sent: Thursday, February 16, 2006 7:30 PM
To: user-java@ibatis.apache.org
Subject: Re: Error message -
com.ibatis.common.jdbc.exception.NestedSQLExcepti on



Use java.sql.Date instead. Check if the projectId is not null.
Hope it helps.

Manikandan.R, ISDC Chennai a écrit : 

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



-- 

Vincent NICOLAS

Teamlog, Lyon