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]>
