ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sanv <viv...@gmx.at>
Subject Re: aBator does not create getter and setter for new column in table
Date Thu, 19 Feb 2009 09:33:53 GMT

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 <viveks@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 <viveks@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 <viveks@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 <viveks@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 <viveks@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 <viveks@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
<viveks@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.
>>
>>
> 
> 

-- 
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.


Mime
View raw message