RE: problems with doSelectAll(); in the tutorial

2004-06-22 Thread Luca Zappa
)) instead of doSelectAll(). So this line: List booklist = BookPeer.doSelectAll(); Will be: List booklist = BookPeer.doSelect(new Criteria()); Regards, Luca ___ Luca Zappa [EMAIL PROTECTED] www.lucazappa.com -Original Message- From: Aldo Luis Aguirre [mai

RE: sql translation

2004-03-17 Thread Luca Zappa
Hi Guo, can you send us the xml schema of your db? If you define correctly foreing keys, that query is just implemented. Otherwise you can use Critera: Criteria c = new Criteria(); c.addJoin(Table1Peer.PUBLISHER_ID,Table2Peer.PUBLISHER_ID); List rows = BasePeer.doSelect(c); Regards, Luca --

Re: How to config multi database in torque?

2004-03-17 Thread Luca Zappa
http://wiki.apache.org/db-torque/GettingTorqueToWork#head-90543a42ebb9d6 e6a7c8b6aea4e65cb594cd583f 7. Using Torque with multiple databases -Original Message- From: "errise" <[EMAIL PROTECTED]> Sent: Wednesday, 17. Mar 2004 8:23 +0100 To: <[EMAIL PROTECTED]> Subject: How to config multi

RE: Generated class problem

2004-03-13 Thread Luca Zappa
Hi Nathan, I have genereted (without Maven) your simple schema with Torque 3.1 and the two methods are included in BaseOrder class (see the attachment). public Customer getCustomer() throws TorqueException public void setCustomer(Customer v) throws TorqueException Regards, Luca -Origina

RE: How do I use the feature onUpdate="cascade" with Torque?

2004-03-07 Thread Luca Zappa
ubject: Re: How do I use the feature onUpdate="cascade" with Torque? Hi Luca Zappa! I know, with your solution my problem will disappeare. But this meens a lot of work for me ... Thank you for reply! Greetings Tomek Luca Zappa wrote: >If you need to update the serverAdress in the &#x

RE: How do I use the feature onUpdate="cascade" with Torque?

2004-03-04 Thread Luca Zappa
If you need to update the serverAdress in the 'server' table I think it's a better solution if you don't use this field as a primary key. You can add a SERVER_ID for primary key, and then you'll be able to update serverAdress and no changes are needed in the 'file' table. [ sch

RE: autoincrement of non primary key

2004-03-04 Thread Luca Zappa
>> >> >> >> >> > > Will that make the group of them unique, or each one? Hi Dave, the group of this 3 columns will be unique. Bye   Luca -Original Message- From: Dave Newton <[EMAIL PROTECTED]> Sent: Thursday, 4. Mar 2004 14:37 +0100 To: Apache Torque Users List <[EMAIL PROTECTED]

RE: java.sql.SQLException: Unable to connect to any hosts due to exception: Connection rejected

2004-03-03 Thread Luca Zappa
Hi Frank, tell us more about build.properties, there is probably some mistakes in the torque.database.createUrl property. It must be something like this: torque.database.createUrl = jdbc:mysql://127.0.0.2/mysql You must specify an existent database in createUrl (mysql). Bye Luca -Origina

Re: Informix and Torque

2004-03-02 Thread Luca Zappa
No experience with Informix, but the adapter is included: org.apache.torque.adapter.DBInformix -Original Message- From: "Giulio Vezzelli" <[EMAIL PROTECTED]> Sent: Tuesday, 2. Mar 2004 10:52 +0100 To: <[EMAIL PROTECTED]> Subject: Informix and Torque Someone has experience of running

R: deep collection possible?

2004-03-01 Thread Luca Zappa
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

Re: Id method native "How to"?

2004-03-01 Thread Luca Zappa
You can specify the sequence name with id-method-parameter tag inside the table defination: Example:                                                 -Original Message- From: Edwin Yearwood <[EMAIL PROTECTED]> Sent: Monday, 1. Mar 2004 16:37 +0100 To: [EMAIL PROT

Re: Id method native "How to"?

2004-03-01 Thread Luca Zappa
You can specify the sequence name with id-method-parameter tag inside the table defination: Example:                                                 -Original Message- From: Edwin Yearwood <[EMAIL PROTECTED]> Sent: Monday, 1. Mar 2004 16:37 +0100 To: [EMAIL PROT