You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@fineract.apache.org by ar...@apache.org on 2023/06/06 09:45:28 UTC

[fineract] 11/15: FINERACT-1724: Spring Batch 5 upgrade liquibase fix

This is an automated email from the ASF dual-hosted git repository.

arnold pushed a commit to branch develop
in repository https://gitbox.apache.org/repos/asf/fineract.git

commit 7f2a81b828e4bfc3d9bb9718c6f6202d97fec8cc
Author: Arnold Galovics <ga...@gmail.com>
AuthorDate: Fri Jun 2 21:09:26 2023 +0200

    FINERACT-1724: Spring Batch 5 upgrade liquibase fix
---
 .../db/changelog/tenant/parts/0109_spring_batch_5_upgrade.xml     | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/fineract-provider/src/main/resources/db/changelog/tenant/parts/0109_spring_batch_5_upgrade.xml b/fineract-provider/src/main/resources/db/changelog/tenant/parts/0109_spring_batch_5_upgrade.xml
index 1508a7c52..75ccb8210 100644
--- a/fineract-provider/src/main/resources/db/changelog/tenant/parts/0109_spring_batch_5_upgrade.xml
+++ b/fineract-provider/src/main/resources/db/changelog/tenant/parts/0109_spring_batch_5_upgrade.xml
@@ -29,10 +29,10 @@
     <changeSet author="fineract" id="1">
         <dropColumn tableName="BATCH_JOB_EXECUTION" columnName="JOB_CONFIGURATION_LOCATION"/>
     </changeSet>
-    <changeSet author="fineract" id="2" context="postgresql">
+    <changeSet author="fineract" id="2" context="mysql">
         <sql>
             UPDATE BATCH_JOB_EXECUTION_PARAMS
-            SET STRING_VAL = TO_CHAR(DATE_VAL, 'YYYY-MM-DDTHH:MM:SSZ')
+            SET STRING_VAL = DATE_FORMAT(DATE_VAL, 'YYYY-MM-DDTHH:MM:SSZ')
             WHERE TYPE_CD = 'DATE'
         </sql>
         <sql>
@@ -46,10 +46,10 @@
             WHERE TYPE_CD = 'DOUBLE'
         </sql>
     </changeSet>
-    <changeSet author="fineract" id="2" context="mysql">
+    <changeSet author="fineract" id="2" context="postgresql">
         <sql>
             UPDATE BATCH_JOB_EXECUTION_PARAMS
-            SET STRING_VAL = DATE_FORMAT(DATE_VAL, 'YYYY-MM-DDTHH:MM:SSZ')
+            SET STRING_VAL = TO_CHAR(DATE_VAL, 'YYYY-MM-DDTHH:MM:SSZ')
             WHERE TYPE_CD = 'DATE'
         </sql>
         <sql>