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

[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 2:09 PM:
I posted this yesterday....Would 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 entry for each function so that the
result is kept in it's own class. For example:
 <class-descriptor
       class="com.business.model.ClassName1"
       table="dual"
       refresh="true"  >
   <field-descriptor id="1"
     name="fieldName1"
     column="fieldName1"
     primarykey="true"
     jdbc-type="VARCHAR"
     nullable="false" />
   </class-descriptor>
and:
 <class-descriptor
       class="com.business.model.ClassName2"
       table="dual"
       refresh="true"  >
   <field-descriptor id="1"
     name="fieldName2"
     column="fieldName2"
     primarykey="true"
     jdbc-type="VARCHAR"
     nullable="false" />
   </class-descriptor>
The problem is that when OJB goes to extract the values from the
result set, it tries to do so for 2 columns, fieldName1 and
fieldName2.
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? Oh, I'm using a customized rc5 and cannot upgrade
until after this release ships (a timing/resource issue).
Thanks ya'll!
_________________________________________________________________
Stop worrying about overloading your inbox - get MSN Hotmail Extra 
Storage! http://join.msn.click-url.com/go/onm00200362ave/direct/01/

---------------------------------------------------------------------
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]