ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Somasundaram Pitchaiah" <psoma....@gmail.com>
Subject Re:There is no WRITEABLE property called 'UserId' in AppUser
Date Fri, 07 Apr 2006 13:43:58 GMT
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!


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

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

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"
   <result column="UserId" property="UserId" jdbcType="BIGINT" />
   <result column="FirstName" property="FirstName" jdbcType="VARCHAR"

a query in that XML;

<select id="abatorgenerated_selectByPrimaryKey"
parameterClass="com.indidge.common.model.idtracksdevices.AppUserKey ">
    select UserId, FirstName,
    from idTracksDevices.AppUser
   where UserId = #UserId#

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!


The property is called 'userId'


-----Original Message-----
From: Somasundaram Pitchaiah [mailto:[EMAIL PROTECTED]
Sent: 06 April 2006 10:53 AM
To: user-java@ibatis.apache.org
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:


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

Files Attached:
-Screenshot .doc(screenshot of the error) -AppUser_Sqlmap.xml -AppUser
-SampleAction.java(action class)

Expecting ur help!

Thank you!


View raw message