[jira] [Created] (FINERACT-1178) Allow usage of SQL connection parameters

["Cedric Khin (Jira)" <ji...@apache.org>]

Cedric Khin created FINERACT-1178:
-------------------------------------

             Summary: Allow usage of SQL connection parameters
                 Key: FINERACT-1178
                 URL: https://issues.apache.org/jira/browse/FINERACT-1178
             Project: Apache Fineract
          Issue Type: Improvement
          Components: Database
            Reporter: Cedric Khin


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 :
{code:java}
jdbc:mysql://google:<PORT>/<DATABASE_NAME>?cloudSqlInstance=<INSTANCE_CONNECTION_NAME>&socketFactory=com.google.cloud.sql.mysql.SocketFactory{code}
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.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)