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