Re: [castor-dev] CALL SQL and One to Many relationships problem

[Brett Cherrington]

My statement is standard SQL...! (Perhaps not a great example though)   CALL SQL SELECT id, a, b FROM dev.object AS myObject   id, a, b - are column names dev.object - is the table name myObject - is my class name   ----- Original Message ----- From: Rangan N Chakravarthy To: [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 4:15 PM Subject: Re: [castor-dev] CALL SQL and One to Many relationships problem Wouldnt you be using Standard SQL instead of OQL when you use CALL.   Usually it is CALL SQL select * from emp as <classname> ----- Original Message ----- From: Brett Cherrington To: [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 10:45 AM Subject: [castor-dev] CALL SQL and One to Many relationships problem I have been looking at castor for a while now and have come across the following error(s);   I have a couple of tables that implement a one to many relationship and I am trying to query for it directly using CALL SQL   my mapping is as follows: <mapping> <class name="myObject" identity="id"> <description></description> <map-to table="dev.object" /> <field name="a" type="string" > <sql name="a" type="varchar"/> </field> <field name="b" type="string" > <sql name="b" type="varchar"/> </field> <field name="c" type="cObject" collection="collection" lazy="true" required="false"> <sql many-key="mid"/> </field> </class> <class name="cObject" identity="id"> <description></description> <map-to table="dev.cobject" /> <field name="id" type="integer" > <sql name="id" type="integer"/> </field> <field name="a" type="string"> <sql name="a" type="varchar"/> </field> </class> I am then using the following OQL to query for the objects  CALL SQL SELECT id, a, b FROM dev.object AS myObject I expected this to return me the objects but without the cObjects (as I havn't done the INNER JOIN)...??? Is this correct...? However, first of all I get a NullPointerException in createCall in SQLEngine because I havn't provided a sql name attribute for the many object in my myObject class....I have done a quick fix for this but it leads to another problem.....In SQLTypes it appears to still try and populate the many fields in getObject() so fails with a SQLException: Invalid column index....   Is it intended that castor JDO should support this type of query....?   Any help would be gratefully received....   Thanks   Brett Cherrington