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 Thu, 19 Feb 2009 19:20:53 GMT

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.


Mime
View raw message