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: [email protected]
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: [email protected]
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
