Return-Path: 
 <torque-user-return-4192-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 55522 invoked from network); 18 Feb 2004 10:57:10 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 18 Feb 2004 10:57:10 -0000
Received: (qmail 47060 invoked by uid 500); 18 Feb 2004 10:56:41 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 47046 invoked by uid 500); 18 Feb 2004 10:56:41 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Subscribe: <mailto:torque-user-subscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 47032 invoked from network); 18 Feb 2004 10:56:41 -0000
Received: from unknown (HELO dd1212.kasserver.com) (81.209.148.146)
  by daedalus.apache.org with SMTP; 18 Feb 2004 10:56:41 -0000
Received: from netseeker1 (pD9518403.dip.t-dialin.net [217.81.132.3])
	by dd1212.kasserver.com (Postfix) with SMTP id 1A77059ECA
	for <torque-user@db.apache.org>; Wed, 18 Feb 2004 11:56:52 +0100 (CET)
From: "netseeker" <netseeker@manskes.de>
To: "Apache Torque Users List" <torque-user@db.apache.org>
Subject: RE: please help with complexObjectModel
Date: Wed, 18 Feb 2004 11:56:53 +0100
Message-ID: <JMEFJKCNGFPDCJMMDIKFOECLCIAA.netseeker@manskes.de>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
In-Reply-To: <40334119.6040806@tacisenergy.org.ua>
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Hi Eugene,

I guess your column is named exactly as the related table, eg. foreign
column name ="SomeTable" and related table name="SomeTable". With complex
object model torque tries to generate two methods: one to retrieve the
column value and
another one to retrieve the related table object(s). Just rename your
column, eg. column name="test_id" and you will
get the following two methods: "getTestId()" for the value and "getTest()"
for the related object.
Foreign keys should be never named exacly as the related table.

Wrong:
    <table name="SomeTable">
        <column name="AnotherTable" size="8" type="DECIMAL"/>
	  ...
        <foreign-key foreignTable="AnotherTable">
            <reference foreign="AnotherTable" local="AnotherTable"/>
        </foreign-key>
    </table>

    <table name="AnotherTable">
        <column name="AnotherTable" primaryKey="true" required="true"
            size="8" type="DECIMAL"/>
        ...
    </table>

Right:
    <table name="SomeTable">
        <column name="AnotherTableId" size="8" type="DECIMAL"/>
	  ...
        <foreign-key foreignTable="AnotherTable">
            <reference foreign="AnotherTableId" local="AnotherTableId"/>
        </foreign-key>
    </table>

    <table name="AnotherTable">
        <column name="AnotherTableId" primaryKey="true" required="true"
            size="8" type="DECIMAL"/>
        ...
    </table>


so long
Michael

> -----Original Message-----
> From: E.Nebrat [mailto:e.nebrat@tacisenergy.org.ua]
> Sent: Wednesday, February 18, 2004 11:40 AM
> To: torque-user@db.apache.org
> Subject: please help with complexObjectModel
>
>
> Hi,
> could you help me and explain why it happens?
> I use torque-gen-3.1 from binaries.
> There is a table for SomeObject in the schema-definition, which has
> foreign key on the one column. When I set complexObjectModel to true (as
> I would like to), generator produces corresponding  BaseSomeObject.java
> with as much as two (not one?)  methods for getting this column value:
> int getSomeValue()
> and
> SomeValueType getSomeValue()
> consequently, I cannot compile this. How could I manage this?
> Thank you very much for help, and excuse for obviously stupid question.
>
> --
> BR, Eugene Nebrat.
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.591 / Virus Database: 374 - Release Date: 17.02.2004
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.591 / Virus Database: 374 - Release Date: 17.02.2004


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org