smartweb-user

[smartweb-user] [auth] Problem generation SQL script

[Rocco F. <rfu...@sm...>]

Hello everyone,
I noticed a problem with auth, in practice I create the script to generate
the database (I use ANT or MAVEN) and I run into postgre to create tables.
After that I made the test to insert a Group manually and after to cancel
but just delete the line in the table GROUP while the associated row in the
table SUBJECT not erase.
I check the script and apparently is not created the rule on the
cancellation which is required by default to "ON UPDATE NO ACTION ON DELETE
NO ACTION."
But if the operations erasure are made directly from the code with smartweb
everything works properly.
I wanted to know then how can create the script sql them properly?

Hello Rocco

Re: [smartweb-user] [auth] Problem generation SQL script

[Stefano V <st...@gm...>]

Sorry.. I don't understand you...
if smartweb works, where is the problem ? :-)
How do you delete the grouop?

2008/5/7 Rocco Fusella <rfu...@sm...>:

> Hello everyone,
> I noticed a problem with auth, in practice I create the script to generate
> the database (I use ANT or MAVEN) and I run into postgre to create tables.
> After that I made the test to insert a Group manually and after to cancel
> but just delete the line in the table GROUP while the associated row in the
> table SUBJECT not erase.
> I check the script and apparently is not created the rule on the
> cancellation which is required by default to "ON UPDATE NO ACTION ON DELETE
> NO ACTION."
> But if the operations erasure are made directly from the code with smartweb
> everything works properly.
> I wanted to know then how can create the script sql them properly?
>
> Hello Rocco
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save $100.
> Use priority code J8TL2D2.
>
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> smartweb-user mailing list
> sma...@li...
> https://lists.sourceforge.net/lists/listinfo/smartweb-user
>
>

Re: [smartweb-user] [auth] Problem generation SQL script

[Rocco F. <rfu...@sm...>]

What I wanted to know and if you can create the script so that if I'm going
to be pgAdmin erasing a group I must also cancel its subject,
>From smartweb does everything but if I had to make manual operations on db
must remember that if a gate line in the table group should also go to
delete a row in the table subject.
I hope to have been more clear, certainly my English is incomprehensible :-)

2008/5/8 Stefano V <st...@gm...>:

> Sorry.. I don't understand you...
> if smartweb works, where is the problem ? :-)
> How do you delete the grouop?
>
> 2008/5/7 Rocco Fusella <rfu...@sm...>:
>
>> Hello everyone,
>> I noticed a problem with auth, in practice I create the script to generate
>> the database (I use ANT or MAVEN) and I run into postgre to create tables.
>> After that I made the test to insert a Group manually and after to cancel
>> but just delete the line in the table GROUP while the associated row in the
>> table SUBJECT not erase.
>> I check the script and apparently is not created the rule on the
>> cancellation which is required by default to "ON UPDATE NO ACTION ON DELETE
>> NO ACTION."
>> But if the operations erasure are made directly from the code with
>> smartweb everything works properly.
>> I wanted to know then how can create the script sql them properly?
>>
>> Hello Rocco
>>
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
>> Don't miss this year's exciting event. There's still time to save $100.
>> Use priority code J8TL2D2.
>>
>> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
>> _______________________________________________
>> smartweb-user mailing list
>> sma...@li...
>> https://lists.sourceforge.net/lists/listinfo/smartweb-user
>>
>>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
> Don't miss this year's exciting event. There's still time to save $100.
> Use priority code J8TL2D2.
>
> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
> _______________________________________________
> smartweb-user mailing list
> sma...@li...
> https://lists.sourceforge.net/lists/listinfo/smartweb-user
>
>