[FINERACT-1178] Allow usage of SQL connection parameters

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Component/s: Database
• Assignee: Cedric Khin
• Reporter: Cedric Khin
• Created: 05/Oct/20 15:13
• Updated: 25/Feb/21 08:10
• Resolved: 13/Oct/20 20:10

Description

By allowing the usage of connection parameters in the SQL connection string, we can pass useful parameters for i.e. Google Cloud SQL connection (using https://github.com/GoogleCloudPlatform/cloud-sql-jdbc-socket-factory for example), that would look like this :

jdbc:mysql://google:<PORT>/<DATABASE_NAME>?cloudSqlInstance=<INSTANCE_CONNECTION_NAME>&socketFactory=com.google.cloud.sql.mysql.SocketFactory

Currently it isn't possible to properly add connection parameters (except through an ugly hack in JDBCDriverConfig.constructProtocol()).

As far as I know, using a connection string with the aforementioned Cloud SQL JDBC Socket Factory is the only way I found to connect to Cloud SQL. Outside of using Cloud SQL, I believe this feature may be useful for some people that need to inject some parameters to their connection string to the database.

Issue Links

• Blocked: FINERACT-1305 Release Apache Fineract v1.5.0
• links to: GitHub Pull Request #1373