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.
