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 <viv...@gmx.at> 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 <viv...@gmx.at> 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 <viv...@gmx.at> 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 <viv...@gmx.at> 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 <viv...@gmx.at> 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 <viv...@gmx.at> 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 <viv...@gmx.at> 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.
>
>
