From torque-user-return-4327-apmail-db-torque-user-archive=db.apache.org@db.apache.org Tue Mar 02 09:31:37 2004 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 70657 invoked from network); 2 Mar 2004 09:31:37 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 2 Mar 2004 09:31:37 -0000 Received: (qmail 85788 invoked by uid 500); 2 Mar 2004 09:31:10 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 85596 invoked by uid 500); 2 Mar 2004 09:31:09 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 85571 invoked from network); 2 Mar 2004 09:31:08 -0000 Received: from unknown (HELO terragate.net) (217.160.133.107) by daedalus.apache.org with SMTP; 2 Mar 2004 09:31:08 -0000 Received: by terragate.net (Postfix, from userid 1016) id 44041142D9; Tue, 2 Mar 2004 10:31:21 +0100 (CET) Received: from terragate.net (dsl-082-083-116-208.arcor-ip.net [82.83.116.208]) by terragate.net (Postfix) with ESMTP id EFBCD142D8 for ; Tue, 2 Mar 2004 10:31:19 +0100 (CET) Message-ID: <404455A3.7050602@terragate.net> Date: Tue, 02 Mar 2004 10:36:35 +0100 From: =?ISO-8859-1?Q?Tomasz_Dre=DFler?= User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Apache Torque Users List Subject: Re: R: deep collection possible? References: <20040301224147.E2080142D8@terragate.net> In-Reply-To: <20040301224147.E2080142D8@terragate.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on terragate.net X-Spam-Status: No, hits=-4.9 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.60 X-Spam-Level: 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 Good Morning Luca and Dale! Thank you for your help. It works now :) Greetings Tomek Luca Zappa wrote: >Foreign key is declared in 'file' table so in the class BaseFilePeer you >have the method: >protected static List doSelectJoinServer(Criteria c) > >As Dale said you need to add a wrapper method in FilePeer to call that >protected method. > >public static java.util.List >doSelectJoinServer(org.apache.torque.util.Criteria c) throws >org.apache.torque.TorqueException { > return BaseFilePeer.doSelectJoinServer(c); >} > >Bye, >Luca > > > >-----Messaggio originale----- >Da: Tomasz Dreßler [mailto:tdress@terragate.net] >Inviato: lunedì 1 marzo 2004 21.36 >A: Apache Torque Users List >Oggetto: Re: deep collection possible? > >Hi Thoms! Thanks for reply. >My BaseServerPeer.java does not contain such protected method. >Out of necessity I call the getFiles(crit) method from each server object. >Maybe the Problem is in schema.xml ? > >Greetings >Tomasz > >[--- schema.xml ---] > > required="true" type="VARCHAR" size="255" > description="Server Adresse" /> > required="true" type="VARCHAR" > size="128" description="Server Name" /> >
> > > type="INTEGER" autoIncrement="true" > description="File ID" /> > type="VARCHAR" size="255" > description="FK Server Adresse" /> > type="LONGVARCHAR" > description="File Pfad" /> > type="VARCHAR" size="255" > description="File Name" /> > > > >
> > >Dale Thoms wrote: > > > >>Hi Tomasz, >> >>There should be a protected method in your BaseServerPeer.java called >>doSelectJoinFile(crit) that will fill in the File objs in the Servers. >>You'll need to make a public wrapper method for it in ServerPeer.java, >>so you can then call ServerPeer.doSelectJoinFile(crit). >> >> Dale >> >> >> >>On Sun, 29 Feb 2004 23:26:04 +0100, "Tomasz Dreßler" >> said: >> >> >> >> >>>Hi! >>>I have two tables 'server' and 'file'. >>>Without torque I used the query: >>>SELECT server.serverAdress, server.serverName, file.filePath, >>>file.fileName FROM server, file WHERE >>>server.serverAdress=file.serverAdress >>>AND file.fileName like '%search%' >>> >>>I wish that ServerPeer.doSelect(crit) returns a collection of servers. >>>Each server should include the file objects belong to that server. >>> >>>I just get the server without the file objects. >>> >>>Thanks, >>>Tomasz Dreßler >>> >>> >>> >>> >>> >>> >>>--------------------------------------------------------------------- >>>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org >>>For additional commands, e-mail: torque-user-help@db.apache.org >>> >>> >>> >>> >>> >>> >>--------------------------------------------------------------------- >>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org >>For additional commands, e-mail: torque-user-help@db.apache.org >> >> >> >> >> >> > >--------------------------------------------------------------------- >To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org >For additional commands, e-mail: torque-user-help@db.apache.org > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org >For additional commands, e-mail: torque-user-help@db.apache.org > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org