Re: deep collection possible?

[Tomasz Dre�ler]

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]