[castor-dev] Child table with only one column.

[Anand Janakiraman]

Hi,

   We have the followign scenario, while using JDO:

   Parent class P with two fields:
        int id; 
        string p;
   Class C which extends P, with field id, and a many-to-many association
to Class A:
        int id;
        Vector a;

   The database tables look as follows:
   table P:
      id  int PK
      p   varchar 

   table C:
      id  int PK

   (linking) table CA:
      c_id  int
      a_id  int

   now, when a db.update is called on an object of class C, castor throws
the following exception :
java.sql.SQLException: ORA-01747: invalid user.table.column, table.column,
or column specification
   problem is that the update statement for C, reads as:
UPDATE "C" SET  WHERE "id"=?

   since the table does not have any columns (or attributes) - only
associations - the update statement doesnt read correctly..
   
   how do we avoid the problem?

thanks,
anand.

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev