ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: There is no WRITEABLE property called 'UserId' in AppUser
Date Fri, 07 Apr 2006 14:34:47 GMT
Somu - I'm glad this fixed your issue.  The next release of Abator will
include a change to avoid this issue in the future.  The change is in SVN
now.

Jeff Butler



On 4/7/06, Somasundaram Pitchaiah <psoma.cse@gmail.com> wrote:
>
> Hi Everybody,
> The issue got resolved by replacing the value:
> <property name="useActualColumnNames" value="true"/>
> by 'false' as suggested by Jeff.
> I was able execute the basic queries select,insert & delete functions.
> I was trying to get the DaoManager instance for almost a week.Now that
> it is resolved.
> A BIG THANKS TO ALL esp Jeff Butler,Poitras Christian & Meindert who
> took their time in responding!
> Thank u once again!
>
> Regards,
> Somu.
> _____________________________________________________________________
>
> I think the issue here is that Abator generated the properties to
> exactly match the column names in the database.  This works well when
> the column names are in all upper case, but not so well otherwise.
> The answer is to regenerate the files, but not let Abator use the
> actual column names as properties.  In your Abator config file, you
> probably have lines like this inside the <table> elements:
>
> <property name="useActualColumnNames" value="true"/>
>
> In your case, you should set this to "false", or just remove the property.
>
> Jeff Butler
>
>
> On 4/6/06, Poitras Christian <[EMAIL PROTECTED]> wrote:
> Both java files have the same class name.One of them should be called
> AppUser.
>
> If I rename the class name of file AppUser.java to AppUser, I cannot
> find the userId property that is required by the resultMap in your java
> class. Did you add this property to generated xml file?
>
> In any case, you must add a userId property to class AppUser and add a
> getter and setter for this property if it doesn't exists.
>
> Hope that helps.
> Christian Poitras
>
>
> -----Original Message-----
> From: Somasundaram Pitchaiah [mailto: [EMAIL PROTECTED]]
> Sent: Thursday, 06 April 2006 11:25
> To: [EMAIL PROTECTED]
> Cc: user-java@ibatis.apache.org
> Subject: RE: There is no WRITEABLE property called 'UserId' in AppUser
>
> Hi meindert,
> I tried replacing UserId by userid in the XML file.but that didn't help.
> It still gives :
> There is no WRITEABLE property named 'DeviceId' in class
> 'com.indidge.common.model.idtracksdevices.AppUser
>
> The error occurs while parsing auto generated
> XML(AppUser_SqlMap.xml).Following are the lines in that xml in the
> resultMap element:
>
> <resultMap id="abatorgenerated_AppUserResult"
> class="com.indidge.common.model.idtracksdevices.AppUser">
>   <result column="UserId" property="UserId" jdbcType="BIGINT" />
>   <result column="FirstName" property="FirstName" jdbcType="VARCHAR"
> />
>
> a query in that XML;
>
> <select id="abatorgenerated_selectByPrimaryKey"
> resultMap="abatorgenerated_AppUserResult"
> parameterClass="com.indidge.common.model.idtracksdevices.AppUserKey ">
>    select UserId, FirstName,
>    from idTracksDevices.AppUser
>   where UserId = #UserId#
> </select>
>
> I need to parse this XML file so as to get the DAOManager Instance.
> I have attached SQlMap.XML,AppUser classes.
>
> Expecting ur help!
>
> Thank You!
>
> Regards,
> Somu
>
>
>
>
> ____________________________________________________________________
> The property is called 'userId'
>
> MEINDERT
>
> -----Original Message-----
> From: Somasundaram Pitchaiah [mailto:[EMAIL PROTECTED]
> Sent: 06 April 2006 10:53 AM
> To: user-java@ibatis.apache.org
> Cc: [EMAIL PROTECTED]
> Subject: There is no WRITEABLE property called 'UserId' in AppUser
>
> Hi Every body,
> I'm facing problem while using the auto generated SQLmap files generated
> by abator in eclipse.
>
> I'm using abator plugin for eclipse(3.1) Given a table AppUser,abator
> generates the following  classes automatically:
>
> -AppUserDAO
> -AppUserImpl
> -AppUser_Sqlmap.xml
>
> I'm trying to use these classes to insert & select some values from Db
> for AppUser table.
>
> The error I get is that it gives"there is no WRITEABLE property called
> UserId in AppUser.This happens while trying to read AppUser_Sqlmap.xml.
> But I have the getter & setter method for the field 'Userid' in AppUser
> class(auto-generated).
>
> Files Attached:
> -Screenshot .doc(screenshot of the error) -AppUser_Sqlmap.xml -AppUser
> -SampleAction.java(action class)
>
> Expecting ur help!
>
> Thank you!
>
> Regards,
> Somu
>

Mime
View raw message