This is something I pulled out of google. I havent worked much on abator. Guys correct me if I have misguided Vivek here.
http://ibatis.apache.org/docs/tools/ibator/configreference/table.html Example This element specifies that we always want to generate code for a table called MYTABLE in schema MYSCHEMA. We also want to ignore a column called "fred" in the table, and we want to override the column "BEG_DATE" so that the generated property name will be "startDate". <table tableName="MYTABLE" schema="MYSCHEMA"> <ignoreColumn column="fred"/> <columnOverride column="BEG_DATE" property="startDate"/> </table> On Thu, Feb 19, 2009 at 12:20 PM, sanv <viv...@gmx.at> wrote: > > 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 <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. > >> > >> > > > > > > -- > 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. > >