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]
