You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@fineract.apache.org by ad...@apache.org on 2025/03/28 11:24:06 UTC
(fineract) 01/02: FINERACT-2207: fix jdbc connection string in liquibase script
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 <bu...@gmail.com>
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>