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)
