Adam Saghy created FINERACT-2207:
------------------------------------
Summary: The custom JDBC driver parameters are overwritten during
the Fineract initialization process
Key: FINERACT-2207
URL: https://issues.apache.org/jira/browse/FINERACT-2207
Project: Apache Fineract
Issue Type: Bug
Affects Versions: 1.11
Reporter: Adam Saghy
Fix For: 1.12
When Fineract is initialized from an empty tenant-store database it uses an
environment variable ({{{}FINERACT_DEFAULT_TENANTDB_CONN_PARAMS{}}}) that can
be used to pass parameters to the JDBC driver. This is useful e.g. to set
parameters to support fast failover with AWS' Aurora PostgreSQL database.
This mechanism is currently broken, as the following happens:
* {{0001_initial_schema.xml}} → creates the {{tenant_server_connections}} table
* {{0002_initial_data.xml}} → creates the default tenant and sets the correct
value in the {{schema_connection_parameters}} column
* {{0005_jdbc_connection_string.xml}} → overwrites the
{{schema_connection_parameters}} column with the static value
{{serverTimezone=UTC&useLegacyDatetimeCode=false&sessionVariables=time_zone='-00:00'}}
The expected behavior would be to have the value of
{{FINERACT_DEFAULT_TENANTDB_CONN_PARAMS}} in the
{{schema_connection_parameters}} column at the end of the database
initialization.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
