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

2020-10-12 Thread Cedric Khin (Jira)


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

Cedric Khin commented on FINERACT-1178:
---

Thank you for your reply, your presentation is indeed interesting !

I will check the issue, thanks for linking it.

> 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:/?cloudSqlInstance=&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)


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

2020-10-09 Thread Michael Vorburger (Jira)


[ 
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:/?cloudSqlInstance=&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)