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
: Thursday, May 20, 2004 2:10 PM To: [EMAIL PROTECTED] Subject: How to use DUAL table for multiple types of queries I posted this yesterdayWould someone PLEASE help me. Am running out of time. We use Oracle 9 and have several different functions we can call. In OJB, they are all mapped with the

How to use DUAL table for multiple types of queries

2004-05-20 Thread Glenn Barnard
I posted this yesterdayWould someone PLEASE help me. Am running out of time. We use Oracle 9 and have several different functions we can call. In OJB, they are all mapped with the table name of DUAL. For example: SELECT function(args) AS column FROM DUAL Our repository.xml has a table e

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

How to use DUAL table for multiple types of queries

2004-05-19 Thread Glenn Barnard
We use Oracle 9 and have several different functions we can call. In OJB, they are all mapped with the table name of DUAL. For example: SELECT function(args) AS column FROM DUAL Our repository.xml has a table entry for each function so that the result is kept in it's own class. For example