Return-Path: 
 <user-java-return-18905-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 24823 invoked from network); 16 Mar 2010 23:12:33 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 16 Mar 2010 23:12:33 -0000
Received: (qmail 7296 invoked by uid 500); 16 Mar 2010 23:12:32 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 7196 invoked by uid 500); 16 Mar 2010 23:12:32 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 7189 invoked by uid 99); 16 Mar 2010 23:12:32 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Mar 2010 23:12:32 +0000
X-ASF-Spam-Status: No, hits=1.0 required=10.0
	tests=FORGED_YAHOO_RCVD,FREEMAIL_FROM,SPF_HELO_PASS,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Mar 2010 23:12:25 +0000
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1Nrfvg-0000Tj-LD
	for user-java@ibatis.apache.org; Tue, 16 Mar 2010 16:12:04 -0700
Message-ID: <27925843.post@talk.nabble.com>
Date: Tue, 16 Mar 2010 16:12:04 -0700 (PDT)
From: Hermit Geek <HermitGeek@yahoo.com>
To: user-java@ibatis.apache.org
Subject: Composite key problems in column attribute (again)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: HermitGeek@yahoo.com
X-Virus-Checked: Checked by ClamAV on apache.org


I know this has been addressed before but it's still not working for me.

I'm developing an application pro bono for the local community college. It
was mostly working in Ibatis 2 and then when I migrated to 3, my composite
keys would no longer work. I'm currently in Ibatis 3, beta 10. Below is a
portion of my mapper file. The collection property works as expected with a
single parameter (autoID) and a hard coded second parameter for the
composite key as indicated below in the resultMap.

<resultMap id="dsrcStudentResult"    type="studentData" >
        <id property="autoID"                 column="autoid" />
        <result property="activeSemester"    column="activeSemester"/>
        <result property="studentID"        column="studentID"/>
        <result property="lastName"            column="lastname"/>
        <result property="firstName"        column="firstname"/>
        ...
       
        <collection property="disabilityList" javaType="ArrayList"
ofType="String"
            column="autoID" select="getDisabilityList" />
       
    </resultMap>
   
    
     <select id="getDisabilityList"  resultType="java.lang.String">
        SELECT specificdisabilityfkey
             FROM joinDsrcStudentDisability
             WHERE joinDsrcStudentDisability.dsrcStudentFKey = #{id}
             AND semesterFKey = '20081'
             
     </select>   

    <select id="getStudentByAutoID" parameterType="studentQueryParam"
resultMap="dsrcStudentResult" >
        SELECT *, #{activeSemester} AS activeSemester   
        FROM dsrcStudent
        WHERE dsrcStudent.autoID = #{autoID}
     </select>

I changed the column attribute to accommodate composite keys and substitute
the hard coded semesterFKey parameter with #{semester}

        column="{autoID=id,activeSemester=semester}"

        SELECT specificdisabilityfkey
             FROM joinDsrcStudentDisability
             WHERE joinDsrcStudentDisability.dsrcStudentFKey = #{id}
             AND semesterFKey = #{semester}

When the program executes, I get the following error:

### Error querying database.  Cause:
org.apache.ibatis.reflection.ReflectionException: There is no setter for
property named 'autoID' in 'class java.lang.Object'
### The error may involve dsrcdata.getStudentByAutoID-Inline
### The error occurred while setting parameters

Am I doing something wrong, or should I wait for a later release?
Thanks for the help,
James Templer
-- 
View this message in context: http://old.nabble.com/Composite-key-problems-in-column-attribute-%28again%29-tp27925843p27925843.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org