Uploaded image for project: 'Identity Gateway'
  1. Identity Gateway
  2. OPENIG-4091

Doc: JDBC Datasource: Container independent configuration (OPENIG-1397)

    XMLWordPrintable

Details

    • Task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 4.5.0, 7.0.0-micsvc-1.0.2, 7.0.0
    • 7.0.0
    • Doc

    Description

      New configuration for SqlAttributesFilter - see PR here for details.

      Description:
      The dataSource attribute is now configured like this:

      • New JdbcDataSource object may be supplied as an inline object:
                   ... {
                      "type": "SqlAttributesFilter",
                      "config": {
                        "dataSource": {
                          "type": "JdbcDataSource",
                          "config": {
                            "poolName"            : "AuthDS",
                            "jdbcUrl"             : "jdbc:mysql://localhost:3306/auth",
                            "username"            : "auth2",
                            "passwordSecretId"    : "generic.password"
                          }
                        },
                        ...
                    }
        
      • New JdbcDataSource object may be supplied as reference to a heap object:
                   ... {
                      "type": "SqlAttributesFilter",
                      "config": {
                        "dataSource": "myJdbcDataSource",
                        ...
                    }
        
      • As before (but now deprecated), a JNDI String reference:
                   ... {
                      "type": "SqlAttributesFilter",
                      "config": {
                        "dataSource": "java:/comp/env/jdbc/AuthDS",
                        ...
                    }
        

      JdbcDataSource configuration options are:

      • "poolName": String                                                         [OPTIONAL - pool name]
      • "jdbcUrl" : Configuration expression                          [OPTIONAL *1 - database JDBC URL]
      • "dataSourceClassName": Configuration expression [OPTIONAL *1 - database data source class name]
      • "driverClassName": Configuration expression          [OPTIONAL *2 - database driver class name, if required]
      • "username": Configuration expression                         [OPTIONAL - database user to authenticate with]
      • "passwordSecretId": password Secret ID                 [OPTIONAL - database password to authenticate with]
      • "secretsProvider": Secrets Provider                        [OPTIONAL - secrets provider to use to retrieve password]
      • "properties": object                                                    [OPTIONAL - data source-specific properties: Consult data source-specific
      • "executor : executor                                                         [OPTIONAL - executor used to perform housekeeping, defaults to heap SCHEDULED_EXECUTOR_SERVICE_HEAP_KEY

      *1 Either 'jdbcUrl' or 'dataSourceClassName' should be used depending on the underlying data source support

      *2 'driverClassName' may need to be specified for older JDBC drivers

      Attachments

        Issue Links

          Activity

            People

              joanne.henry Joanne Henry
              wayne.morrison Wayne Morrison
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: