On Mon, 2002-05-13 at 12:34, Jeff Barrett wrote: > > > 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.)
The entry for the alias xml should not happen. It is likely a missing conditional in a template. Help tracking it down is appreciated. > > 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). Sorry missed that, it should be TURBINE_USER as well. john mcnally > > > 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]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
