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 > > > On Wed, Feb 18, 2009 at 4:25 PM, sanv <[email protected]> wrote: >> >> 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 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 <[email protected]> wrote: >>> >>>> >>>> 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"}; >>>> > 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 <[email protected]> wrote: >>>> >> >>>> >> Hi, >>>> >> >>>> >> thanks for your answer. But how can I add the break point? >>>> >> >>>> >> >>>> >> >>>> >> Jeff Butler-2 wrote: >>>> >>> >>>> >>> 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 recommend attaching the Abator source and debugging - put a >>>> >>> breakpoint in the "getColumns" method of >>>> >>> org.apache.ibatis.abator.internal.db.DatabaseIntrospector - you >>>> should >>>> >>> be able to see if the column is returned to Abator from the JDBC >>>> >>> driver. >>>> >>> >>>> >>> Jeff Butler >>>> >>> >>>> >>> >>>> >>> On Mon, Feb 16, 2009 at 11:32 AM, sanv <[email protected]> wrote: >>>> >>>> >>>> >>>> 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 >>>> >>>> Configuration >>>> >>>> 1.0//EN" >>>> >>>> "http://ibatis.apache.org/dtd/abator-config_1_0.dtd";> >>>> >>>> >>>> >>>> <abatorConfiguration> >>>> >>>> <abatorContext id="OracleTables" generatorSet="Java5"> >>>> >>>> <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" >>>> >>>> connectionURL="jdbc:oracle:thin:@127.0.0.1:1521:XE" >>>> >>>> userId="SOME_USER" >>>> >>>> password="some_pwd"> >>>> >>>> <classPathEntry location="ojdbc14.jar" /> >>>> >>>> </jdbcConnection> >>>> >>>> >>>> >>>> <javaTypeResolver > >>>> >>>> <property name="forceBigDecimals" value="false" /> >>>> >>>> </javaTypeResolver> >>>> >>>> >>>> >>>> <javaModelGenerator targetPackage="com.tool.ibatis.model" >>>> >>>> targetProject="ibatis\src\main\java"> >>>> >>>> <property name="enableSubPackages" value="true" /> >>>> >>>> <property name="trimStrings" value="true" /> >>>> >>>> </javaModelGenerator> >>>> >>>> >>>> >>>> <sqlMapGenerator targetPackage="com.tool.ibatis.xml" >>>> >>>> targetProject="ibatis\src\main\resources"> >>>> >>>> <property name="enableSubPackages" value="true" /> >>>> >>>> </sqlMapGenerator> >>>> >>>> >>>> >>>> <daoGenerator type="GENERIC-SI" >>>> targetPackage="com.tool.ibatis.dao" >>>> >>>> targetProject="ibatis\src\main\java"> >>>> >>>> <property name="enableSubPackages" value="true" /> >>>> >>>> </daoGenerator> >>>> >>>> <table tableName="CUSTOMER" > >>>> >>>> <property name="useActualColumnNames" value="true"/> >>>> >>>> <generatedKey column="CaseID" sqlStatement="Select >>>> >>>> caseid_seq.nextval >>>> >>>> from dual"/> >>>> >>>> </table> >>>> >>>> >>>> >>>> <table tableName="PATCH" > >>>> >>>> <property name="useActualColumnNames" value="true"/> >>>> >>>> <generatedKey column="PatchID" sqlStatement="Select >>>> >>>> patchid_seq.nextval from dual"/> >>>> >>>> </table> >>>> >>>> <table tableName="STATISTICS" > >>>> >>>> <property name="useActualColumnNames" value="true"/> >>>> >>>> <generatedKey column="ID" sqlStatement="Select >>>> >>>> statistics_seq.nextval >>>> >>>> from dual"/> >>>> >>>> </table> >>>> >>>> >>>> >>>> </abatorContext> >>>> >>>> </abatorConfiguration> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> Jeff Butler-2 wrote: >>>> >>>>> >>>> >>>>> 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 <[email protected]> wrote: >>>> >>>>>> >>>> >>>>>> 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 warninigs. >>>> >>>>>> >>>> >>>>>> This is all I get. >>>> >>>>>> >>>> >>>>>> thanks >>>> >>>>>> >>>> >>>>>> >>>> >>>>>> Jeff Butler-2 wrote: >>>> >>>>>>> >>>> >>>>>>> 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 >>>> >>>>>>> >>>> >>>>>>> Jeff Butler >>>> >>>>>>> >>>> >>>>>>> >>>> >>>>>>> On Mon, Feb 16, 2009 at 10:33 AM, sanv <[email protected]> wrote: >>>> >>>>>>>> >>>> >>>>>>>> 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 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. Were there any Abator warnings? >>>> >>>>>>>>> >>>> >>>>>>>>> Jeff Butler >>>> >>>>>>>>> >>>> >>>>>>>>> >>>> >>>>>>>>> On Mon, Feb 16, 2009 at 2:12 AM, sanv <[email protected]> wrote: >>>> >>>>>>>>>> >>>> >>>>>>>>>> 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 and compile/build the classes the new >>>> getter >>>> >>>>>>>>>> and >>>> >>>>>>>>>> setter >>>> >>>>>>>>>> method is added to the class. >>>> >>>>>>>>>> >>>> >>>>>>>>>> what could be the problem in this case? >>>> >>>>>>>>>> >>>> >>>>>>>>>> thanks for any help. >>>> >>>>>>>>>> -- >>>> >>>>>>>>>> View this message in context: >>>> >>>>>>>>>> >>>> http://www.nabble.com/aBator-does-not-create-getter-and-setter-for-new-column-in-table-tp22033078p22033078.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-tp22033078p22040640.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-tp22033078p22040983.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-tp22033078p22041937.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-tp22033078p22047468.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-tp22033078p22088891.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-tp22033078p22089692.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-tp22033078p22096799.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
