CODEWITHSUNDEEP
wso2wso2-identity-server
Hos
Hos

Reputation: 457

WSO2 Identity Server Upgrade 5.0.0 -> 5.1.0 isCascadeDeleteEnabled in user-mgt.xml

Referring to the upgrade documentation the user-mgt.xml has a new property 

<Property name="isCascadeDeleteEnabled">true</Property>

In case of an upgrade the documentation says:

If you are connecting the database from a previous version of IS, set this property to "false".

My question: Does this mean that an upgraded installation has a different setting as an installation from scratch? Why that?

Upvotes: 0

Views: 110

Answers (1)

Lasantha Samarakoon
Lasantha Samarakoon

Reputation: 91

This setting has been introduced in Carbon 4.4.2 in order to allow cascade delete in UM_USER_PERMISSION, UM_ROLE_PERMISSION tables when a permission get deleted form UM_PERMISSION [1].

When this property is set to true, a single query will be sent to parent table (UM_PERMISSION) so the respective rows from the child tables will be deleted automatically.

When this property is set to false, multiple queries will be sent first to child tables and then the parent table to delete the respective rows.

This database level CASCADE DELETE relationship is introduced in Carbon 4.4.2 databases. So this database level relationship is not available in the IS 5.0.0 database, therefore if you are using the same database with IS 5.1.0 you need to set the isCascadeDeleteEnabledproperty to false.

[1] https://docs.wso2.com/display/Carbon443/Database+Upgrade+Guide

Upvotes: 1

Related Questions