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 11:46:41 GMT

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


Mime
View raw message