thanks for this info. Sundar Sankar wrote: > > 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 <[email protected]> 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 <[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. >> >> >> >> >> > >> > >> >> -- >> 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. >> >> > >
-- View this message in context: http://www.nabble.com/aBator-does-not-create-getter-and-setter-for-new-column-in-table-tp22033078p22117229.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
