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