Re: aBator does not create getter and setter for new column in table

2009-02-20 Thread sanv
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

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread sanv
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

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread sanv
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

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread Larry Meadors
What's the name of the column? Larry

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread Jeff Butler
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

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread sanv
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

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread sanv
The name of the column is GLOBAL_REGEXP and of type VARCHAR2. Larry Meadors wrote: What's the name of the column? Larry -- View this message in context: http://www.nabble.com/aBator-does-not-create-getter-and-setter-for-new-column-in-table-tp22033078p22104804.html Sent from the

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread Jeff Butler
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

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread sanv
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

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread Jeff Butler
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

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread sanv
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

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread Jeff Butler
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

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread Sundar Sankar
Wow, Jeff, is there an order of schema that Ibator does or does it leave that to the database to handle it? On Thu, Feb 19, 2009 at 12:08 PM, Jeff Butler jeffgbut...@gmail.com wrote: This means that there are two versions of the table (in different schemas). The versions do not match. You

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread sanv
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

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread Sundar Sankar
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

Re: aBator does not create getter and setter for new column in table

2009-02-19 Thread Jeff Butler
See here for full details: http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html#getColumns(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String) The JDBC driver returns columns ordered by schema and then table name. When no schema is specified in the

Re: aBator does not create getter and setter for new column in table

2009-02-18 Thread sanv
Is there any other workaround to this problem. I am kind of stuck... I need that column in the table :-D Thanks in advance. Jeff Butler-2 wrote: Write a Java program that does this: public static void main(String[] args) { String[] abArgs = {-configfile, config.xml, -overwrite};

Re: aBator does not create getter and setter for new column in table

2009-02-18 Thread Nicholoz Koka Kiknadze
Add it manually :) Yours is such a weird problem, some unique combination of some circumstances. I bet there's some no-framework related problem, both iBatis and iBator are so simple or rather transparent (like everything genial) On Wed, Feb 18, 2009 at 4:41 PM, sanv viv...@gmx.at wrote: Is

Re: aBator does not create getter and setter for new column in table

2009-02-18 Thread sanv
If I add them manually that would mean I have to add them in which files? In the java files and in the xml files for the sql code? Nicholoz Koka Kiknadze wrote: Add it manually :) Yours is such a weird problem, some unique combination of some circumstances. I bet there's some no-framework

Re: aBator does not create getter and setter for new column in table

2009-02-18 Thread Jeff Butler
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

Re: aBator does not create getter and setter for new column in table

2009-02-18 Thread Sundar Sankar
If you do search for How to debug for your IDE on google, You would get an idea on how debugging has to be done. It is very simple and am guessing you didnt do it right. The program execution would stop in your breakpoint and you could check for values of variables, method returns etc and see how

Re: aBator does not create getter and setter for new column in table

2009-02-17 Thread sanv
Hi, I have written the code and tried to debug it. It shows me the same output that I had on the console. All the files were overwritten and Abator finshed successfully, there were warninigs.. Is there anything specific that I should check? thanks. Jeff Butler-2 wrote: Write a Java

aBator does not create getter and setter for new column in table

2009-02-16 Thread sanv
Hi, I have a (old) version of abator running for my project. For some reason when i add a new column to a specific table in my db and compile the java classes the new column does not get added to the corresponding java class. however, if i add a new column to another table in the same database

Re: aBator does not create getter and setter for new column in table

2009-02-16 Thread Jeff Butler
Not much to go on here - we probably need more information. Some questions... 1. Are you sure the classes are regenerated (the comment timestamp will help you know for sure)? 2. Are you sure the new field is added to the table in the correct schema? 3. What is the data type of the new field? 4.

Re: aBator does not create getter and setter for new column in table

2009-02-16 Thread sanv
1. The classes are regenerated and the timestamp is also updated. 2. The new field is added. 3. I have tried using different datatypes (Oracle: VARCHAR2, CHAR and NUMBER) 4. There are warnings, but how can I display the warnings? thanks in advance. Jeff Butler-2 wrote: Not much to go on

Re: aBator does not create getter and setter for new column in table

2009-02-16 Thread Jeff Butler
Warnings are displayed differently depending on how you run Abator... 1. They could be written to System.out if you are running from the command line 2. They can be logged to the Ant console if you are using Ant 3. They will be displayed in the completion dialog box if you are running in Eclipse

Re: aBator does not create getter and setter for new column in table

2009-02-16 Thread sanv
If I run the following command in the command line: java -jar abator.jar -configfile config.xml -overwrite I get an output saying the files were overwritten: Existing file C:\server\ibatis\src\main\java\com\tool\ibatis\model\Statistics.java was overwritten Abator finshed successfully, there were

Re: aBator does not create getter and setter for new column in table

2009-02-16 Thread Jeff Butler
The only warning is that Statistics.java was overwritten. It is a mystery. Could we see your config.xml? Jeff Butler On Mon, Feb 16, 2009 at 10:51 AM, sanv viv...@gmx.at wrote: If I run the following command in the command line: java -jar abator.jar -configfile config.xml -overwrite I get

Re: aBator does not create getter and setter for new column in table

2009-02-16 Thread sanv
Sorry, the only warning is not just Statistics.java but also for the other files. But I didnt paste them in all as they are all the same. The config.xml is the following: ?xml version=1.0 encoding=UTF-8? !DOCTYPE abatorConfiguration PUBLIC -//Apache Software Foundation//DTD Abator for iBATIS

Re: aBator does not create getter and setter for new column in table

2009-02-16 Thread Jeff Butler
I'm stumped - sorry. If there are no warnings about unsupported data types, then my best guess is that the column got added to a table that is not in the schema being queried by Abator. Since you don't specify a schema anywhere, Abator is looking in the default schema for this connection. I'd

Re: aBator does not create getter and setter for new column in table

2009-02-16 Thread Jeff Butler
Write a Java program that does this: public static void main(String[] args) { String[] abArgs = {-configfile, config.xml, -overwrite}; AbatorRunner.main(abArgs); } Compile it in an IDE, set the break point, off to the races. Jeff Butler On Mon, Feb 16, 2009 at 5:06 PM, sanv