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