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

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 Glenn Barnard
Andrew, thanks for the quick response. Unfortunately, we're already using a ReportQuery. Here's the code snippet calling OJB: String[] columns = { ypas.f_GetRotationDate ( + listingId + , + locationId + ,' + zuluStartDate + ') rotationDate };

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 row