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:05 UTC
(fineract) branch develop updated (1b9459b7b4 -> 65583a1661)
This is an automated email from the ASF dual-hosted git repository.
adamsaghy pushed a change to branch develop
in repository https://gitbox.apache.org/repos/asf/fineract.git
from 1b9459b7b4 FINERACT-2169: Refactor field configuration api controller;
new c613d9c0fe FINERACT-2207: fix jdbc connection string in liquibase script
new 65583a1661 FINERACT-2207: add both of the validCheckSum to make it work all of the dbs
The 2 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
Summary of changes:
.../parts/0005_jdbc_connection_string.xml | 25 +++++++++++++++++++---
1 file changed, 22 insertions(+), 3 deletions(-)
(fineract) 02/02: FINERACT-2207: add both of the validCheckSum to make it work all of the dbs
Posted by ad...@apache.org.
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 65583a1661b26b7ca94bbc782a77966f8153830c
Author: abudai-move <bu...@gmail.com>
AuthorDate: Thu Mar 27 19:32:33 2025 +0100
FINERACT-2207: add both of the validCheckSum to make it work all of the dbs
---
.../db/changelog/tenant-store/parts/0005_jdbc_connection_string.xml | 1 +
1 file changed, 1 insertion(+)
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 5bd3fc0aae..384ac19f58 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
@@ -25,6 +25,7 @@
<changeSet author="fineract" id="1" context="tenant_store_db">
<validCheckSum>9:14cc7994587792811d35cff3df30dc5d</validCheckSum>
+ <validCheckSum>9:90654ac665c3ab846d618257fe27f518</validCheckSum>
<sql dbms="postgresql">
UPDATE tenant_server_connections
SET schema_connection_parameters =
(fineract) 01/02: FINERACT-2207: fix jdbc connection string in liquibase script
Posted by ad...@apache.org.
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>