Foreign key reference to TURBINE_USER

[Charles Benett]

Hi!
Using tdk2.1b2 and mysql.

I have a table where I want a foreign key which refers to
TURBINE_USER.USER_ID.
Torque seems to generate the right sql but chokes on the om generation
with:

ERROR!! Attempt to set foreign key to nonexistent table, TURBINE_USER!
java.lang.NullPointerException
        at
org.apache.turbine.torque.engine.database.transform.XmlToAppData.startElement(XmlToAppData.java:237)

I'm guessing the problem may be that the table definitions are in
different xml files (project-schema and turbine-schema).
Has anyone else seen this and what is the work around?

I know mysql doesn't implement foreign keys for referential integrity,
but it seems useful to indicate the design in the schema.xml and useful
in case I change db. I'm also guessing that this isn't a mysql specific
issue.

Thanks,

Charles



the xml is like:
  <table name="IDENTITIES">
    <column name="IDENT_ID" required="true" autoIncrement="true"
primaryKey="true" type="INTEGER"/>
    <column name="HANDLE" required="true" size="255" type="VARCHAR"/>
    <column name="USER_ID" required="true" type="INTEGER"/>

    <foreign-key foreignTable="TURBINE_USER">
      <reference local="USER_ID" foreign="USER_ID"/>
    </foreign-key>

  </table>

the generated sql is like:
drop table if exists IDENTITIES;

CREATE TABLE IDENTITIES
(
    IDENT_ID INTEGER NOT NULL AUTO_INCREMENT,
    HANDLE VARCHAR (255) NOT NULL,
    USER_ID INTEGER NOT NULL,
    PRIMARY KEY(IDENT_ID),
    FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID)
);

CB

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]