No it doesn't have CASCADE contraint enabled. I checked in the DB and it's referred as RESTRICT constraint.
On Wed, Nov 23, 2016 at 10:28 AM, Maduranga Siriwardena <[email protected]> wrote: > Hi Shazni, > > Better check whether those tables I have mentioned has the ON DELETE > CASCADE constraint enabled. > > Thanks, > > On Wed, Nov 23, 2016 at 2:22 PM, Shazni Nazeer <[email protected]> wrote: > >> Got it Maduranga. Thanks for the information. >> >> I've set it false in my setup and seems there's no side effect in doing >> so. >> >> On Wed, Nov 23, 2016 at 3:48 AM, Maduranga Siriwardena < >> [email protected]> wrote: >> >>> Hi Shazni, >>> >>> This property is added with a fix to [1]. With the fix we have added ON >>> DELETE CASCADE constraint on UM_ROLE_PERMISSION, UM_USER_PERMISSION, >>> UM_HYBRID_USER_ROLE tables in user management database. This is added with >>> a kernel 4.4.x release and because we need to the database to be backward >>> compatible, we have added this property. So if ON DELETE CASCADE constraint >>> is not there on those tables, we need this property set to false. See the >>> PR [2]. >>> >>> [1] https://wso2.org/jira/browse/IDENTITY-3620 >>> [2] https://github.com/wso2/carbon-kernel/pull/512 >>> >>> Thanks, >>> >>> On Mon, Nov 21, 2016 at 3:20 PM, Shazni Nazeer <[email protected]> wrote: >>> >>>> Hi, >>>> >>>> I got an constraint violation while deleting an API due to cascade >>>> delete. I got rid of the error by turning it off. >>>> >>>> Is there any functional implications in turning off >>>> "isCascadeDeleteEnabled" in the API-M repository/conf/user-mgt.xml? >>>> >>>> regards >>>> >>>> -- >>>> Shazni Nazeer >>>> Associate Technical Lead | WSO2 >>>> >>>> Mob : +94 777737331 >>>> LinkedIn : http://lk.linkedin.com/in/shazninazeer >>>> Blog : http://shazninazeer.blogspot.com >>>> >>>> <http://wso2.com/signature> >>>> >>>> _______________________________________________ >>>> Dev mailing list >>>> [email protected] >>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>> >>>> >>> >>> >>> -- >>> Maduranga Siriwardena >>> Software Engineer >>> WSO2 Inc; http://wso2.com/ >>> >>> Email: [email protected] >>> Mobile: +94718990591 >>> Blog: http://madurangasblogs.blogspot.com/ >>> <http://wso2.com/signature> >>> >> >> >> >> -- >> Shazni Nazeer >> Associate Technical Lead | WSO2 >> >> Mob : +94 777737331 >> LinkedIn : http://lk.linkedin.com/in/shazninazeer >> Blog : http://shazninazeer.blogspot.com >> >> <http://wso2.com/signature> >> > > > > -- > Maduranga Siriwardena > Software Engineer > WSO2 Inc; http://wso2.com/ > > Email: [email protected] > Mobile: +94718990591 > Blog: http://madurangasblogs.blogspot.com/ > <http://wso2.com/signature> > -- Shazni Nazeer Associate Technical Lead | WSO2 Mob : +94 777737331 LinkedIn : http://lk.linkedin.com/in/shazninazeer Blog : http://shazninazeer.blogspot.com <http://wso2.com/signature>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
