This is an automated email from the ASF dual-hosted git repository. adamsaghy pushed a commit to branch develop in repository https://gitbox.apache.org/repos/asf/fineract.git
commit c613d9c0fe48bb964f5f8f1b2d4995f71dbac851 Author: abudai-move <[email protected]> AuthorDate: Mon Mar 24 18:26:20 2025 +0100 FINERACT-2207: fix jdbc connection string in liquibase script FINERACT-2207: add valid checksum --- .../parts/0005_jdbc_connection_string.xml | 24 +++++++++++++++++++--- 1 file changed, 21 insertions(+), 3 deletions(-) diff --git a/fineract-provider/src/main/resources/db/changelog/tenant-store/parts/0005_jdbc_connection_string.xml b/fineract-provider/src/main/resources/db/changelog/tenant-store/parts/0005_jdbc_connection_string.xml index 78fa641d65..5bd3fc0aae 100644 --- a/fineract-provider/src/main/resources/db/changelog/tenant-store/parts/0005_jdbc_connection_string.xml +++ b/fineract-provider/src/main/resources/db/changelog/tenant-store/parts/0005_jdbc_connection_string.xml @@ -22,9 +22,27 @@ <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.1.xsd";> + <changeSet author="fineract" id="1" context="tenant_store_db"> - <update tableName="tenant_server_connections"> - <column name="schema_connection_parameters" value="serverTimezone=UTC&useLegacyDatetimeCode=false&sessionVariables=time_zone='-00:00'"/> - </update> + <validCheckSum>9:14cc7994587792811d35cff3df30dc5d</validCheckSum> + <sql dbms="postgresql"> + UPDATE tenant_server_connections + SET schema_connection_parameters = + CASE + WHEN schema_connection_parameters IS NULL OR TRIM(schema_connection_parameters) = '' + THEN 'serverTimezone=UTC&useLegacyDatetimeCode=false&sessionVariables=time_zone=''-00:00''' + ELSE schema_connection_parameters || '&serverTimezone=UTC&useLegacyDatetimeCode=false&sessionVariables=time_zone=''-00:00''' + END; + </sql> + <sql dbms="mysql,mariadb"> + UPDATE tenant_server_connections + SET schema_connection_parameters = + CASE + WHEN schema_connection_parameters IS NULL OR TRIM(schema_connection_parameters) = '' + THEN 'serverTimezone=UTC&useLegacyDatetimeCode=false&sessionVariables=time_zone=''-00:00''' + ELSE CONCAT(schema_connection_parameters, '&serverTimezone=UTC&useLegacyDatetimeCode=false&sessionVariables=time_zone=''-00:00''') + END; + </sql> </changeSet> + </databaseChangeLog>
