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 <viv...@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 <viv...@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 <viv...@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 <viv...@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. > >