Return-Path: Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org Received: (qmail 74414 invoked from network); 28 Apr 2005 20:19:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 28 Apr 2005 20:19:52 -0000 Received: (qmail 93903 invoked by uid 500); 28 Apr 2005 20:21:01 -0000 Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org Received: (qmail 93880 invoked by uid 500); 28 Apr 2005 20:21:01 -0000 Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Precedence: bulk Reply-To: ibatis-user-java@incubator.apache.org List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 93864 invoked by uid 99); 28 Apr 2005 20:21:01 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=RCVD_BY_IP X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of brandon.goodin@gmail.com designates 64.233.170.201 as permitted sender) Received: from rproxy.gmail.com (HELO rproxy.gmail.com) (64.233.170.201) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 28 Apr 2005 13:21:00 -0700 Received: by rproxy.gmail.com with SMTP id c16so533990rne for ; Thu, 28 Apr 2005 13:19:48 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=LZgyOC7UJozgFU8+LzuOHTw0d8HuuDJRr4NiDsby40Xrp2yFHjWIg6+E2StaoHkVp0Qjo9dXPm999BSEhMitZ6sA4kgBN61zZCyrjf1fqGbHRAOQmYMuXG95H8mYhr1KIsIA/pVVtdVDhJ7iRA5xoMptiLxXa/TOD1+E/UokLxM= Received: by 10.38.12.8 with SMTP id 8mr2753231rnl; Thu, 28 Apr 2005 13:19:48 -0700 (PDT) Received: by 10.38.74.62 with HTTP; Thu, 28 Apr 2005 13:19:48 -0700 (PDT) Message-ID: <2fe5ef5b05042813199787ac5@mail.gmail.com> Date: Thu, 28 Apr 2005 14:19:48 -0600 From: Brandon Goodin Reply-To: Brandon Goodin To: ibatis-user-java@incubator.apache.org Subject: Re: Problem with result mapping. In-Reply-To: <6.2.1.2.2.20050428145837.03733e08@express.cites.uiuc.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <6.2.1.2.2.20050428145837.03733e08@express.cites.uiuc.edu> X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Why don't you simply eliminate fields until the problem disappears. Then add fields back in to see which are the offending fields. At that point you will be able to narrow the problem area. once you have done that we might be able to provide you with better insight. On 4/28/05, Albert L. Sapp wrote: > Hi, guys. >=20 > I have been struggling with this for a while now and can't seem to find > where I have things messed up. >=20 > Here is the error message: >=20 > Apr 28, 2005 2:22:14 PM > scs.reaction.common.persistence.DAO.impl.ibatis.BaseDAO > executeQueryForList > FINER: SQLException returned =3D > com.ibatis.common.jdbc.exception.NestedSQLException: =20 > --- The error occurred in > scs/reaction/user/persistence/DAO/impl/ibatis/sql-maps/UserDetail.xml. > =20 > --- The error occurred while applying a result map. =20 > --- Check the UserDetail.user-detail-result. =20 > --- The error happened while setting a property on the result object. = =20 > --- Cause: > com.ibatis.common.exception.NestedRuntimeException: Error > setting properties of 'UserDetails: userID =3D 2 , printedName =3D ALBERT= L. > SAPP , mailingAddress1 =3D SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = =3D > UNIVERSITY OF ILLINOIS , mailingAddress3 =3D ROOM 320, NOYES LAB, BOX D-2= , > mailingAddress4 =3D 600 S. MATHEWS , mailingCityStateZip =3D URBANA, IL > 61801-3602 , shippingAddress1 =3D null , shippingAddress2 =3D null , > shippingAddress3 =3D null , shippingAddress4 =3D null , shippingCityState= Zip =3D > null , phoneNumber =3D null , positionTitle =3D null , createdBy =3D null= , > createdOn =3D null , modifiedBy =3D null , modifiedOn =3D null , conCheck= =3D null'. > Cause: java.lang.NullPointerException > Caused by: java.lang.NullPointerException > Caused by: > com.ibatis.common.exception.NestedRuntimeException: Error > setting properties of 'UserDetails: userID =3D 2 , printedName =3D ALBERT= L. > SAPP , mailingAddress1 =3D SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = =3D > UNIVERSITY OF ILLINOIS , mailingAddress3 =3D ROOM 320, NOYES LAB, BOX D-2= , > mailingAddress4 =3D 600 S. MATHEWS , mailingCityStateZip =3D URBANA, IL > 61801-3602 , shippingAddress1 =3D null , shippingAddress2 =3D null , > shippingAddress3 =3D null , shippingAddress4 =3D null , shippingCityState= Zip =3D > null , phoneNumber =3D null , positionTitle =3D null , createdBy =3D null= , > createdOn =3D null , modifiedBy =3D null , modifiedOn =3D null , conCheck= =3D 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 =3D > com.ibatis.dao.client.DaoException: Error executing query > for list. Cause: > com.ibatis.common.jdbc.exception.NestedSQLException: =20 > --- The error occurred in > scs/reaction/user/persistence/DAO/impl/ibatis/sql-maps/UserDetail.xml. > =20 > --- The error occurred while applying a result map. =20 > --- Check the UserDetail.user-detail-result. =20 > --- The error happened while setting a property on the result object. = =20 > --- Cause: > com.ibatis.common.exception.NestedRuntimeException: Error > setting properties of 'UserDetails: userID =3D 2 , printedName =3D ALBERT= L. > SAPP , mailingAddress1 =3D SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = =3D > UNIVERSITY OF ILLINOIS , mailingAddress3 =3D ROOM 320, NOYES LAB, BOX D-2= , > mailingAddress4 =3D 600 S. MATHEWS , mailingCityStateZip =3D URBANA, IL > 61801-3602 , shippingAddress1 =3D null , shippingAddress2 =3D null , > shippingAddress3 =3D null , shippingAddress4 =3D null , shippingCityState= Zip =3D > null , phoneNumber =3D null , positionTitle =3D null , createdBy =3D null= , > createdOn =3D null , modifiedBy =3D null , modifiedOn =3D null , conCheck= =3D null'. > Cause: java.lang.NullPointerException > Caused by: java.lang.NullPointerException > Caused by: > com.ibatis.common.exception.NestedRuntimeException: Error > setting properties of 'UserDetails: userID =3D 2 , printedName =3D ALBERT= L. > SAPP , mailingAddress1 =3D SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = =3D > UNIVERSITY OF ILLINOIS , mailingAddress3 =3D ROOM 320, NOYES LAB, BOX D-2= , > mailingAddress4 =3D 600 S. MATHEWS , mailingCityStateZip =3D URBANA, IL > 61801-3602 , shippingAddress1 =3D null , shippingAddress2 =3D null , > shippingAddress3 =3D null , shippingAddress4 =3D null , shippingCityState= Zip =3D > null , phoneNumber =3D null , positionTitle =3D null , createdBy =3D null= , > createdOn =3D null , modifiedBy =3D null , modifiedOn =3D null , conCheck= =3D null'. > Cause: java.lang.NullPointerException > Caused by: java.lang.NullPointerException > Caused by: > com.ibatis.common.jdbc.exception.NestedSQLException: =20 > --- The error occurred in > scs/reaction/user/persistence/DAO/impl/ibatis/sql-maps/UserDetail.xml. > =20 > --- The error occurred while applying a result map. =20 > --- Check the UserDetail.user-detail-result. =20 > --- The error happened while setting a property on the result object. = =20 > --- Cause: > com.ibatis.common.exception.NestedRuntimeException: Error > setting properties of 'UserDetails: userID =3D 2 , printedName =3D ALBERT= L. > SAPP , mailingAddress1 =3D SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = =3D > UNIVERSITY OF ILLINOIS , mailingAddress3 =3D ROOM 320, NOYES LAB, BOX D-2= , > mailingAddress4 =3D 600 S. MATHEWS , mailingCityStateZip =3D URBANA, IL > 61801-3602 , shippingAddress1 =3D null , shippingAddress2 =3D null , > shippingAddress3 =3D null , shippingAddress4 =3D null , shippingCityState= Zip =3D > null , phoneNumber =3D null , positionTitle =3D null , createdBy =3D null= , > createdOn =3D null , modifiedBy =3D null , modifiedOn =3D null , conCheck= =3D null'. > Cause: java.lang.NullPointerException > Caused by: java.lang.NullPointerException > Caused by: > com.ibatis.common.exception.NestedRuntimeException: Error > setting properties of 'UserDetails: userID =3D 2 , printedName =3D ALBERT= L. > SAPP , mailingAddress1 =3D SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = =3D > UNIVERSITY OF ILLINOIS , mailingAddress3 =3D ROOM 320, NOYES LAB, BOX D-2= , > mailingAddress4 =3D 600 S. MATHEWS , mailingCityStateZip =3D URBANA, IL > 61801-3602 , shippingAddress1 =3D null , shippingAddress2 =3D null , > shippingAddress3 =3D null , shippingAddress4 =3D null , shippingCityState= Zip =3D > null , phoneNumber =3D null , positionTitle =3D null , createdBy =3D null= , > createdOn =3D null , modifiedBy =3D null , modifiedOn =3D null , conCheck= =3D 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.= =20 > scs.reaction.common.exceptions.manager.ManagerException: > Critical Error: Error executing query for list. Cause: > com.ibatis.common.jdbc.exception.NestedSQLException: =20 > --- The error occurred in > scs/reaction/user/persistence/DAO/impl/ibatis/sql-maps/UserDetail.xml. > =20 > --- The error occurred while applying a result map. =20 > --- Check the UserDetail.user-detail-result. =20 > --- The error happened while setting a property on the result object. = =20 > --- Cause: > com.ibatis.common.exception.NestedRuntimeException: Error > setting properties of 'UserDetails: userID =3D 2 , printedName =3D ALBERT= L. > SAPP , mailingAddress1 =3D SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = =3D > UNIVERSITY OF ILLINOIS , mailingAddress3 =3D ROOM 320, NOYES LAB, BOX D-2= , > mailingAddress4 =3D 600 S. MATHEWS , mailingCityStateZip =3D URBANA, IL > 61801-3602 , shippingAddress1 =3D null , shippingAddress2 =3D null , > shippingAddress3 =3D null , shippingAddress4 =3D null , shippingCityState= Zip =3D > null , phoneNumber =3D null , positionTitle =3D null , createdBy =3D null= , > createdOn =3D null , modifiedBy =3D null , modifiedOn =3D null , conCheck= =3D null'. > Cause: java.lang.NullPointerException > Caused by: java.lang.NullPointerException > Caused by: > com.ibatis.common.exception.NestedRuntimeException: Error > setting properties of 'UserDetails: userID =3D 2 , printedName =3D ALBERT= L. > SAPP , mailingAddress1 =3D SCHOOL OF CHEMICAL SCIENCES , mailingAddress2 = =3D > UNIVERSITY OF ILLINOIS , mailingAddress3 =3D ROOM 320, NOYES LAB, BOX D-2= , > mailingAddress4 =3D 600 S. MATHEWS , mailingCityStateZip =3D URBANA, IL > 61801-3602 , shippingAddress1 =3D null , shippingAddress2 =3D null , > shippingAddress3 =3D null , shippingAddress4 =3D null , shippingCityState= Zip =3D > null , phoneNumber =3D null , positionTitle =3D null , createdBy =3D null= , > createdOn =3D null , modifiedBy =3D null , modifiedOn =3D null , conCheck= =3D null'. > Cause: java.lang.NullPointerException > Caused by: java.lang.NullPointerException >=20 > =20 > Here is the result map and sql query: >=20 > =20 > class=3D"scs.reaction.user.beans.UserDetail"> > > > jdbcType=3D"VARCHAR"/> > jdbcType=3D"VARCHAR"/> > jdbcType=3D"VARCHAR"/> > jdbcType=3D"VARCHAR"/> > jdbcType=3D"VARCHAR"/> > jdbcType=3D"VARCHAR"/> > jdbcType=3D"VARCHAR"/> > jdbcType=3D"VARCHAR"/> > jdbcType=3D"VARCHAR"/> > column=3D"SHIPPING_CITY_STATE_ZIP" jdbcType=3D"VARCHAR"/> > > jdbcType=3D"VARCHAR"/> > > > > > > >=20 > > > > > > >=20 > =20 > resultMap=3D"user-detail-result" cacheModel=3D"user-detail-cache"> > SELECT * FROM REACTION_USERS.USER_DETAILS > =20 > > > USER_ID=3D#userID# > > =20 > > PRINTED_NAME=3D#printedName# > > =20 > > =20 > MAILING_ADDRESS_1=3D#mailingAddress1# > > =20 > > =20 > MAILING_ADDRESS_2=3D#mailingAddress2# > > =20 > > =20 > MAILING_ADDRESS_3=3D#mailingAddress3# > > =20 > > =20 > MAILING_ADDRESS_4=3D#mailingAddress4# > > =20 > > =20 > MAILING_CITY_STATE_ZIP=3D#mailingCityStateZip# > > =20 > > =20 > SHIPPING_ADDRESS_1=3D#shippingAddress1# > > =20 > > =20 > SHIPPING_ADDRESS_2=3D#shippingAddress2# > > =20 > > =20 > SHIPPING_ADDRESS_3=3D#shippingAddress3# > > =20 > > =20 > SHIPPING_ADDRESS_4=3D#shippingAddress4# > > =20 > property=3D"shippingCityStateZip"> > =20 > SHIPPING_CITY_STATE_ZIP=3D#shippingCityStateZip# > > =20 > > PHONE_NUMBER=3D#phoneNumber# > > =20 > > POSITION_TITLE=3D#positionTitle# > > =20 > > CREATED_BY=3D#createdBy# > > =20 > > CREATED_ON=3D#createdOn# > > =20 > > MODIFIED_BY=3D#modifiedBy# > > =20 > > MODIFIED_ON=3D#modifiedOn# > > =20 > > CON_CHECK=3D#conCheck# > > > =20 > ORDER BY PRINTED_NAME > =20 > >=20 > =20 > 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 ar= e > the shipping address fields. All other fields have data. >=20 > =20 > Any ideas? I am betting with myself that it is something simple that I > keep overlooking when I go through the code. >=20 > Thanks.