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

Reply via email to