Uploaded image for project: 'Apache Fineract'
  1. Apache Fineract
  2. FINERACT-1178

Allow usage of SQL connection parameters

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.5.0
    • Component/s: Database
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Sugiuro Cedric Khin
                Reporter:
                Sugiuro Cedric Khin
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: