RE: How to use DUAL table for multiple types of queries

2004-05-20 Thread Glenn Barnard
); From: "Clute, Andrew" <[EMAIL PROTECTED]> Reply-To: "OJB Users List" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Subject: RE: How to use DUAL table for multiple types of queries Date: Thu, 20 May 2004 14:34:21 -0400 Based on looking i

Re: How to use DUAL table for multiple types of queries

2004-05-20 Thread Charles N. Harvey III
The only way that I can see is the one in tutorial 3. You have to add a column to DUAL called "CLASS_NAME" specifying which class that row belongs to. http://db.apache.org/ojb/tutorial3.html#Mapping%20All%20Classes%20on%20the%20Same%20Table Charlie Glenn Barnard said the following on 5/20/2004

RE: How to use DUAL table for multiple types of queries

2004-05-20 Thread Clute, Andrew
Based on looking in org.apache.ojb.broker.accesslayer.sql.SqlSelectStatement.getStatement() -- it looks like if no columns are specified, then it will do the multimapped object select, which you are seeing. It is clearer as what to do in the HEAD version, but in RC5, it looks like if you change it

Re: How to use DUAL table for multiple types of queries

2004-05-19 Thread Armin Waibel
Hi Glenn, > I thought that by specifiying the class name I wanted (e.g., Class1) > that OJB would only get the fields for that class. Can anyone advise me > how I can do this without resorting to having only one class for a > function calls? In the DUAL table is no information instruct OJB which ro