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 >> >> >> 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-tp22033078p22098813.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
