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: aBator does not create getter and setter for new column in table
Date Thu, 19 Feb 2009 19:08:48 GMT
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.
>
>

Mime
View raw message