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:[EMAIL PROTECTED] 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 ---] <table name="server" description="Server Tabelle" idMethod="none"> <column name="serverAdress" primaryKey="true" required="true" type="VARCHAR" size="255" description="Server Adresse" /> <column name="serverName" required="true" type="VARCHAR" size="128" description="Server Name" /> </table>
<table name="file" description="File Tabelle" idMethod="native"> <column name="fileId" required="true" primaryKey="true" type="INTEGER" autoIncrement="true" description="File ID" /> <column name="serverAdress" required="true" type="VARCHAR" size="255" description="FK Server Adresse" /> <column name="filePath" required="true" type="LONGVARCHAR" description="File Pfad" /> <column name="fileName" required="true" type="VARCHAR" size="255" description="File Name" /> <foreign-key foreignTable="server" onUpdate="cascade"> <reference local="serverAdress" foreign="serverAdress"/> </foreign-key> </table>
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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
