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