This is an automated email from the ASF dual-hosted git repository. ilgrosso pushed a commit to branch 4_0_X in repository https://gitbox.apache.org/repos/asf/syncope.git
commit c7394ec3bdce70fe81e8d1a4e247bba277f0880a Author: Francesco Chicchiriccò <[email protected]> AuthorDate: Mon Nov 24 14:23:58 2025 +0100 Fixing Realm's table plainAttrs column type --- core/persistence-jpa/src/main/resources/META-INF/indexes.xml | 1 + .../src/main/resources/META-INF/mariadb/spring-orm.xml | 9 +++++++++ .../src/main/resources/META-INF/mysql/spring-orm.xml | 9 +++++++++ .../src/main/resources/META-INF/oracle/indexes.xml | 1 + .../src/main/resources/META-INF/oracle/spring-orm.xml | 9 +++++++++ core/persistence-jpa/src/main/resources/META-INF/spring-orm.xml | 9 +++++++++ 6 files changed, 38 insertions(+) diff --git a/core/persistence-jpa/src/main/resources/META-INF/indexes.xml b/core/persistence-jpa/src/main/resources/META-INF/indexes.xml index ee2ca34ea4..9940f5d025 100644 --- a/core/persistence-jpa/src/main/resources/META-INF/indexes.xml +++ b/core/persistence-jpa/src/main/resources/META-INF/indexes.xml @@ -23,6 +23,7 @@ under the License. <entry key="Realm_parent_id">CREATE INDEX Realm_parent_id ON Realm(parent_id)</entry> <entry key="Realm_fullPath_startsWith">CREATE INDEX Realm_fullPath_startsWith ON Realm USING GIN (to_tsvector('english', fullPath))</entry> + <entry key="Realm_plainAttrs_idx">CREATE INDEX Realm_plainAttrs_idx ON Realm USING gin ((plainAttrs) jsonb_path_ops)</entry> <entry key="SyncopeUser_realm_id">CREATE INDEX SyncopeUser_realm_id ON SyncopeUser(realm_id)</entry> <entry key="SyncopeUser_username">CREATE UNIQUE INDEX SyncopeUser_username ON SyncopeUser(username)</entry> diff --git a/core/persistence-jpa/src/main/resources/META-INF/mariadb/spring-orm.xml b/core/persistence-jpa/src/main/resources/META-INF/mariadb/spring-orm.xml index 408169e456..041e21be8a 100644 --- a/core/persistence-jpa/src/main/resources/META-INF/mariadb/spring-orm.xml +++ b/core/persistence-jpa/src/main/resources/META-INF/mariadb/spring-orm.xml @@ -69,4 +69,13 @@ under the License. </basic> </attributes> </entity> + + <entity class="org.apache.syncope.core.persistence.jpa.entity.JPARealm"> + <attributes> + <basic name="plainAttrs"> + <column column-definition="json"/> + <lob/> + </basic> + </attributes> + </entity> </entity-mappings> diff --git a/core/persistence-jpa/src/main/resources/META-INF/mysql/spring-orm.xml b/core/persistence-jpa/src/main/resources/META-INF/mysql/spring-orm.xml index 408169e456..041e21be8a 100644 --- a/core/persistence-jpa/src/main/resources/META-INF/mysql/spring-orm.xml +++ b/core/persistence-jpa/src/main/resources/META-INF/mysql/spring-orm.xml @@ -69,4 +69,13 @@ under the License. </basic> </attributes> </entity> + + <entity class="org.apache.syncope.core.persistence.jpa.entity.JPARealm"> + <attributes> + <basic name="plainAttrs"> + <column column-definition="json"/> + <lob/> + </basic> + </attributes> + </entity> </entity-mappings> diff --git a/core/persistence-jpa/src/main/resources/META-INF/oracle/indexes.xml b/core/persistence-jpa/src/main/resources/META-INF/oracle/indexes.xml index ab9484c423..f86e5e81b7 100644 --- a/core/persistence-jpa/src/main/resources/META-INF/oracle/indexes.xml +++ b/core/persistence-jpa/src/main/resources/META-INF/oracle/indexes.xml @@ -34,6 +34,7 @@ under the License. <!-- The following indexes require Oracle TEXT to be installed on the given Oracle database: http://dbaflavours.blogspot.com/2012/09/ora-29833-indextype-does-not-exist_18.html --> + <entry key="Realm_plainAttrs_Index">CREATE SEARCH INDEX Realm_plainAttrs_Index ON Realm(plainAttrs) FOR JSON</entry> <entry key="AnyObject_plainAttrs_Index">CREATE SEARCH INDEX AnyObject_plainAttrs_Index ON AnyObject(plainAttrs) FOR JSON</entry> <entry key="SyncopeGroup_plainAttrs_Index">CREATE SEARCH INDEX SyncopeGroup_plainAttrs_Index ON SyncopeGroup(plainAttrs) FOR JSON</entry> <entry key="SyncopeUser_plainAttrs_Index">CREATE SEARCH INDEX SyncopeUser_plainAttrs_Index ON SyncopeUser(plainAttrs) FOR JSON</entry> diff --git a/core/persistence-jpa/src/main/resources/META-INF/oracle/spring-orm.xml b/core/persistence-jpa/src/main/resources/META-INF/oracle/spring-orm.xml index ec51dcfa7e..6e84c95455 100644 --- a/core/persistence-jpa/src/main/resources/META-INF/oracle/spring-orm.xml +++ b/core/persistence-jpa/src/main/resources/META-INF/oracle/spring-orm.xml @@ -68,4 +68,13 @@ under the License. </basic> </attributes> </entity> + + <entity class="org.apache.syncope.core.persistence.jpa.entity.JPARealm"> + <attributes> + <basic name="plainAttrs"> + <column column-definition="CLOB CHECK (plainAttrs IS JSON)"/> + <lob/> + </basic> + </attributes> + </entity> </entity-mappings> diff --git a/core/persistence-jpa/src/main/resources/META-INF/spring-orm.xml b/core/persistence-jpa/src/main/resources/META-INF/spring-orm.xml index 1ae2eed60d..66aec95e14 100644 --- a/core/persistence-jpa/src/main/resources/META-INF/spring-orm.xml +++ b/core/persistence-jpa/src/main/resources/META-INF/spring-orm.xml @@ -69,4 +69,13 @@ under the License. </basic> </attributes> </entity> + + <entity class="org.apache.syncope.core.persistence.jpa.entity.JPARealm"> + <attributes> + <basic name="plainAttrs"> + <column column-definition="jsonb"/> + <lob/> + </basic> + </attributes> + </entity> </entity-mappings>
