NOTE: I've crossposted this to the turbine-torque-user list as it seems appropriate. I didn't know this list existed until I received an email about it from Eric Dobbs - perhaps it should be added to the list of jakarta mailing lists.
Hi John, That's spot on. There is one other bit as well: it seems the alias table entry in <project_name>-schema.xml causes an insert to be placed into <project_name>-id-table-init.sql with a table_name of the alias. As an example, the TURINE_USER extension/aliasing we are discussing generates: insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (101, 'TURBINE_USER', 100, 10); This is problematic for two reasons: 1) the following line is in turbine-id-table-init.sql and is executed before the above line: insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (5, 'TURBINE_USER', 100, 10); 2) there is (rightly) a unique constraint on the ID_TABLE.TABLE_NAME column. It seems that an alias table entry in <project_name>-schema.xml should not generate a new row insertion in <project_name>-id-table-init.sql and thereby into ID_TABLE as the _actual_ table the alias refers to would take care of that. Is there something we're missing in our configuration to prevent the table alias from generating a new entry in <project_name>-id-table-init.sql? Have I managed to completely confuse everyone? (Incidently we realize this failed insert isn't causing a problem, but error messages make us nervous.) I also took a look at the change in the extended user howto. It looks the alias table name is now TURBINE_USER but the foreign-key foreignTable reference is still NEWAPP_USER. I believe this is incorrect (although I've succeeded in confusing myself a bit now). Much thanks for the help, +jeff -----Original Message----- From: John McNally [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 10:26 AM To: Turbine Users List Subject: RE: ant init error messages I have not followed the details of this thread, but from what I can tell the extend-user-howto contained an error and the alias table entry should refer to the actual table name TURBINE_USER not NEWAPP_USER. I made the change in the doc. Was there something else that I missed? john mcnally -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
