Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 74369 invoked from network); 19 Feb 2009 19:21:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 19 Feb 2009 19:21:26 -0000 Received: (qmail 16453 invoked by uid 500); 19 Feb 2009 19:21:24 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 16438 invoked by uid 500); 19 Feb 2009 19:21:24 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 16429 invoked by uid 99); 19 Feb 2009 19:21:24 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Feb 2009 11:21:24 -0800 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Feb 2009 19:21:14 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1LaES5-0007cn-Dv for user-java@ibatis.apache.org; Thu, 19 Feb 2009 11:20:53 -0800 Message-ID: <22107799.post@talk.nabble.com> Date: Thu, 19 Feb 2009 11:20:53 -0800 (PST) From: sanv To: user-java@ibatis.apache.org Subject: Re: aBator does not create getter and setter for new column in table In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: viveks@gmx.at References: <22033078.post@talk.nabble.com> <22040640.post@talk.nabble.com> <22040983.post@talk.nabble.com> <22041937.post@talk.nabble.com> <22047468.post@talk.nabble.com> <22088891.post@talk.nabble.com> <536e8800902181416m53df292ele8b95717070e29f@mail.gmail.com> <22089692.post@talk.nabble.com> <22096799.post@talk.nabble.com> <22098813.post@talk.nabble.com> <22104836.post@talk.nabble.com> <22106033.post@talk.nabble.com> <22106595 .post@talk.nabble.com> X-Virus-Checked: Checked by ClamAV on apache.org 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 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 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 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 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.