I have been struggling with this for a while now and can't seem to find where I have things messed up.
Here is the error message:
Apr 28, 2005 2:22:14 PM scs.reaction.common.persistence.DAO.impl.ibatis.BaseDAO executeQueryForList
FINER: SQLException returned = com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in scs/reaction/user/persistence/DAO/impl/ibatis/sql-maps/UserDetail.xml.
--- The error occurred while applying a result map.
--- Check the UserDetail.user-detail-result.
--- The error happened while setting a property on the result object.
--- Cause: com.ibatis.common.exception.NestedRuntimeException: Error setting properties of 'UserDetails: userID = 2 , printedName = ALBERT L. SAPP , mailingAddress1 = SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = UNIVERSITY OF ILLINOIS , mailingAddress3 = ROOM 320, NOYES LAB, BOX D-2 , mailingAddress4 = 600 S. MATHEWS , mailingCityStateZip = URBANA, IL 61801-3602 , shippingAddress1 = null , shippingAddress2 = null , shippingAddress3 = null , shippingAddress4 = null , shippingCityStateZip = null , phoneNumber = null , positionTitle = null , createdBy = null , createdOn = null , modifiedBy = null , modifiedOn = null , conCheck = null'. Cause: java.lang.NullPointerException
Caused by: java.lang.NullPointerException
Caused by: com.ibatis.common.exception.NestedRuntimeException: Error setting properties of 'UserDetails: userID = 2 , printedName = ALBERT L. SAPP , mailingAddress1 = SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = UNIVERSITY OF ILLINOIS , mailingAddress3 = ROOM 320, NOYES LAB, BOX D-2 , mailingAddress4 = 600 S. MATHEWS , mailingCityStateZip = URBANA, IL 61801-3602 , shippingAddress1 = null , shippingAddress2 = null , shippingAddress3 = null , shippingAddress4 = null , shippingCityStateZip = null , phoneNumber = null , positionTitle = null , createdBy = null , createdOn = null , modifiedBy = null , modifiedOn = null , conCheck = null'. Cause: java.lang.NullPointerException
Caused by: java.lang.NullPointerException
Apr 28, 2005 2:22:14 PM scs.reaction.user.impl.UserManagerImp retrieveUserDetail
FINEST: Critical Error: DaoException = com.ibatis.dao.client.DaoException: Error executing query for list. Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in scs/reaction/user/persistence/DAO/impl/ibatis/sql-maps/UserDetail.xml.
--- The error occurred while applying a result map.
--- Check the UserDetail.user-detail-result.
--- The error happened while setting a property on the result object.
--- Cause: com.ibatis.common.exception.NestedRuntimeException: Error setting properties of 'UserDetails: userID = 2 , printedName = ALBERT L. SAPP , mailingAddress1 = SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = UNIVERSITY OF ILLINOIS , mailingAddress3 = ROOM 320, NOYES LAB, BOX D-2 , mailingAddress4 = 600 S. MATHEWS , mailingCityStateZip = URBANA, IL 61801-3602 , shippingAddress1 = null , shippingAddress2 = null , shippingAddress3 = null , shippingAddress4 = null , shippingCityStateZip = null , phoneNumber = null , positionTitle = null , createdBy = null , createdOn = null , modifiedBy = null , modifiedOn = null , conCheck = null'. Cause: java.lang.NullPointerException
Caused by: java.lang.NullPointerException
Caused by: com.ibatis.common.exception.NestedRuntimeException: Error setting properties of 'UserDetails: userID = 2 , printedName = ALBERT L. SAPP , mailingAddress1 = SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = UNIVERSITY OF ILLINOIS , mailingAddress3 = ROOM 320, NOYES LAB, BOX D-2 , mailingAddress4 = 600 S. MATHEWS , mailingCityStateZip = URBANA, IL 61801-3602 , shippingAddress1 = null , shippingAddress2 = null , shippingAddress3 = null , shippingAddress4 = null , shippingCityStateZip = null , phoneNumber = null , positionTitle = null , createdBy = null , createdOn = null , modifiedBy = null , modifiedOn = null , conCheck = null'. Cause: java.lang.NullPointerException
Caused by: java.lang.NullPointerException
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in scs/reaction/user/persistence/DAO/impl/ibatis/sql-maps/UserDetail.xml.
--- The error occurred while applying a result map.
--- Check the UserDetail.user-detail-result.
--- The error happened while setting a property on the result object.
--- Cause: com.ibatis.common.exception.NestedRuntimeException: Error setting properties of 'UserDetails: userID = 2 , printedName = ALBERT L. SAPP , mailingAddress1 = SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = UNIVERSITY OF ILLINOIS , mailingAddress3 = ROOM 320, NOYES LAB, BOX D-2 , mailingAddress4 = 600 S. MATHEWS , mailingCityStateZip = URBANA, IL 61801-3602 , shippingAddress1 = null , shippingAddress2 = null , shippingAddress3 = null , shippingAddress4 = null , shippingCityStateZip = null , phoneNumber = null , positionTitle = null , createdBy = null , createdOn = null , modifiedBy = null , modifiedOn = null , conCheck = null'. Cause: java.lang.NullPointerException
Caused by: java.lang.NullPointerException
Caused by: com.ibatis.common.exception.NestedRuntimeException: Error setting properties of 'UserDetails: userID = 2 , printedName = ALBERT L. SAPP , mailingAddress1 = SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = UNIVERSITY OF ILLINOIS , mailingAddress3 = ROOM 320, NOYES LAB, BOX D-2 , mailingAddress4 = 600 S. MATHEWS , mailingCityStateZip = URBANA, IL 61801-3602 , shippingAddress1 = null , shippingAddress2 = null , shippingAddress3 = null , shippingAddress4 = null , shippingCityStateZip = null , phoneNumber = null , positionTitle = null , createdBy = null , createdOn = null , modifiedBy = null , modifiedOn = null , conCheck = null'. Cause: java.lang.NullPointerException
Caused by: java.lang.NullPointerException
Apr 28, 2005 2:22:14 PM scs.reaction.struts.user.actions.userDetail.BrowseUserDetailAction execute
SEVERE: Critical Error: Unable to get detail information for the user. scs.reaction.common.exceptions.manager.ManagerException: Critical Error: Error executing query for list. Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in scs/reaction/user/persistence/DAO/impl/ibatis/sql-maps/UserDetail.xml.
--- The error occurred while applying a result map.
--- Check the UserDetail.user-detail-result.
--- The error happened while setting a property on the result object.
--- Cause: com.ibatis.common.exception.NestedRuntimeException: Error setting properties of 'UserDetails: userID = 2 , printedName = ALBERT L. SAPP , mailingAddress1 = SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = UNIVERSITY OF ILLINOIS , mailingAddress3 = ROOM 320, NOYES LAB, BOX D-2 , mailingAddress4 = 600 S. MATHEWS , mailingCityStateZip = URBANA, IL 61801-3602 , shippingAddress1 = null , shippingAddress2 = null , shippingAddress3 = null , shippingAddress4 = null , shippingCityStateZip = null , phoneNumber = null , positionTitle = null , createdBy = null , createdOn = null , modifiedBy = null , modifiedOn = null , conCheck = null'. Cause: java.lang.NullPointerException
Caused by: java.lang.NullPointerException
Caused by: com.ibatis.common.exception.NestedRuntimeException: Error setting properties of 'UserDetails: userID = 2 , printedName = ALBERT L. SAPP , mailingAddress1 = SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = UNIVERSITY OF ILLINOIS , mailingAddress3 = ROOM 320, NOYES LAB, BOX D-2 , mailingAddress4 = 600 S. MATHEWS , mailingCityStateZip = URBANA, IL 61801-3602 , shippingAddress1 = null , shippingAddress2 = null , shippingAddress3 = null , shippingAddress4 = null , shippingCityStateZip = null , phoneNumber = null , positionTitle = null , createdBy = null , createdOn = null , modifiedBy = null , modifiedOn = null , conCheck = null'. Cause: java.lang.NullPointerException
Caused by: java.lang.NullPointerException
Here is the result map and sql query:
<resultMap id="user-detail-result" class="scs.reaction.user.beans.UserDetail">
<result property="userID" column="USER_ID" jdbcType="BIGINT"/>
<result property="printedName" column="PRINTED_NAME" jdbcType="VARCHAR"/>
<result property="mailingAddress1" column="MAILING_ADDRESS_1" jdbcType="VARCHAR"/>
<result property="mailingAddress2" column="MAILING_ADDRESS_2" jdbcType="VARCHAR"/>
<result property="mailingAddress3" column="MAILING_ADDRESS_3" jdbcType="VARCHAR"/>
<result property="mailingAddress4" column="MAILING_ADDRESS_4" jdbcType="VARCHAR"/>
<result property="mailingCityStateZip" column="MAILING_CITY_STATE_ZIP" jdbcType="VARCHAR"/>
<result property="shippingAddress1" column="SHIPPING_ADDRESS_1" jdbcType="VARCHAR"/>
<result property="shippingAddress2" column="SHIPPING_ADDRESS_2" jdbcType="VARCHAR"/>
<result property="shippingAddress3" column="SHIPPING_ADDRESS_3" jdbcType="VARCHAR"/>
<result property="shippingAddress4" column="SHIPPING_ADDRESS_4" jdbcType="VARCHAR"/>
<result property="shippingCityStateZip" column="SHIPPING_CITY_STATE_ZIP" jdbcType="VARCHAR"/>
<result property="phoneNumber" column="PHONE_NUMBER" jdbcType="VARCHAR"/>
<result property="positionTitle" column="POSITION_TITLE" jdbcType="VARCHAR"/>
<result property="createdBy" column="CREATED_BY" jdbcType="BIGINT"/>
<result property="createdOn" column="CREATED_ON" jdbcType="DATE"/>
<result property="modifiedBy" column="MODIFIED_BY" jdbcType="BIGINT"/>
<result property="modifiedOn" column="MODIFIED_ON" jdbcType="DATE"/>
<result property="conCheck" column="CON_CHECK" jdbcType="BIGINT"/>
</resultMap>
<cacheModel id="user-detail-cache" type="LRU">
<flushInterval hours="24"/>
<flushOnExecute statement="UserDetailInsert"/>
<flushOnExecute statement="UserDetailUpdate"/>
<flushOnExecute statement="UserDetailDeleteByProperty"/>
</cacheModel>
<statement id="UserDetailGetByPropertiesAND" resultMap="user-detail-result" cacheModel="user-detail-cache">
</statement>
I am able to insert the record fine and I can view it in the output from a query command in sqlplus. The only fields that are null in the record are the shipping address fields. All other fields have data.
Any ideas? I am betting with myself that it is something simple that I keep overlooking when I go through the code.
Thanks.
