Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
  b=hh5t59F/o/yvqSXffF0vW7u20EAyK1Gjc3EUf35Sm8PhpuTRflxK44lOpQd0HM0U0k2840B+mazbiYyGpYu6SAsiMacQ5pxNMgNWfEx5VbWKGa0BQL5DRg/KICle32gqkAkXLFO9rkEyrMxfBSGC8K8A89zmYMwXRuDIA5gYH0Y=;
Date: Fri, 17 Aug 2007 14:48:29 -0700 (PDT)
From: Robert Glover <robertgloverjr@yahoo.com>
Subject: Can anyone offer help on  "There is no WRITEABLE property named
 'lName'"
To: user-java@ibatis.apache.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <523333.69214.qm@web30803.mail.mud.yahoo.com>

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;
    }