You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by "Schmidt, Uwe" <US...@GEA-WIEGAND.DE> on 2002/05/06 15:13:18 UTC
ParameterParser.setProperties deprecated ?
Hi,
I am just porting my application to turbine-2.2-b1 using the
decoupled torque. Using RunData.getParameters.setProperties(...)
leads to an exception when one of the screen members is of type
NumberKey. This happens because ParameterParser.setProperties tries
to work on o.a.turbine.om.NumberKey and not on o.a.torque.om.NumberKey.
I think this is because the security system is still using the torque
implementation coupled with turbine and not the decoupled version.
(so it works fine with flux).
What about in the future: Will setProperties be usable in future versions
of torque or does it become deprecated ? Does a work around exist ?
Uwe
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: ant init error messages
Posted by Blake Day <bl...@charter.net>.
Actually, I was manually building the databases at first until I tried
changing the name of the table. That worked, but it certainly was annoying.
I was running ant init, but pausing right after the SQL was generated so I
could go make the changes to the file. I then unpaused ant init for the SQL
insertion to take place.
Michael Blake Day
Artistry Studios - e-commerce design, implementation and hosting
email: mday@artistrystudios.net <ma...@artistrystudios.net>
-----Original Message-----
From: Colm McCartan [mailto:colmm@owl.co.uk]
Sent: Thursday, May 09, 2002 4:53 AM
To: Turbine Users List
Subject: Re: ant init error messages
At 09:46 09/05/2002 +1000, you wrote:
><disclaimer>I haven't read this thread thoroughly.</disclaimer>
>
>The extend-user-howto was put together using MySQL which ignores the
>referential integrity constraints that are referred to in the original
post.
>It is indeed possible that the documented solution will require
modification
>for an RDBMS that supports RI.
>
>Have others using PostgreSQL or Oracle successfully extended TurbineUser in
>the manner described in the HOWTO?
>
>Scott
Yes, we managed this with postgres. I posted earlier in the thread saying
that this alias name is invalid with postgres because of RI - we got around
this by referring the foreign key directly to TURBINE_USER. I thought
Blake's solution of using the table's java-name attr to point to the
appropriate class sounded like a good idea - we ended up generating the
code and accepting the eerrors and then manually building the database.
Re: the primary key violations that Oracle is reporting: are these tables
being correctly dropped/depopulated during the build process?
colm
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: ant init error messages
Posted by Colm McCartan <co...@owl.co.uk>.
At 09:46 09/05/2002 +1000, you wrote:
><disclaimer>I haven't read this thread thoroughly.</disclaimer>
>
>The extend-user-howto was put together using MySQL which ignores the
>referential integrity constraints that are referred to in the original post.
>It is indeed possible that the documented solution will require modification
>for an RDBMS that supports RI.
>
>Have others using PostgreSQL or Oracle successfully extended TurbineUser in
>the manner described in the HOWTO?
>
>Scott
Yes, we managed this with postgres. I posted earlier in the thread saying
that this alias name is invalid with postgres because of RI - we got around
this by referring the foreign key directly to TURBINE_USER. I thought
Blake's solution of using the table's java-name attr to point to the
appropriate class sounded like a good idea - we ended up generating the
code and accepting the eerrors and then manually building the database.
Re: the primary key violations that Oracle is reporting: are these tables
being correctly dropped/depopulated during the build process?
colm
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: ant init error messages
Posted by Scott Eade <se...@backstagetech.com.au>.
<disclaimer>I haven't read this thread thoroughly.</disclaimer>
The extend-user-howto was put together using MySQL which ignores the
referential integrity constraints that are referred to in the original post.
It is indeed possible that the documented solution will require modification
for an RDBMS that supports RI.
Have others using PostgreSQL or Oracle successfully extended TurbineUser in
the manner described in the HOWTO?
Scott
> From: "Blake Day" <bl...@charter.net>
> Reply-To: "Turbine Users List" <tu...@jakarta.apache.org>
> Date: Wed, 8 May 2002 18:27:13 -0400
> To: "Turbine Users List" <tu...@jakarta.apache.org>
> Subject: RE: ant init error messages
>
> 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: mday@artistrystudios.net <ma...@artistrystudios.net>
>
> -----Original Message-----
> From: Naga Pappireddi [mailto:pappireddi@yahoo.com]
> 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 <bl...@charter.net> 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: mday@artistrystudios.net
>> <ma...@artistrystudios.net>
>>
>>
>> -----Original Message-----
>> From: Naga Pappireddi [mailto:naga@jalvamedia.com]
>> 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" <na...@jalvamedia.com>
>> To: "Turbine Users List"
>> <tu...@jakarta.apache.org>
>> 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" <bl...@charter.net>
>>> To: "Turbine Users List"
>> <tu...@jakarta.apache.org>
>>> 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: mday@artistrystudios.net
>> <ma...@artistrystudios.net>
>>>>
>>>> -----Original Message-----
>>>> From: Naga Pappireddi
>> [mailto:naga@jalvamedia.com]
>>>> 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" <bl...@charter.net>
>>>> To: "Turbine Users List"
>> <tu...@jakarta.apache.org>
>>>> 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: mday@artistrystudios.net
>> <ma...@artistrystudios.net>
>>>>>
>>>>>
>>>>>
>>>>> -----Original Message-----
>>>>> From: Naga Pappireddi
>> [mailto:naga@jalvamedia.com]
>>>>> 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:
>>
> === message truncated ===
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Health - your guide to health and wellness
> http://health.yahoo.com
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: ant init error messages
Posted by John McNally <jm...@collab.net>.
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: mday@artistrystudios.net <ma...@artistrystudios.net>
>
> -----Original Message-----
> From: Naga Pappireddi [mailto:pappireddi@yahoo.com]
> 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 <bl...@charter.net> 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: mday@artistrystudios.net
> > <ma...@artistrystudios.net>
> >
> > -----Original Message-----
> > From: Naga Pappireddi [mailto:pappireddi@yahoo.com]
> > 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 <bl...@charter.net> 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: mday@artistrystudios.net
> > > <ma...@artistrystudios.net>
> > >
> > >
> > > -----Original Message-----
> > > From: Naga Pappireddi [mailto:naga@jalvamedia.com]
> > > 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" <na...@jalvamedia.com>
> > > To: "Turbine Users List"
> > > <tu...@jakarta.apache.org>
> > > 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" <bl...@charter.net>
> > > > To: "Turbine Users List"
> > > <tu...@jakarta.apache.org>
> > > > 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: mday@artistrystudios.net
> > > <ma...@artistrystudios.net>
> > > > >
> > > > > -----Original Message-----
> > > > > From: Naga Pappireddi
> > > [mailto:naga@jalvamedia.com]
> > > > > 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" <bl...@charter.net>
> > > > > To: "Turbine Users List"
> > > <tu...@jakarta.apache.org>
> > > > > 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:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: ant init error messages
Posted by Blake Day <bl...@charter.net>.
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: mday@artistrystudios.net <ma...@artistrystudios.net>
-----Original Message-----
From: Naga Pappireddi [mailto:pappireddi@yahoo.com]
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 <bl...@charter.net> 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: mday@artistrystudios.net
> <ma...@artistrystudios.net>
>
> -----Original Message-----
> From: Naga Pappireddi [mailto:pappireddi@yahoo.com]
> 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 <bl...@charter.net> 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: mday@artistrystudios.net
> > <ma...@artistrystudios.net>
> >
> >
> > -----Original Message-----
> > From: Naga Pappireddi [mailto:naga@jalvamedia.com]
> > 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" <na...@jalvamedia.com>
> > To: "Turbine Users List"
> > <tu...@jakarta.apache.org>
> > 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" <bl...@charter.net>
> > > To: "Turbine Users List"
> > <tu...@jakarta.apache.org>
> > > 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: mday@artistrystudios.net
> > <ma...@artistrystudios.net>
> > > >
> > > > -----Original Message-----
> > > > From: Naga Pappireddi
> > [mailto:naga@jalvamedia.com]
> > > > 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" <bl...@charter.net>
> > > > To: "Turbine Users List"
> > <tu...@jakarta.apache.org>
> > > > 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:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: ant init error messages
Posted by Naga Pappireddi <pa...@yahoo.com>.
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 <bl...@charter.net> 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: mday@artistrystudios.net
> <ma...@artistrystudios.net>
>
> -----Original Message-----
> From: Naga Pappireddi [mailto:pappireddi@yahoo.com]
> 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 <bl...@charter.net> 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: mday@artistrystudios.net
> > <ma...@artistrystudios.net>
> >
> >
> > -----Original Message-----
> > From: Naga Pappireddi [mailto:naga@jalvamedia.com]
> > 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" <na...@jalvamedia.com>
> > To: "Turbine Users List"
> > <tu...@jakarta.apache.org>
> > 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" <bl...@charter.net>
> > > To: "Turbine Users List"
> > <tu...@jakarta.apache.org>
> > > 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: mday@artistrystudios.net
> > <ma...@artistrystudios.net>
> > > >
> > > > -----Original Message-----
> > > > From: Naga Pappireddi
> > [mailto:naga@jalvamedia.com]
> > > > 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" <bl...@charter.net>
> > > > To: "Turbine Users List"
> > <tu...@jakarta.apache.org>
> > > > 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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Servlet controller
Posted by Naga Pappireddi <pa...@yahoo.com>.
Folks,
I am using TDK and JSP's. I want to get all the urls
into a single place where I can verify the login,
permissions so that I can control access to different
urls in the application. Do you know what properties
file I need to register the entry point to my
application and also any code out there to get me
started.
Second related question is is there any builtin
service from turbine which takes advantage of
roles/perission table and give high level API
Thank you
Naga
__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: ant init error messages
Posted by Blake Day <bl...@charter.net>.
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: mday@artistrystudios.net <ma...@artistrystudios.net>
-----Original Message-----
From: Naga Pappireddi [mailto:pappireddi@yahoo.com]
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 <bl...@charter.net> 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: mday@artistrystudios.net
> <ma...@artistrystudios.net>
>
>
> -----Original Message-----
> From: Naga Pappireddi [mailto:naga@jalvamedia.com]
> 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" <na...@jalvamedia.com>
> To: "Turbine Users List"
> <tu...@jakarta.apache.org>
> 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" <bl...@charter.net>
> > To: "Turbine Users List"
> <tu...@jakarta.apache.org>
> > 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: mday@artistrystudios.net
> <ma...@artistrystudios.net>
> > >
> > > -----Original Message-----
> > > From: Naga Pappireddi
> [mailto:naga@jalvamedia.com]
> > > 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" <bl...@charter.net>
> > > To: "Turbine Users List"
> <tu...@jakarta.apache.org>
> > > 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: mday@artistrystudios.net
> <ma...@artistrystudios.net>
> > > >
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Naga Pappireddi
> [mailto:naga@jalvamedia.com]
> > > > 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:
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: ant init error messages
Posted by Naga Pappireddi <pa...@yahoo.com>.
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 <bl...@charter.net> 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: mday@artistrystudios.net
> <ma...@artistrystudios.net>
>
>
> -----Original Message-----
> From: Naga Pappireddi [mailto:naga@jalvamedia.com]
> 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" <na...@jalvamedia.com>
> To: "Turbine Users List"
> <tu...@jakarta.apache.org>
> 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" <bl...@charter.net>
> > To: "Turbine Users List"
> <tu...@jakarta.apache.org>
> > 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: mday@artistrystudios.net
> <ma...@artistrystudios.net>
> > >
> > > -----Original Message-----
> > > From: Naga Pappireddi
> [mailto:naga@jalvamedia.com]
> > > 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" <bl...@charter.net>
> > > To: "Turbine Users List"
> <tu...@jakarta.apache.org>
> > > 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: mday@artistrystudios.net
> <ma...@artistrystudios.net>
> > > >
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Naga Pappireddi
> [mailto:naga@jalvamedia.com]
> > > > 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:
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: ant init error messages
Posted by Blake Day <bl...@charter.net>.
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: mday@artistrystudios.net <ma...@artistrystudios.net>
-----Original Message-----
From: Naga Pappireddi [mailto:naga@jalvamedia.com]
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" <na...@jalvamedia.com>
To: "Turbine Users List" <tu...@jakarta.apache.org>
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" <bl...@charter.net>
> To: "Turbine Users List" <tu...@jakarta.apache.org>
> 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: mday@artistrystudios.net <ma...@artistrystudios.net>
> >
> > -----Original Message-----
> > From: Naga Pappireddi [mailto:naga@jalvamedia.com]
> > 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" <bl...@charter.net>
> > To: "Turbine Users List" <tu...@jakarta.apache.org>
> > 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: mday@artistrystudios.net <ma...@artistrystudios.net>
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Naga Pappireddi [mailto:naga@jalvamedia.com]
> > > 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:
> > > <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> > > <ma...@jakarta.apache.org>
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> > >
> > >
> >
> >
> > --
> > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
> >
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: ant init error messages
Posted by Naga Pappireddi <na...@jalvamedia.com>.
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" <na...@jalvamedia.com>
To: "Turbine Users List" <tu...@jakarta.apache.org>
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" <bl...@charter.net>
> To: "Turbine Users List" <tu...@jakarta.apache.org>
> 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: mday@artistrystudios.net <ma...@artistrystudios.net>
> >
> > -----Original Message-----
> > From: Naga Pappireddi [mailto:naga@jalvamedia.com]
> > 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" <bl...@charter.net>
> > To: "Turbine Users List" <tu...@jakarta.apache.org>
> > 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: mday@artistrystudios.net <ma...@artistrystudios.net>
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Naga Pappireddi [mailto:naga@jalvamedia.com]
> > > 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:
> > > <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> > > <ma...@jakarta.apache.org>
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> > >
> > >
> >
> >
> > --
> > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
> >
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: ant init error messages
Posted by Naga Pappireddi <na...@jalvamedia.com>.
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" <bl...@charter.net>
To: "Turbine Users List" <tu...@jakarta.apache.org>
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: mday@artistrystudios.net <ma...@artistrystudios.net>
>
> -----Original Message-----
> From: Naga Pappireddi [mailto:naga@jalvamedia.com]
> 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" <bl...@charter.net>
> To: "Turbine Users List" <tu...@jakarta.apache.org>
> 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: mday@artistrystudios.net <ma...@artistrystudios.net>
> >
> >
> >
> > -----Original Message-----
> > From: Naga Pappireddi [mailto:naga@jalvamedia.com]
> > 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:
> > <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
> >
> > --
> > To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> <ma...@jakarta.apache.org>
> >
> >
>
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: ant init error messages
Posted by Blake Day <bl...@charter.net>.
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: mday@artistrystudios.net <ma...@artistrystudios.net>
-----Original Message-----
From: Naga Pappireddi [mailto:naga@jalvamedia.com]
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" <bl...@charter.net>
To: "Turbine Users List" <tu...@jakarta.apache.org>
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: mday@artistrystudios.net <ma...@artistrystudios.net>
>
>
>
> -----Original Message-----
> From: Naga Pappireddi [mailto:naga@jalvamedia.com]
> 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:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: ant init error messages
Posted by Naga Pappireddi <na...@jalvamedia.com>.
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" <bl...@charter.net>
To: "Turbine Users List" <tu...@jakarta.apache.org>
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: mday@artistrystudios.net <ma...@artistrystudios.net>
>
>
>
> -----Original Message-----
> From: Naga Pappireddi [mailto:naga@jalvamedia.com]
> 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:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: ant init error messages
Posted by Blake Day <bl...@charter.net>.
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: mday@artistrystudios.net <ma...@artistrystudios.net>
-----Original Message-----
From: Naga Pappireddi [mailto:naga@jalvamedia.com]
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:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
ant init error messages
Posted by Naga Pappireddi <na...@jalvamedia.com>.
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Junit
Posted by Naga Pappireddi <na...@jalvamedia.com>.
Hello,
has anyone successful in using Junit with TDK?
Naga
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>