Blake, Further investigation shows that these 2 tables are defines in mam-id-table and turbine-id-table so they are conflicting. Do I need to remove them from turbine-id table? Naga ----- Original Message ----- From: "Naga Pappireddi" <[EMAIL PROTECTED]> To: "Turbine Users List" <[EMAIL PROTECTED]> Sent: Tuesday, May 07, 2002 10:46 AM Subject: Re: ant init error messages
> Blake, > After changing the foreign key to turbine* I was able to get rid of the > errors. However I am getting new errors: > > [sql] Executing file: > C:\dev\tdk\webapps\mam\WEB-INF\src\sql\mam-id-table- > init.sql > [sql] Failed to execute: insert into ID_TABLE (id_table_id, > table_name, next_id, quantity) VALUES (101, 'TURBINE_USER', 100, 10) > [sql] java.sql.SQLException: ORA-00001: unique constraint > (SAWYER.SYS_C0011712) violated > > [sql] Failed to execute: insert into ID_TABLE (id_table_id, > table_name, next_id, quantity) VALUES (102, 'TURBINE_ROLE', 100, 10) > [sql] java.sql.SQLException: ORA-00001: unique constraint > (SAWYER.SYS_C0011712) violated > > > So those 2 tables TURBINE_ROLE and TURBINE_USER are the aliases > Any idea > Naga > > ----- Original Message ----- > From: "Blake Day" <[EMAIL PROTECTED]> > To: "Turbine Users List" <[EMAIL PROTECTED]> > Sent: Tuesday, May 07, 2002 10:22 AM > Subject: RE: ant init error messages > > > > I'm using postgresql, and I'm fairly sure that there is no "CREATE ALIAS". > > I'm not sure if that syntax works in Oracle. What errors are you getting > > when trying my suggestion? In my SQL, there is no reference to > CATALOG_USER > > at all. I forgot to mention that any FK you have setup need to reference > > TURBINE_USER, not MAM_USER. > > > > Michael Blake Day > > Artistry Studios - e-commerce design, implementation and hosting > > email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > -----Original Message----- > > From: Naga Pappireddi [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, May 07, 2002 1:05 PM > > To: Turbine Users List > > Subject: Re: ant init error messages > > > > > > Blake, > > Thank you for your response. > > > > I tried your suggestion and I still get same errors. In addition I get > more > > errors in om generation ;( > > > > Looking at the SQL file, shouldn't it have : > > create alias mam_user for turbine_user ? > > > > I donot see the generated SQL file having the above statement > > > > I appreciate your help > > > > Naga > > > > ----- Original Message ----- > > From: "Blake Day" <[EMAIL PROTECTED]> > > To: "Turbine Users List" <[EMAIL PROTECTED]> > > Sent: Tuesday, May 07, 2002 7:46 AM > > Subject: RE: ant init error messages > > > > > > > You're new user table needs to look like this: > > > > > > <table name="TURBINE_USER" javaName="CatalogUser" alias="TurbineUser" > > > baseClass="<pkg>.catalog.om.TurbineUserAdapter" > > > basePeer="<pkg>.catalog.om.TurbineUserPeerAdapter"> > > > > > > <!-- Unique identifier --> > > > <column name="USER_ID" primaryKey="true" required="true" > > > type="integer"/> > > > </table> > > > > > > Notice the name is also "TURBINE_USER". I believe the Extend User > How-to > > is > > > incorrect. You'll probably want to set the javaName parameter to > > "MamUser". > > > > > > Michael Blake Day > > > Artistry Studios - e-commerce design, implementation and hosting > > > email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > -----Original Message----- > > > From: Naga Pappireddi [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, May 06, 2002 8:26 PM > > > To: Turbine Users List > > > Subject: ant init error messages > > > > > > > > > Hello, > > > We defined db xml schema in which we extended TURBINE_USER to have more > > > fields and being accessed thru MAM_USER as alias. During ant init I get > > the > > > following errors. Obviously this sql is generated from xml schema and > has > > > some FK issues. I am wondering what these msgs mean and how I can fix > the > > > xml schema to avoid this. The functionality is not affected but I am > > > concerned that this is something I should avoid(much like C compiler > > > warnings being potential runtime errors) > > > > > > Thank you in advance > > > > > > Naga > > > > > > > > > [torque-sql] > C:\dev\tdk\webapps\mam\WEB-INF\src\sql\mam-id-table-init.sql > > > > > > project-insert-sql: > > > > > > insert-sql-file: > > > [sql] Executing file: > > > C:\dev\tdk\webapps\mam\WEB-INF\src\sql\mam-schema.sq > > > l > > > [sql] Failed to execute: ALTER TABLE COMPANY_USER ADD CONSTRAINT > > > COMPANY_U > > > SER_FK_2 FOREIGN KEY (USER_ID) REFERENCES MAM_USER (USER_ID) > > > [sql] java.sql.SQLException: ORA-00942: table or view does not > exist > > > > > > [sql] Failed to execute: ALTER TABLE ROUTING_USERS_ROLE ADD > > CONSTRAINT > > > ROU > > > TING_USERS_ROLE_FK_1 FOREIGN KEY (USER_ID) REFERENCES MAM_USER (USER_ID) > > > [sql] java.sql.SQLException: ORA-00942: table or view does not > exist > > > > > > [sql] Failed to execute: ALTER TABLE ROUTING_USERS_ROLE ADD > > CONSTRAINT > > > ROU > > > TING_USERS_ROLE_FK_2 FOREIGN KEY (ROLE_ID) REFERENCES MAM_ROLE (ROLE_ID) > > > [sql] java.sql.SQLException: ORA-00942: table or view does not > exist > > > > > > [sql] 56 of 59 SQL statements executed successfully > > > > > > > > > > > > -- > > > 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]> > > > > > > > > > > > > -- > > 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]> > > > > > > > -- > 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]>
