Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of clinton.begin@gmail.com
 designates 209.85.198.188 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:from:to:references:in-reply-to:subject:date:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:content-language:message-id;
        b=CsFFYJBNvwN6DJ0GVrXsW+SfbvCtXGTZ+ig2jB2dIAs1Ed6vsWDwoA+3IOAuB96/Z7Ait6biQIY2+I2goDQ5ED9A616ncSD53tNdiDRkTnrys/sE7Ad02gW2KOs+0jlQiUFppEQMx/u54YnzlPRzyzztYTB10AqTp5vNcY65xEw=
From: "Clinton Begin" <clinton.begin@gmail.com>
To: <user-java@ibatis.apache.org>
References: <523333.69214.qm@web30803.mail.mud.yahoo.com>
In-Reply-To: <523333.69214.qm@web30803.mail.mud.yahoo.com>
Subject: RE: Can anyone offer help on  "There is no WRITEABLE property named
 'lName'"
Date: Fri, 17 Aug 2007 16:33:12 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcfhGGtbsLkgjc+BRse2CnQyI+5cbQABeadA
Content-Language: en-ca
Message-ID: <46c62246.03b48c0a.5e06.2f9a@mx.google.com>

The property name would be LName.

Javabeans is a screwy spec.  Thanks to the capitalization rules, if you have
two uppercase letters at the beginning of a property name, it doesn't change
the case.

<rant>
God forbid they just leave the damn capitalization as it is typed in the
first place.  Would TitleCase properties have killed us all?
</rant>

Does anyone think iBATIS 3 should be completely case insensitive in this
regard?  Really, do you ever have a need to differentiate two properties
only by case?

Clinton

-----Original Message-----
From: Robert Glover [mailto:robertgloverjr@yahoo.com] 
Sent: August-17-07 3:48 PM
To: user-java@ibatis.apache.org
Subject: Can anyone offer help on "There is no WRITEABLE property named
'lName'"

I'm at my wits end, tearing my hair out over this problem.
I use Abator to generate all my IBatis classes and XML.

When my Spring web app starts up I get this error:

Error parsing XPath '/sqlMap/resultMap/result'.
Cause: com.ibatis.common.beans.ProbeException:
There is no WRITEABLE property named 'lName' in class
'frb.bsd.abator.domain.IavAssetInfo2'

I have 27 tables, so I tried commenting out the offending table to see what
would happen then.  What happened is I got the same error but on a different
table.  That different table also had an "lName" property.

I did a lot of google-ing and most times this problem  is because manually
created iBatis XML has the wrong capitalization.  But I did not write any of
this, abator did.

   The offending tables have underscores in their table name, which Abator
removes.  I don't think that is it.  However in addition to that, the column
names in the tables have underscores.  The offending field, "lName", is
actually defined in the Oracle 10g database as "L_NAME".

    The abator generated set statements look okay to me. Here is one of
them. I
don't see how this would cause the problem, so I'm at my wits end.

    /**
     * This method was generated by Abator for iBATIS.
     * This method sets the value of the database column
ATADMIN.IAV_ASSET_INFO2.L_NAME
     *
     * @param lName the value for ATADMIN.IAV_ASSET_INFO2.L_NAME
     *
     * @abatorgenerated Fri Aug 17 15:06:09 EDT 2007
     */
    public void setLName(String lName) {
        this.lName = lName;
    }