ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sanv <viv...@gmx.at>
Subject Re: aBator does not create getter and setter for new column in table
Date Fri, 20 Feb 2009 09:08:19 GMT

thanks for this info. 

Sundar Sankar wrote:
> 
> This is something I pulled out of google. I havent worked much on abator.
> Guys correct me if I have misguided Vivek here.
> 
> http://ibatis.apache.org/docs/tools/ibator/configreference/table.html
> Example
> 
> This element specifies that we always want to generate code for a table
> called MYTABLE in schema MYSCHEMA. We also want to ignore a column called
> "fred" in the table, and we want to override the column "BEG_DATE" so that
> the generated property name will be "startDate".
> 
> <table tableName="MYTABLE" schema="MYSCHEMA">
>   <ignoreColumn column="fred"/>
>   <columnOverride column="BEG_DATE" property="startDate"/>
> </table>
> 
> 
> 
> On Thu, Feb 19, 2009 at 12:20 PM, sanv <viveks@gmx.at> wrote:
> 
>>
>> The database is running on my local machine. If I log into the Web UI and
>> check out the table it only appears once? Sorry for this question, how
>> can
>> I
>> specify the schema in the config file?
>>
>>
>> Jeff Butler-2 wrote:
>> >
>> > This means that there are two versions of the table (in different
>> > schemas).  The versions do not match.  You should probably specify a
>> > schema in the Abator configuration file.  Either that, or talk to your
>> > DBA to resolve the difference between the two tables.
>> >
>> > Jeff Butler
>> >
>> >
>> > On Thu, Feb 19, 2009 at 12:18 PM, sanv <viveks@gmx.at> wrote:
>> >>
>> >> Ah.
>> >> Now in Patch.java.1 the column is there but NOT in Patch.java.2.
>> >>
>> >>
>> >> Jeff Butler-2 wrote:
>> >>>
>> >>> This output does not match the config file you sent earlier - there
>> >>> are more tables listed.  But the interesting thing to me is that each
>> >>> table has two sets of objects generated for it.
>> >>>
>> >>> Please run Abator again, but this time DO NOT specify the -overwrite
>> >>> flag.  You should end up with a Patch.java.1 and Patch.java.2.  See
>> if
>> >>> one of those files has the column in it.
>> >>>
>> >>> Jeff Butler
>> >>>
>> >>>
>> >>> On Thu, Feb 19, 2009 at 11:53 AM, sanv <viveks@gmx.at> wrote:
>> >>>>
>> >>>> These are the warnings:
>> >>>>
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\CustomerDAOImpl.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\CustomerDAO.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\CustomerExample.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\Customer.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\CustomerDAOImpl.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\CustomerDAO.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\CustomerExample.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\Customer.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\PatchDAOImpl.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\PatchDAO.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\PatchExample.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\Patch.java
>> >>>> was
>> >>>> overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\ool\ibatis\dao\PatchDAOImpl.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\PatchDAO.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\PatchExample.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\Patch.java
>> >>>> was
>> >>>> overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\SstUsersDAOImpl.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\SstUsersDAO.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\SstUsersExample.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\SstUsers.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\SstUsersDAOImpl.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\SstUsersDAO.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\SstUsersExample.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\SstUsers.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\RulesInclusionListDAOImpl.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\RulesInclusionListDAO.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\RulesInclusionListExample.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\RulesInclusionList.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\RulesInclusionListDAOImpl.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\RulesInclusionListDAO.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\RulesInclusionListExample.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\RulesInclusionList.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\RulesExclusionListDAOImpl.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\ool\ibatis\dao\RulesExclusionListDAO.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\RulesExclusionListExample.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\RulesExclusionList.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\RulesExclusionListDAOImpl.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\RulesExclusionListDAO.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\RulesExclusionListExample.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\RulesExclusionList.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\StatisticsDAOImpl.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\dao\StatisticsDAO.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\com\tool\ibatis\model\StatisticsExample.java
>> >>>> was overwritten
>> >>>> Existing file
>> >>>>
>> C:\Projects\server\ibatis\src\main\java\comtool\ibatis\model\Statistics.java
>> >>>> was overwritten
>> >>>>
>> >>>> Abator finshed successfully, there were warninigs.
>> >>>>
>> >>>> Jeff Butler-2 wrote:
>> >>>>>
>> >>>>> Thanks - how about the full list of Abator warnings?
>> >>>>>
>> >>>>> Jeff Butler
>> >>>>>
>> >>>>>
>> >>>>> On Thu, Feb 19, 2009 at 11:22 AM, sanv <viveks@gmx.at>
wrote:
>> >>>>>>
>> >>>>>> Well, the problem is that I am developing this project for
a
>> company
>> >>>>>> and
>> >>>>>> their project is based on Abator. Don't know if it's possible
to
>> >>>>>> upgrade
>> >>>>>> to
>> >>>>>> IBator for whatever reasons.
>> >>>>>>
>> >>>>>> Basically, I alter the table through the Web User Interface
>> provided
>> >>>>>> by
>> >>>>>> Oracle XE.
>> >>>>>> If I view the SQL throught the UI I have the following:
>> >>>>>>
>> >>>>>> CREATE TABLE  "PATCH"
>> >>>>>>   (    "PATCHID" NUMBER(*,0) NOT NULL ENABLE,
>> >>>>>>        "TRANSACTIONID" VARCHAR2(15) NOT NULL ENABLE,
>> >>>>>>        "CPA" VARCHAR2(96),
>> >>>>>>        "PROJECTID" VARCHAR2(32) NOT NULL ENABLE,
>> >>>>>>        "PATCHURL" VARCHAR2(256) NOT NULL ENABLE,
>> >>>>>>        "DATE_CREATE" TIMESTAMP (6),
>> >>>>>>        "LAST_MODIFIED" TIMESTAMP (6),
>> >>>>>>        "USERID" NUMBER,
>> >>>>>>        "GLOBAL_REGEXP" VARCHAR2(2),
>> >>>>>>         CONSTRAINT "PATCH_PK" PRIMARY KEY ("PATCHID") ENABLE
>> >>>>>>   )
>> >>>>>>
>> >>>>>> It is the column GLOBAL_REGEXP that does not get included
in the
>> java
>> >>>>>> classes.
>> >>>>>>
>> >>>>>>
>> >>>>>> Jeff Butler-2 wrote:
>> >>>>>>>
>> >>>>>>> Hmmm...maybe I owe you a Pepsi :)
>> >>>>>>>
>> >>>>>>> I'd like to see the full table definition (the create
table
>> >>>>>>> statement), and the full list of warnings from Abator.
>> >>>>>>>
>> >>>>>>> Also, Abator is really at end of life.  I'd like you
to upgrade
>> to
>> >>>>>>> Ibator for these reasons:
>> >>>>>>>
>> >>>>>>> 1. Perhaps the bug is already fixed in Ibator
>> >>>>>>> 2. If we find a bug, it will only be fixed in Ibator
>> >>>>>>> 3. The upgrade is very simple
>> >>>>>>> 4. I'll be adding some logging to Ibator to make it
easier to
>> debug
>> >>>>>>> these kinds of issues
>> >>>>>>>
>> >>>>>>> Jeff Butler
>> >>>>>>>
>> >>>>>>>
>> >>>>>>> On Thu, Feb 19, 2009 at 5:46 AM, sanv <viveks@gmx.at>
wrote:
>> >>>>>>>>
>> >>>>>>>> After debugging it further I found out that the
column is in the
>> >>>>>>>> result
>> >>>>>>>> set
>> >>>>>>>> but however does not get add to the "column" list.
>> >>>>>>>> ....
>> >>>>>>>>
>> >>>>>>>> sanv wrote:
>> >>>>>>>>>
>> >>>>>>>>> Hi,
>> >>>>>>>>>
>> >>>>>>>>> I have just debugged the code as you mentioned
by adding the
>> >>>>>>>>> abator
>> >>>>>>>>> source.
>> >>>>>>>>> Surprisingly, the column is in the resultset
when I debug the
>> >>>>>>>>> code.
>> >>>>>>>>> I
>> >>>>>>>>> debugged the code and checked the ColumnDefinition
cd
>> specifically
>> >>>>>>>>> if
>> >>>>>>>>> the
>> >>>>>>>>> actualColumnName is set, and it is.
>> >>>>>>>>>
>> >>>>>>>>> I am puzzled?
>> >>>>>>>>>
>> >>>>>>>>>
>> >>>>>>>>>
>> >>>>>>>>>
>> >>>>>>>>> Jeff Butler-2 wrote:
>> >>>>>>>>>>
>> >>>>>>>>>> Alternatively, you could actually debug
the problem and find
>> out
>> >>>>>>>>>> where
>> >>>>>>>>>> the error lies :)
>> >>>>>>>>>>
>> >>>>>>>>>> As I stated earlier, place a breakpoint
in the getColumns()
>> >>>>>>>>>> method
>> >>>>>>>>>> -
>> >>>>>>>>>> then watch as the column information for
the table is returned
>> >>>>>>>>>> from
>> >>>>>>>>>> the database.  I'm willing to bet a virtual
Pepsi that the
>> column
>> >>>>>>>>>> information is never returned from the database.
>> >>>>>>>>>>
>> >>>>>>>>>> Jeff Butler
>> >>>>>>>
>> >>>>>>>
>> >>>>>>
>> >>>>>> --
>> >>>>>> View this message in context:
>> >>>>>>
>> http://www.nabble.com/aBator-does-not-create-getter-and-setter-for-new-column-in-table-tp22033078p22104836.html
>> >>>>>> Sent from the iBATIS - User - Java mailing list archive
at
>> >>>>>> Nabble.com.
>> >>>>>>
>> >>>>>>
>> >>>>>
>> >>>>>
>> >>>>
>> >>>> --
>> >>>> View this message in context:
>> >>>>
>> http://www.nabble.com/aBator-does-not-create-getter-and-setter-for-new-column-in-table-tp22033078p22106033.html
>> >>>> Sent from the iBATIS - User - Java mailing list archive at
>> Nabble.com.
>> >>>>
>> >>>>
>> >>>
>> >>>
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/aBator-does-not-create-getter-and-setter-for-new-column-in-table-tp22033078p22106595.html
>> >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/aBator-does-not-create-getter-and-setter-for-new-column-in-table-tp22033078p22107799.html
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
> 
> 

-- 
View this message in context: http://www.nabble.com/aBator-does-not-create-getter-and-setter-for-new-column-in-table-tp22033078p22117229.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message