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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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. > > > > >
