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

["Michael Vorburger (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FINERACT-1178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17210955#comment-17210955 ] 

Michael Vorburger commented on FINERACT-1178:
---------------------------------------------

welcome to Apache Fineract! By creating this issue and raising a PR, you have earned the right to the Contributor role. You can now assign JIRA issues to yourself! Go ahead and check out [our dashboard|[https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12335824|https://issues.apache.org/jira/secure/Dashboard.jspa?selectPageId=12335824)]] to find and grab (self-assign) more stuff to work on - we would love to have more contributions from you!

I'm excited to see your interest in running Fineract on Google Cloud, and will review your PR ASAP. BTW, are you aware of (my) [https://www.fineract.dev?|https://www.fineract.dev/] That runs on GCP, and you may enjoy the [Running Fineract.dev, SRE style|https://docs.google.com/presentation/d/1-VP4bNkc5kZ3B0yme_vYLiY1qpswnfz8ainnX5fp3l8/] presentation recently given at ApacheCon, which has related background. Also, note FINERACT-955 - is that perhaps something that could interest you? (The current assignee doesn't seem to be actively working on it, so it should be OK to politely ask if you can "take" it and re-assign it to yourself.)

> 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
>            Assignee: Cedric Khin
>            Priority: Minor
>             Fix For: 1.5.0
>
>
> 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)