I have not followed the details of this thread, but from what I can tell the extend-user-howto contained an error and the alias table entry should refer to the actual table name TURBINE_USER not NEWAPP_USER. I made the change in the doc. Was there something else that I missed?
john mcnally On Thu, 2002-05-09 at 09:15, Blake Day wrote: > If I understand your question correctly, then yes, there was a problem in > the SQL that was generated when I followed the HOW-TO. My application > tables referenced "CATALOG_USER" (or "MAM_USER" in your case) instead of > "TURBINE_USER". Since that how-to was written for MySQL, the writer would > not have experienced the problems we had because the SQL generation for > MySQL databases does not generate any Foreign Keys. > > 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: Wednesday, May 08, 2002 7:16 PM > To: Turbine Users List > Subject: RE: ant init error messages > > > Blake, > I didnot get any errors in scenario too. Other than > the errors/warnings during init, did you notice any > logical problem in database to warrant scenario 2 > > Other users: please let me know what your thoughts. > BTW the database I use is Oracle > Naga > > --- Blake Day <[EMAIL PROTECTED]> wrote: > > I personally believe the extend user how-to is in > > error; however, I am not > > an expert with Turbine by any means. If anyone here > > knows better, feel free > > to speak up. I did get the exact same errors as you > > did in "scenario 1". > > That's why I tried an alternative, which was > > scenario 2. Since I've done as > > I recommended, I've experienced no problems or side > > effects. > > > > 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: Wednesday, May 08, 2002 1:31 PM > > To: Turbine Users List > > Subject: RE: ant init error messages > > > > > > Blake, > > The first scenario where I had followed "howto > > guide" > > and getting ora:0942 no view/table exist error -- > > the > > application still working > > The second scenario, which you recommended, that > > alias > > table definition should have turbine tables.. i get > > the warnings like the id table duplicate entries. > > I would like to know if the howto guide is in error. > > How strongly you feel about it. I want to choose on > > of > > the above. > > In case of scenario 1, did you get the same error I > > got and whether you feel that is serious error that > > scenario 2 need to be followed. > > Bottom line, I am by any standards not DB expert, so > > seeking layman advice > > Appreciate your time in helping out > > Thank you > > Naga > > --- Blake Day <[EMAIL PROTECTED]> wrote: > > > I think I actually still have the problem you're > > > having. I just ignored it > > > because the "ant init" is just trying to insert > > > duplicate rows for the > > > tables you've extended. This won't create any > > > problems later on. If you do > > > figure out a better way that works (one that > > doesn't > > > generate errors), > > > please let me know. > > > > > > 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:51 PM > > > To: Turbine Users List > > > Subject: Re: ant init error messages > > > > > > > > > Blake, > > > Further investigation shows that these 2 tables > > are > > > defines in mam-id-table > > > and turbine-id-table so they are conflicting. Do I > > > need to remove them from > > > turbine-id table? > > > Naga > > > ----- Original Message ----- > > > From: "Naga Pappireddi" <[EMAIL PROTECTED]> > > > To: "Turbine Users List" > > > <[EMAIL PROTECTED]> > > > Sent: Tuesday, May 07, 2002 10:46 AM > > > Subject: Re: ant init error messages > > > > > > > > > > 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> > > > > > > > > > === message truncated === > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Shopping - Mother's Day is May 12th! > http://shopping.yahoo.com > > -- > 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]>
