ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sundar Sankar <fatboys...@gmail.com>
Subject Re: aBator does not create getter and setter for new column in table
Date Thu, 19 Feb 2009 19:20:24 GMT
Wow,
Jeff, is there an order of schema that Ibator does or does it leave that to
the database to handle it?

On Thu, Feb 19, 2009 at 12:08 PM, Jeff Butler <jeffgbutler@gmail.com> 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.
> >
> >
>

Mime
View raw message