Documentation for Drivers and datasources for WildFly EE9

Drivers and datasources for WildFly EE9

Coordinates §

            
<dependency>
  <groupId>org.wildfly</groupId>
  <artifactId>wildfly-datasources-preview-galleon-pack</artifactId>
  <version>11.2.0.Final</version>
</dependency>

            
<feature-pack>
    <location>org.wildfly:wildfly-datasources-preview-galleon-pack:11.2.0.Final</location>
</feature-pack>

Provided Layers §

db2-datasource
db2-default-datasource
db2-driver
h2database-datasource
h2database-default-datasource
h2database-driver
mariadb-datasource
mariadb-default-datasource
mariadb-driver
mssqlserver-datasource
mssqlserver-default-datasource
mssqlserver-driver
mysql-datasource
mysql-default-datasource
mysql-driver
oracle-datasource
oracle-default-datasource
oracle-driver
postgresql-datasource
postgresql-default-datasource
postgresql-driver

db2-datasource §

Management Model


{
  "subsystem" : {
    "datasources" : {
      "_address" : "/subsystem=datasources",
      "data-source" : {
        "DB2DS" : {
          "_address" : "/subsystem=datasources/data-source=*",
          "attributes" : [ {
            "name" : "background-validation",
            "value" : "${org.wildfly.datasources.db2.background-validation,env.DB2_BACKGROUND_VALIDATION:false}",
            "_address" : "/subsystem=datasources/data-source=*@@@background-validation"
          }, {
            "name" : "background-validation-millis",
            "value" : "${org.wildfly.datasources.db2.background-validation-millis,env.DB2_BACKGROUND_VALIDATION_MILLIS:10000}",
            "_address" : "/subsystem=datasources/data-source=*@@@background-validation-millis"
          }, {
            "name" : "connection-url",
            "value" : "${org.wildfly.datasources.db2.connection-url,env.DB2_URL:jdbc:db2://${org.wildfly.datasources.db2.host,env.DB2_SERVICE_HOST,env.OPENSHIFT_DB2_DB_HOST,env.DB2_HOST:localhost}:${org.wildfly.datasources.db2.port,env.DB2_SERVICE_PORT,env.OPENSHIFT_DB2_DB_PORT,env.DB2_PORT:50000}/${org.wildfly.datasources.db2.database,env.DB2_DATABASE,env.OPENSHIFT_DB2_DB_NAME}}",
            "_address" : "/subsystem=datasources/data-source=*@@@connection-url"
          }, {
            "name" : "driver-name",
            "value" : "db2",
            "_address" : "/subsystem=datasources/data-source=*@@@driver-name"
          }, {
            "name" : "enabled",
            "value" : "${org.wildfly.datasources.db2.enabled, env.DB2_ENABLED:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@enabled"
          }, {
            "name" : "exception-sorter-class-name",
            "value" : "${org.wildfly.datasources.db2.exception-sorter-class-name, env.DB2_EXCEPTION_SORTER:org.jboss.jca.adapters.jdbc.extensions.db2.DB2ExceptionSorter}",
            "_address" : "/subsystem=datasources/data-source=*@@@exception-sorter-class-name"
          }, {
            "name" : "flush-strategy",
            "value" : "${org.wildfly.datasources.db2.flush-strategy,env.DB2_FLUSH_STRATEGY:FailingConnectionOnly}",
            "_address" : "/subsystem=datasources/data-source=*@@@flush-strategy"
          }, {
            "name" : "idle-timeout-minutes",
            "value" : "${org.wildfly.datasources.db2.idle-timeout-minutes,env.DB2_IDLE_TIMEOUT_MINUTES:30}",
            "_address" : "/subsystem=datasources/data-source=*@@@idle-timeout-minutes"
          }, {
            "name" : "jndi-name",
            "value" : "${org.wildfly.datasources.db2.jndi-name,env.DB2_JNDI:java:jboss/datasources/${org.wildfly.datasources.db2.datasource, env.DB2_DATASOURCE,env.OPENSHIFT_DB2_DATASOURCE:DB2DS}}",
            "_address" : "/subsystem=datasources/data-source=*@@@jndi-name"
          }, {
            "name" : "jta",
            "value" : "${org.wildfly.datasources.db2.jta,env.DB2_JTA:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@jta"
          }, {
            "name" : "max-pool-size",
            "value" : "${org.wildfly.datasources.db2.max-pool-size,env.DB2_MAX_POOL_SIZE:20}",
            "_address" : "/subsystem=datasources/data-source=*@@@max-pool-size"
          }, {
            "name" : "min-pool-size",
            "value" : "${org.wildfly.datasources.db2.min-pool-size,env.DB2_MIN_POOL_SIZE:0}",
            "_address" : "/subsystem=datasources/data-source=*@@@min-pool-size"
          }, {
            "name" : "password",
            "value" : "${org.wildfly.datasources.db2.password,env.DB2_PASSWORD,env.OPENSHIFT_DB2_DB_PASSWORD}",
            "_address" : "/subsystem=datasources/data-source=*@@@password"
          }, {
            "name" : "stale-connection-checker-class-name",
            "value" : "${org.wildfly.datasources.db2.stale-connection-checker-class-name,env.DB2_STALE_CONNECTION_CHECKER:org.jboss.jca.adapters.jdbc.extensions.novendor.NullStaleConnectionChecker}",
            "_address" : "/subsystem=datasources/data-source=*@@@stale-connection-checker-class-name"
          }, {
            "name" : "statistics-enabled",
            "value" : "${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}",
            "_address" : "/subsystem=datasources/data-source=*@@@statistics-enabled"
          }, {
            "name" : "transaction-isolation",
            "value" : "${org.wildfly.datasources.db2.transaction-isolation,env.DB2_TX_ISOLATION:TRANSACTION_READ_COMMITTED}",
            "_address" : "/subsystem=datasources/data-source=*@@@transaction-isolation"
          }, {
            "name" : "user-name",
            "value" : "${org.wildfly.datasources.db2.user-name,env.DB2_USER,env.OPENSHIFT_DB2_DB_USERNAME}",
            "_address" : "/subsystem=datasources/data-source=*@@@user-name"
          }, {
            "name" : "valid-connection-checker-class-name",
            "value" : "${org.wildfly.datasources.db2.valid-connection-checker-class-name,env.DB2_CONNECTION_CHECKER:org.jboss.jca.adapters.jdbc.extensions.db2.DB2ValidConnectionChecker}",
            "_address" : "/subsystem=datasources/data-source=*@@@valid-connection-checker-class-name"
          }, {
            "name" : "validate-on-match",
            "value" : "${org.wildfly.datasources.db2.validate-on-match,env.DB2_VALIDATE_ON_MATCH:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@validate-on-match"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required
db2-driver - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.add-on = database,db2
org.wildfly.rule.add-on-depends-on = only:datasources
org.wildfly.rule.add-on-description = Documentation in https://github.com/wildfly-extras/wildfly-datasources-galleon-pack
org.wildfly.rule.add-on-fix-unbound-datasources = JNDI env,DB2_JNDI=##ITEM##
org.wildfly.rule.configuration = https://raw.githubusercontent.com/wildfly-extras/wildfly-datasources-galleon-pack/main/doc/db2/env.yaml

db2-default-datasource §

Management Model


{
  "subsystem" : {
    "ee" : {
      "_address" : "/subsystem=ee",
      "service" : {
        "default-bindings" : {
          "_address" : "/subsystem=ee/service=default-bindings",
          "attributes" : [ {
            "name" : "datasource",
            "value" : "${org.wildfly.datasources.db2.jndi-name,env.DB2_JNDI:java:jboss/datasources/${org.wildfly.datasources.db2.datasource, env.DB2_DATASOURCE,env.OPENSHIFT_DB2_DATASOURCE:DB2DS}}",
            "_address" : "/subsystem=ee/service=default-bindings@@@datasource"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required
db2-datasource - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.add-on = database,db2:default
org.wildfly.rule.add-on-depends-on = only:datasources
org.wildfly.rule.add-on-description = Documentation in https://github.com/wildfly-extras/wildfly-datasources-galleon-pack
org.wildfly.rule.add-on-fix-no-default-datasource =
org.wildfly.rule.configuration = https://raw.githubusercontent.com/wildfly-extras/wildfly-datasources-galleon-pack/main/doc/db2/env.yaml

db2-driver §

Management Model


{
  "subsystem" : {
    "datasources" : {
      "_address" : "/subsystem=datasources",
      "jdbc-driver" : {
        "db2" : {
          "_address" : "/subsystem=datasources/jdbc-driver=*",
          "attributes" : [ {
            "name" : "driver-module-name",
            "value" : "com.ibm.db2",
            "_address" : "/subsystem=datasources/jdbc-driver=*@@@driver-module-name"
          }, {
            "name" : "driver-xa-datasource-class-name",
            "value" : "com.ibm.db2.jcc.DB2XADataSource",
            "_address" : "/subsystem=datasources/jdbc-driver=*@@@driver-xa-datasource-class-name"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.annotation.field.value-className = jakarta.annotation.sql.DataSourceDefinition,className=com.ibm.db2.jcc.*
org.wildfly.rule.annotation.field.value-url = jakarta.annotation.sql.DataSourceDefinition,url=jdbc:db2:*
org.wildfly.rule.xml-path = [/META-INF/*.xml,/WEB-INF/*.xml],/datasources/datasource/driver,db2
org.wildfly.rule.xml-path-xa = [/META-INF/*.xml,/WEB-INF/*.xml],/datasources/xa-datasource/driver,db2

Packages

com.ibm.db2
org.jboss.as.connector

h2database-datasource §

Management Model


{
  "subsystem" : {
    "datasources" : {
      "_address" : "/subsystem=datasources",
      "data-source" : {
        "H2DatabaseDS" : {
          "_address" : "/subsystem=datasources/data-source=*",
          "attributes" : [ {
            "name" : "background-validation",
            "value" : "${org.wildfly.datasources.h2database.background-validation,env.H2DATABASE_BACKGROUND_VALIDATION:false}",
            "_address" : "/subsystem=datasources/data-source=*@@@background-validation"
          }, {
            "name" : "background-validation-millis",
            "value" : "${org.wildfly.datasources.h2database.background-validation-millis,env.H2DATABASE_BACKGROUND_VALIDATION_MILLIS:10000}",
            "_address" : "/subsystem=datasources/data-source=*@@@background-validation-millis"
          }, {
            "name" : "connection-url",
            "value" : "${org.wildfly.datasources.h2database.connection-url,env.H2DATABASE_URL,env.OPENSHIFT_H2DATABASE_URL:jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE}",
            "_address" : "/subsystem=datasources/data-source=*@@@connection-url"
          }, {
            "name" : "driver-name",
            "value" : "h2database",
            "_address" : "/subsystem=datasources/data-source=*@@@driver-name"
          }, {
            "name" : "enabled",
            "value" : "${org.wildfly.datasources.h2database.enabled, env.H2DATABASE_ENABLED:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@enabled"
          }, {
            "name" : "exception-sorter-class-name",
            "value" : "${org.wildfly.datasources.h2database.exception-sorter-class-name,env.H2DATABASE_EXCEPTION_SORTER:org.jboss.jca.adapters.jdbc.extensions.novendor.NullExceptionSorter}",
            "_address" : "/subsystem=datasources/data-source=*@@@exception-sorter-class-name"
          }, {
            "name" : "flush-strategy",
            "value" : "${org.wildfly.datasources.h2database.flush-strategy,env.H2DATABASE_FLUSH_STRATEGY:FailingConnectionOnly}",
            "_address" : "/subsystem=datasources/data-source=*@@@flush-strategy"
          }, {
            "name" : "idle-timeout-minutes",
            "value" : "${org.wildfly.datasources.h2database.idle-timeout-minutes,env.H2DATABASE_IDLE_TIMEOUT_MINUTES:30}",
            "_address" : "/subsystem=datasources/data-source=*@@@idle-timeout-minutes"
          }, {
            "name" : "jndi-name",
            "value" : "${org.wildfly.datasources.h2database.jndi-name,env.H2DATABASE_JNDI:java:jboss/datasources/${org.wildfly.datasources.h2database.datasource, env.H2DATABASE_DATASOURCE,env.OPENSHIFT_H2DATABASE_DATASOURCE:H2DatabaseDS}}",
            "_address" : "/subsystem=datasources/data-source=*@@@jndi-name"
          }, {
            "name" : "jta",
            "value" : "${org.wildfly.datasources.h2database.jta,env.H2DATABASE_JTA:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@jta"
          }, {
            "name" : "max-pool-size",
            "value" : "${org.wildfly.datasources.h2database.max-pool-size,env.H2DATABASE_MAX_POOL_SIZE:20}",
            "_address" : "/subsystem=datasources/data-source=*@@@max-pool-size"
          }, {
            "name" : "min-pool-size",
            "value" : "${org.wildfly.datasources.h2database.min-pool-size,env.H2DATABASE_MIN_POOL_SIZE:0}",
            "_address" : "/subsystem=datasources/data-source=*@@@min-pool-size"
          }, {
            "name" : "password",
            "value" : "${org.wildfly.datasources.h2database.password,env.H2DATABASE_PASSWORD,env.OPENSHIFT_H2DATABASE_DB_PASSWORD:sa}",
            "_address" : "/subsystem=datasources/data-source=*@@@password"
          }, {
            "name" : "stale-connection-checker-class-name",
            "value" : "${org.wildfly.datasources.h2database.stale-connection-checker-class-name,env.H2DATABASE_STALE_CONNECTION_CHECKER:org.jboss.jca.adapters.jdbc.extensions.novendor.NullStaleConnectionChecker}",
            "_address" : "/subsystem=datasources/data-source=*@@@stale-connection-checker-class-name"
          }, {
            "name" : "statistics-enabled",
            "value" : "${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}",
            "_address" : "/subsystem=datasources/data-source=*@@@statistics-enabled"
          }, {
            "name" : "transaction-isolation",
            "value" : "${org.wildfly.datasources.h2database.transaction-isolation,env.H2DATABASE_TX_ISOLATION:TRANSACTION_READ_COMMITTED}",
            "_address" : "/subsystem=datasources/data-source=*@@@transaction-isolation"
          }, {
            "name" : "user-name",
            "value" : "${org.wildfly.datasources.h2database.user-name,env.H2DATABASE_USER,env.OPENSHIFT_H2DATABASE_DB_USERNAME:sa}",
            "_address" : "/subsystem=datasources/data-source=*@@@user-name"
          }, {
            "name" : "valid-connection-checker-class-name",
            "value" : "${org.wildfly.datasources.h2database.valid-connection-checker-class-name,env.H2DATABASE_CONNECTION_CHECKER:org.jboss.jca.adapters.jdbc.extensions.novendor.NullValidConnectionChecker}",
            "_address" : "/subsystem=datasources/data-source=*@@@valid-connection-checker-class-name"
          }, {
            "name" : "validate-on-match",
            "value" : "${org.wildfly.datasources.h2database.validate-on-match,env.H2DATABASE_VALIDATE_ON_MATCH:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@validate-on-match"
          } ]
        }
      }
    }
  }
}

Dependencies

h2database-driver - required

h2database-default-datasource §

Management Model


{
  "subsystem" : {
    "ee" : {
      "_address" : "/subsystem=ee",
      "service" : {
        "default-bindings" : {
          "_address" : "/subsystem=ee/service=default-bindings",
          "attributes" : [ {
            "name" : "datasource",
            "value" : "java:jboss/datasources/${env.H2DATABASE_DATASOURCE:H2DatabaseDS}",
            "_address" : "/subsystem=ee/service=default-bindings@@@datasource"
          } ]
        }
      }
    }
  }
}

Dependencies

h2database-datasource - required

h2database-driver §

Management Model


{
  "subsystem" : {
    "datasources" : {
      "_address" : "/subsystem=datasources",
      "jdbc-driver" : {
        "h2database" : {
          "_address" : "/subsystem=datasources/jdbc-driver=*",
          "attributes" : [ {
            "name" : "driver-module-name",
            "value" : "com.h2database.h2database",
            "_address" : "/subsystem=datasources/jdbc-driver=*@@@driver-module-name"
          }, {
            "name" : "driver-xa-datasource-class-name",
            "value" : "org.h2.jdbcx.JdbcDataSource",
            "_address" : "/subsystem=datasources/jdbc-driver=*@@@driver-xa-datasource-class-name"
          } ]
        }
      }
    }
  }
}

Packages

com.h2database.h2database
org.jboss.as.connector

mariadb-datasource §

Management Model


{
  "subsystem" : {
    "datasources" : {
      "_address" : "/subsystem=datasources",
      "data-source" : {
        "MariaDBDS" : {
          "_address" : "/subsystem=datasources/data-source=*",
          "attributes" : [ {
            "name" : "background-validation",
            "value" : "${org.wildfly.datasources.mariadb.background-validation,env.MARIADB_BACKGROUND_VALIDATION:false}",
            "_address" : "/subsystem=datasources/data-source=*@@@background-validation"
          }, {
            "name" : "background-validation-millis",
            "value" : "${org.wildfly.datasources.mariadb.background-validation-millis,env.MARIADB_BACKGROUND_VALIDATION_MILLIS:10000}",
            "_address" : "/subsystem=datasources/data-source=*@@@background-validation-millis"
          }, {
            "name" : "connection-url",
            "value" : "${org.wildfly.datasources.mariadb.connection-url,env.MARIADB_URL:jdbc:mariadb://${org.wildfly.datasources.mariadb.host,env.MARIADB_SERVICE_HOST,env.MARIADB_HOST:localhost}:${org.wildfly.datasources.mariadb.port,env.MARIADB_SERVICE_PORT,env.MARIADB_PORT:3306}/${org.wildfly.datasources.mariadb.database,env.MARIADB_DATABASE}}",
            "_address" : "/subsystem=datasources/data-source=*@@@connection-url"
          }, {
            "name" : "driver-name",
            "value" : "mariadb",
            "_address" : "/subsystem=datasources/data-source=*@@@driver-name"
          }, {
            "name" : "enabled",
            "value" : "${org.wildfly.datasources.mariadb.enabled,env.MARIADB_ENABLED:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@enabled"
          }, {
            "name" : "exception-sorter-class-name",
            "value" : "${org.wildfly.datasources.mariadb.exception-sorter-class-name,env.MARIADB_EXCEPTION_SORTER:org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter}",
            "_address" : "/subsystem=datasources/data-source=*@@@exception-sorter-class-name"
          }, {
            "name" : "flush-strategy",
            "value" : "${org.wildfly.datasources.mariadb.flush-strategy,env.MARIADB_FLUSH_STRATEGY:FailingConnectionOnly}",
            "_address" : "/subsystem=datasources/data-source=*@@@flush-strategy"
          }, {
            "name" : "idle-timeout-minutes",
            "value" : "${org.wildfly.datasources.mariadb.idle-timeout-minutes,env.MARIADB_IDLE_TIMEOUT_MINUTES:30}",
            "_address" : "/subsystem=datasources/data-source=*@@@idle-timeout-minutes"
          }, {
            "name" : "jndi-name",
            "value" : "${org.wildfly.datasources.mariadb.jndi-name,env.MARIADB_JNDI:java:jboss/datasources/${org.wildfly.datasources.mariadb.datasource,env.MARIADB_DATASOURCE:MariaDBDS}}",
            "_address" : "/subsystem=datasources/data-source=*@@@jndi-name"
          }, {
            "name" : "jta",
            "value" : "${org.wildfly.datasources.mariadb.jta,env.MARIADB_JTA:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@jta"
          }, {
            "name" : "max-pool-size",
            "value" : "${org.wildfly.datasources.mariadb.max-pool-size,env.MARIADB_MAX_POOL_SIZE:20}",
            "_address" : "/subsystem=datasources/data-source=*@@@max-pool-size"
          }, {
            "name" : "min-pool-size",
            "value" : "${org.wildfly.datasources.mariadb.min-pool-size,env.MARIADB_MIN_POOL_SIZE:0}",
            "_address" : "/subsystem=datasources/data-source=*@@@min-pool-size"
          }, {
            "name" : "password",
            "value" : "${org.wildfly.datasources.mariadb.password,env.MARIADB_PASSWORD}",
            "_address" : "/subsystem=datasources/data-source=*@@@password"
          }, {
            "name" : "stale-connection-checker-class-name",
            "value" : "${org.wildfly.datasources.mariadb.stale-connection-checker-class-name,env.MARIADB_STALE_CONNECTION_CHECKER:org.jboss.jca.adapters.jdbc.extensions.novendor.NullStaleConnectionChecker}",
            "_address" : "/subsystem=datasources/data-source=*@@@stale-connection-checker-class-name"
          }, {
            "name" : "statistics-enabled",
            "value" : "${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}",
            "_address" : "/subsystem=datasources/data-source=*@@@statistics-enabled"
          }, {
            "name" : "transaction-isolation",
            "value" : "${org.wildfly.datasources.mariadb.transaction-isolation,env.MARIADB_TX_ISOLATION:TRANSACTION_READ_COMMITTED}",
            "_address" : "/subsystem=datasources/data-source=*@@@transaction-isolation"
          }, {
            "name" : "user-name",
            "value" : "${org.wildfly.datasources.mariadb.user-name,env.MARIADB_USER}",
            "_address" : "/subsystem=datasources/data-source=*@@@user-name"
          }, {
            "name" : "valid-connection-checker-class-name",
            "value" : "${org.wildfly.datasources.mariadb.valid-connection-checker-class-name,env.MARIADB_CONNECTION_CHECKER:org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker}",
            "_address" : "/subsystem=datasources/data-source=*@@@valid-connection-checker-class-name"
          }, {
            "name" : "validate-on-match",
            "value" : "${org.wildfly.datasources.mariadb.validate-on-match,env.MARIADB_VALIDATE_ON_MATCH:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@validate-on-match"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required
mariadb-driver - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.add-on = database,mariadb
org.wildfly.rule.add-on-depends-on = only:datasources
org.wildfly.rule.add-on-description = Documentation in https://github.com/wildfly-extras/wildfly-datasources-galleon-pack
org.wildfly.rule.add-on-fix-unbound-datasources = JNDI env,MARIADB_JNDI=##ITEM##
org.wildfly.rule.configuration = https://raw.githubusercontent.com/wildfly-extras/wildfly-datasources-galleon-pack/main/doc/mariadb/env.yaml

mariadb-default-datasource §

Management Model


{
  "subsystem" : {
    "ee" : {
      "_address" : "/subsystem=ee",
      "service" : {
        "default-bindings" : {
          "_address" : "/subsystem=ee/service=default-bindings",
          "attributes" : [ {
            "name" : "datasource",
            "value" : "java:jboss/datasources/${env.MARIADB_DATASOURCE:MariaDBDS}",
            "_address" : "/subsystem=ee/service=default-bindings@@@datasource"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required
mariadb-datasource - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.add-on = database,mariadb:default
org.wildfly.rule.add-on-depends-on = only:datasources
org.wildfly.rule.add-on-description = Documentation in https://github.com/wildfly-extras/wildfly-datasources-galleon-pack
org.wildfly.rule.add-on-fix-no-default-datasource =
org.wildfly.rule.configuration = https://raw.githubusercontent.com/wildfly-extras/wildfly-datasources-galleon-pack/main/doc/mariadb/env.yaml

mariadb-driver §

Management Model


{
  "subsystem" : {
    "datasources" : {
      "_address" : "/subsystem=datasources",
      "jdbc-driver" : {
        "mariadb" : {
          "_address" : "/subsystem=datasources/jdbc-driver=*",
          "attributes" : [ {
            "name" : "driver-module-name",
            "value" : "org.mariadb.jdbc",
            "_address" : "/subsystem=datasources/jdbc-driver=*@@@driver-module-name"
          }, {
            "name" : "driver-xa-datasource-class-name",
            "value" : "org.mariadb.jdbc.MariaDbDataSource",
            "_address" : "/subsystem=datasources/jdbc-driver=*@@@driver-xa-datasource-class-name"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.annotation.field.value-className = jakarta.annotation.sql.DataSourceDefinition,className=org.mariadb.*
org.wildfly.rule.annotation.field.value-url = jakarta.annotation.sql.DataSourceDefinition,url=jdbc:mariadb:*
org.wildfly.rule.xml-path = [/META-INF/*.xml,/WEB-INF/*.xml],/datasources/datasource/driver,mariadb
org.wildfly.rule.xml-path-xa = [/META-INF/*.xml,/WEB-INF/*.xml],/datasources/xa-datasource/driver,mariadb

Packages

org.jboss.as.connector
org.mariadb.jdbc

mssqlserver-datasource §

Management Model


{
  "subsystem" : {
    "datasources" : {
      "_address" : "/subsystem=datasources",
      "data-source" : {
        "MSSQLServerDS" : {
          "_address" : "/subsystem=datasources/data-source=*",
          "attributes" : [ {
            "name" : "background-validation",
            "value" : "${org.wildfly.datasources.mssqlserver.background-validation,env.MSSQLSERVER_BACKGROUND_VALIDATION:false}",
            "_address" : "/subsystem=datasources/data-source=*@@@background-validation"
          }, {
            "name" : "background-validation-millis",
            "value" : "${org.wildfly.datasources.mssqlserver.background-validation-millis,env.MSSQLSERVER_BACKGROUND_VALIDATION_MILLIS:10000}",
            "_address" : "/subsystem=datasources/data-source=*@@@background-validation-millis"
          }, {
            "name" : "connection-url",
            "value" : "${org.wildfly.datasources.mssqlserver.connection-url,env.MSSQLSERVER_URL:jdbc:sqlserver://${org.wildfly.datasources.mssqlserver.host,env.MSSQLSERVER_SERVICE_HOST,env.MSSQLSERVER_HOST:localhost}:${org.wildfly.datasources.mssqlserver.port,env.MSSQLSERVER_SERVICE_PORT,env.MSSQLSERVER_PORT:1433};DatabaseName\\=${org.wildfly.datasources.mssqlserver.database,env.MSSQLSERVER_DATABASE}}",
            "_address" : "/subsystem=datasources/data-source=*@@@connection-url"
          }, {
            "name" : "driver-name",
            "value" : "mssqlserver",
            "_address" : "/subsystem=datasources/data-source=*@@@driver-name"
          }, {
            "name" : "enabled",
            "value" : "${org.wildfly.datasources.mssqlserver.enabled, env.MSSQLSERVER_ENABLED:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@enabled"
          }, {
            "name" : "exception-sorter-class-name",
            "value" : "${org.wildfly.datasources.mssqlserver.exception-sorter-class-name, env.MSSQLSERVER_EXCEPTION_SORTER:org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLExceptionSorter}",
            "_address" : "/subsystem=datasources/data-source=*@@@exception-sorter-class-name"
          }, {
            "name" : "flush-strategy",
            "value" : "${org.wildfly.datasources.mssqlserver.flush-strategy,env.MSSQLSERVER_FLUSH_STRATEGY:FailingConnectionOnly}",
            "_address" : "/subsystem=datasources/data-source=*@@@flush-strategy"
          }, {
            "name" : "idle-timeout-minutes",
            "value" : "${org.wildfly.datasources.mssqlserver.idle-timeout-minutes,env.MSSQLSERVER_IDLE_TIMEOUT_MINUTES:30}",
            "_address" : "/subsystem=datasources/data-source=*@@@idle-timeout-minutes"
          }, {
            "name" : "jndi-name",
            "value" : "${org.wildfly.datasources.mssqlserver.jndi-name,env.MSSQLSERVER_JNDI:java:jboss/datasources/${org.wildfly.datasources.mssqlserver.datasource, env.MSSQLSERVER_DATASOURCE:MSSQLServerDS}}",
            "_address" : "/subsystem=datasources/data-source=*@@@jndi-name"
          }, {
            "name" : "jta",
            "value" : "${org.wildfly.datasources.mssqlserver.jta,env.MSSQLSERVER_JTA:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@jta"
          }, {
            "name" : "max-pool-size",
            "value" : "${org.wildfly.datasources.mssqlserver.max-pool-size,env.MSSQLSERVER_MAX_POOL_SIZE:20}",
            "_address" : "/subsystem=datasources/data-source=*@@@max-pool-size"
          }, {
            "name" : "min-pool-size",
            "value" : "${org.wildfly.datasources.mssqlserver.min-pool-size,env.MSSQLSERVER_MIN_POOL_SIZE:0}",
            "_address" : "/subsystem=datasources/data-source=*@@@min-pool-size"
          }, {
            "name" : "password",
            "value" : "${org.wildfly.datasources.mssqlserver.password,env.MSSQLSERVER_PASSWORD}",
            "_address" : "/subsystem=datasources/data-source=*@@@password"
          }, {
            "name" : "stale-connection-checker-class-name",
            "value" : "${org.wildfly.datasources.mssqlserver.stale-connection-checker-class-name,env.MSSQLSERVER_STALE_CONNECTION_CHECKER:org.jboss.jca.adapters.jdbc.extensions.novendor.NullStaleConnectionChecker}",
            "_address" : "/subsystem=datasources/data-source=*@@@stale-connection-checker-class-name"
          }, {
            "name" : "statistics-enabled",
            "value" : "${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}",
            "_address" : "/subsystem=datasources/data-source=*@@@statistics-enabled"
          }, {
            "name" : "transaction-isolation",
            "value" : "${org.wildfly.datasources.mssqlserver.transaction-isolation,env.MSSQLSERVER_TX_ISOLATION:TRANSACTION_READ_COMMITTED}",
            "_address" : "/subsystem=datasources/data-source=*@@@transaction-isolation"
          }, {
            "name" : "user-name",
            "value" : "${org.wildfly.datasources.mssqlserver.user-name,env.MSSQLSERVER_USER}",
            "_address" : "/subsystem=datasources/data-source=*@@@user-name"
          }, {
            "name" : "valid-connection-checker-class-name",
            "value" : "${org.wildfly.datasources.mssqlserver.valid-connection-checker-class-name,env.MSSQLSERVER_CONNECTION_CHECKER:org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker}",
            "_address" : "/subsystem=datasources/data-source=*@@@valid-connection-checker-class-name"
          }, {
            "name" : "validate-on-match",
            "value" : "${org.wildfly.datasources.mssqlserver.validate-on-match,env.MSSQLSERVER_VALIDATE_ON_MATCH:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@validate-on-match"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required
mssqlserver-driver - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.add-on = database,mssqlserver
org.wildfly.rule.add-on-depends-on = only:datasources
org.wildfly.rule.add-on-description = Documentation in https://github.com/wildfly-extras/wildfly-datasources-galleon-pack
org.wildfly.rule.add-on-fix-unbound-datasources = JNDI env,MSSQLSERVER_JNDI=##ITEM##
org.wildfly.rule.configuration = https://raw.githubusercontent.com/wildfly-extras/wildfly-datasources-galleon-pack/main/doc/mssqlserver/env.yaml

mssqlserver-default-datasource §

Management Model


{
  "subsystem" : {
    "ee" : {
      "_address" : "/subsystem=ee",
      "service" : {
        "default-bindings" : {
          "_address" : "/subsystem=ee/service=default-bindings",
          "attributes" : [ {
            "name" : "datasource",
            "value" : "java:jboss/datasources/${env.MSSQLSERVER_DATASOURCE:MSSQLServerDS}",
            "_address" : "/subsystem=ee/service=default-bindings@@@datasource"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required
mssqlserver-datasource - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.add-on = database,mssqlserver:default
org.wildfly.rule.add-on-depends-on = only:datasources
org.wildfly.rule.add-on-description = Documentation in https://github.com/wildfly-extras/wildfly-datasources-galleon-pack
org.wildfly.rule.add-on-fix-no-default-datasource =
org.wildfly.rule.configuration = https://raw.githubusercontent.com/wildfly-extras/wildfly-datasources-galleon-pack/main/doc/mssqlserver/env.yaml

mssqlserver-driver §

Management Model


{
  "subsystem" : {
    "datasources" : {
      "_address" : "/subsystem=datasources",
      "jdbc-driver" : {
        "mssqlserver" : {
          "_address" : "/subsystem=datasources/jdbc-driver=*",
          "attributes" : [ {
            "name" : "driver-module-name",
            "value" : "com.microsoft.sqlserver",
            "_address" : "/subsystem=datasources/jdbc-driver=*@@@driver-module-name"
          }, {
            "name" : "driver-xa-datasource-class-name",
            "value" : "com.microsoft.sqlserver.jdbc.SQLServerXADataSource",
            "_address" : "/subsystem=datasources/jdbc-driver=*@@@driver-xa-datasource-class-name"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.annotation.field.value-className = jakarta.annotation.sql.DataSourceDefinition,className=com.microsoft.*
org.wildfly.rule.annotation.field.value-url = jakarta.annotation.sql.DataSourceDefinition,url=jdbc:sqlserver:*
org.wildfly.rule.xml-path = [/META-INF/*.xml,/WEB-INF/*.xml],/datasources/datasource/driver,mssqlserver
org.wildfly.rule.xml-path-xa = [/META-INF/*.xml,/WEB-INF/*.xml],/datasources/xa-datasource/driver,mssqlserver

Packages

com.microsoft.sqlserver
org.jboss.as.connector

mysql-datasource §

Management Model


{
  "subsystem" : {
    "datasources" : {
      "_address" : "/subsystem=datasources",
      "data-source" : {
        "MySQLDS" : {
          "_address" : "/subsystem=datasources/data-source=*",
          "attributes" : [ {
            "name" : "background-validation",
            "value" : "${org.wildfly.datasources.mysql.background-validation,env.MYSQL_BACKGROUND_VALIDATION:false}",
            "_address" : "/subsystem=datasources/data-source=*@@@background-validation"
          }, {
            "name" : "background-validation-millis",
            "value" : "${org.wildfly.datasources.mysql.background-validation-millis,env.MYSQL_BACKGROUND_VALIDATION_MILLIS:10000}",
            "_address" : "/subsystem=datasources/data-source=*@@@background-validation-millis"
          }, {
            "name" : "connection-url",
            "value" : "${org.wildfly.datasources.mysql.connection-url,env.MYSQL_URL:jdbc:mysql://${org.wildfly.datasources.mysql.host,env.MYSQL_SERVICE_HOST,env.OPENSHIFT_MYSQL_DB_HOST,env.MYSQL_HOST:localhost}:${org.wildfly.datasources.mysql.port,env.MYSQL_SERVICE_PORT,env.OPENSHIFT_MYSQL_DB_PORT,env.MYSQL_PORT:3306}/${org.wildfly.datasources.mysql.database,env.MYSQL_DATABASE,env.OPENSHIFT_MYSQL_DB_NAME}}",
            "_address" : "/subsystem=datasources/data-source=*@@@connection-url"
          }, {
            "name" : "driver-name",
            "value" : "mysql",
            "_address" : "/subsystem=datasources/data-source=*@@@driver-name"
          }, {
            "name" : "enabled",
            "value" : "${org.wildfly.datasources.mysql.enabled, env.MYSQL_ENABLED:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@enabled"
          }, {
            "name" : "exception-sorter-class-name",
            "value" : "${org.wildfly.datasources.mysql.exception-sorter-class-name, env.MYSQL_EXCEPTION_SORTER:org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter}",
            "_address" : "/subsystem=datasources/data-source=*@@@exception-sorter-class-name"
          }, {
            "name" : "flush-strategy",
            "value" : "${org.wildfly.datasources.mysql.flush-strategy,env.MYSQL_FLUSH_STRATEGY:FailingConnectionOnly}",
            "_address" : "/subsystem=datasources/data-source=*@@@flush-strategy"
          }, {
            "name" : "idle-timeout-minutes",
            "value" : "${org.wildfly.datasources.mysql.idle-timeout-minutes,env.MYSQL_IDLE_TIMEOUT_MINUTES:30}",
            "_address" : "/subsystem=datasources/data-source=*@@@idle-timeout-minutes"
          }, {
            "name" : "jndi-name",
            "value" : "${org.wildfly.datasources.mysql.jndi-name,env.MYSQL_JNDI:java:jboss/datasources/${org.wildfly.datasources.mysql.datasource,env.OPENSHIFT_MYSQL_DATASOURCE,env.MYSQL_DATASOURCE:MySQLDS}}",
            "_address" : "/subsystem=datasources/data-source=*@@@jndi-name"
          }, {
            "name" : "jta",
            "value" : "${org.wildfly.datasources.mysql.jta,env.MYSQL_JTA:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@jta"
          }, {
            "name" : "max-pool-size",
            "value" : "${org.wildfly.datasources.mysql.max-pool-size,env.MYSQL_MAX_POOL_SIZE:20}",
            "_address" : "/subsystem=datasources/data-source=*@@@max-pool-size"
          }, {
            "name" : "min-pool-size",
            "value" : "${org.wildfly.datasources.mysql.min-pool-size,env.MYSQL_MIN_POOL_SIZE:0}",
            "_address" : "/subsystem=datasources/data-source=*@@@min-pool-size"
          }, {
            "name" : "password",
            "value" : "${org.wildfly.datasources.mysql.password,env.MYSQL_PASSWORD,env.OPENSHIFT_MYSQL_DB_PASSWORD}",
            "_address" : "/subsystem=datasources/data-source=*@@@password"
          }, {
            "name" : "stale-connection-checker-class-name",
            "value" : "${org.wildfly.datasources.mysql.stale-connection-checker-class-name,env.MYSQL_STALE_CONNECTION_CHECKER:org.jboss.jca.adapters.jdbc.extensions.novendor.NullStaleConnectionChecker}",
            "_address" : "/subsystem=datasources/data-source=*@@@stale-connection-checker-class-name"
          }, {
            "name" : "statistics-enabled",
            "value" : "${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}",
            "_address" : "/subsystem=datasources/data-source=*@@@statistics-enabled"
          }, {
            "name" : "transaction-isolation",
            "value" : "${org.wildfly.datasources.mysql.transaction-isolation,env.MYSQL_TX_ISOLATION:TRANSACTION_READ_COMMITTED}",
            "_address" : "/subsystem=datasources/data-source=*@@@transaction-isolation"
          }, {
            "name" : "user-name",
            "value" : "${org.wildfly.datasources.mysql.user-name,env.MYSQL_USER,env.OPENSHIFT_MYSQL_DB_USERNAME}",
            "_address" : "/subsystem=datasources/data-source=*@@@user-name"
          }, {
            "name" : "valid-connection-checker-class-name",
            "value" : "${org.wildfly.datasources.mysql.valid-connection-checker-class-name,env.MYSQL_CONNECTION_CHECKER:org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker}",
            "_address" : "/subsystem=datasources/data-source=*@@@valid-connection-checker-class-name"
          }, {
            "name" : "validate-on-match",
            "value" : "${org.wildfly.datasources.mysql.validate-on-match,env.MYSQL_VALIDATE_ON_MATCH:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@validate-on-match"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required
mysql-driver - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.add-on = database,mysql
org.wildfly.rule.add-on-depends-on = only:datasources
org.wildfly.rule.add-on-description = Documentation in https://github.com/wildfly-extras/wildfly-datasources-galleon-pack
org.wildfly.rule.add-on-fix-unbound-datasources = JNDI env,MYSQL_JNDI=##ITEM##
org.wildfly.rule.configuration = https://raw.githubusercontent.com/wildfly-extras/wildfly-datasources-galleon-pack/main/doc/mysql/env.yaml

mysql-default-datasource §

Management Model


{
  "subsystem" : {
    "ee" : {
      "_address" : "/subsystem=ee",
      "service" : {
        "default-bindings" : {
          "_address" : "/subsystem=ee/service=default-bindings",
          "attributes" : [ {
            "name" : "datasource",
            "value" : "java:jboss/datasources/${env.OPENSHIFT_MYSQL_DATASOURCE,env.MYSQL_DATASOURCE:MySQLDS}",
            "_address" : "/subsystem=ee/service=default-bindings@@@datasource"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required
mysql-datasource - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.add-on = database,mysql:default
org.wildfly.rule.add-on-depends-on = only:datasources
org.wildfly.rule.add-on-description = Documentation in https://github.com/wildfly-extras/wildfly-datasources-galleon-pack
org.wildfly.rule.add-on-fix-no-default-datasource =
org.wildfly.rule.configuration = https://raw.githubusercontent.com/wildfly-extras/wildfly-datasources-galleon-pack/main/doc/mysql/env.yaml

mysql-driver §

Management Model


{
  "subsystem" : {
    "datasources" : {
      "_address" : "/subsystem=datasources",
      "jdbc-driver" : {
        "mysql" : {
          "_address" : "/subsystem=datasources/jdbc-driver=*",
          "attributes" : [ {
            "name" : "driver-module-name",
            "value" : "com.mysql.jdbc",
            "_address" : "/subsystem=datasources/jdbc-driver=*@@@driver-module-name"
          }, {
            "name" : "driver-xa-datasource-class-name",
            "value" : "com.mysql.cj.jdbc.MysqlXADataSource",
            "_address" : "/subsystem=datasources/jdbc-driver=*@@@driver-xa-datasource-class-name"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.annotation.field.value-className = jakarta.annotation.sql.DataSourceDefinition,className=com.mysql.*
org.wildfly.rule.annotation.field.value-url = jakarta.annotation.sql.DataSourceDefinition,url=jdbc:mysql:*
org.wildfly.rule.xml-path = [/META-INF/*.xml,/WEB-INF/*.xml],/datasources/datasource/driver,mysql
org.wildfly.rule.xml-path-xa = [/META-INF/*.xml,/WEB-INF/*.xml],/datasources/xa-datasource/driver,mysql

Packages

com.mysql.jdbc
org.jboss.as.connector

oracle-datasource §

Management Model


{
  "subsystem" : {
    "datasources" : {
      "_address" : "/subsystem=datasources",
      "data-source" : {
        "OracleDS" : {
          "_address" : "/subsystem=datasources/data-source=*",
          "attributes" : [ {
            "name" : "background-validation",
            "value" : "${org.wildfly.datasources.oracle.background-validation,env.ORACLE_BACKGROUND_VALIDATION:false}",
            "_address" : "/subsystem=datasources/data-source=*@@@background-validation"
          }, {
            "name" : "background-validation-millis",
            "value" : "${org.wildfly.datasources.oracle.background-validation-millis,env.ORACLE_BACKGROUND_VALIDATION_MILLIS:10000}",
            "_address" : "/subsystem=datasources/data-source=*@@@background-validation-millis"
          }, {
            "name" : "connection-url",
            "value" : "${org.wildfly.datasources.oracle.connection-url,env.ORACLE_URL,env.OPENSHIFT_ORACLE_URL}",
            "_address" : "/subsystem=datasources/data-source=*@@@connection-url"
          }, {
            "name" : "driver-name",
            "value" : "oracle",
            "_address" : "/subsystem=datasources/data-source=*@@@driver-name"
          }, {
            "name" : "enabled",
            "value" : "${org.wildfly.datasources.oracle.enabled,env.ORACLE_ENABLED:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@enabled"
          }, {
            "name" : "exception-sorter-class-name",
            "value" : "${org.wildfly.datasources.oracle.exception-sorter-class-name,env.ORACLE_EXCEPTION_SORTER:org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter}",
            "_address" : "/subsystem=datasources/data-source=*@@@exception-sorter-class-name"
          }, {
            "name" : "flush-strategy",
            "value" : "${org.wildfly.datasources.oracle.flush-strategy,env.ORACLE_FLUSH_STRATEGY:FailingConnectionOnly}",
            "_address" : "/subsystem=datasources/data-source=*@@@flush-strategy"
          }, {
            "name" : "idle-timeout-minutes",
            "value" : "${org.wildfly.datasources.oracle.idle-timeout-minutes,env.ORACLE_IDLE_TIMEOUT_MINUTES:30}",
            "_address" : "/subsystem=datasources/data-source=*@@@idle-timeout-minutes"
          }, {
            "name" : "jndi-name",
            "value" : "${org.wildfly.datasources.oracle.jndi-name,env.ORACLE_JNDI:java:jboss/datasources/${org.wildfly.datasources.oracle.datasource,env.ORACLE_DATASOURCE,env.OPENSHIFT_ORACLE_DATASOURCE:OracleDS}}",
            "_address" : "/subsystem=datasources/data-source=*@@@jndi-name"
          }, {
            "name" : "jta",
            "value" : "${org.wildfly.datasources.oracle.jta,env.ORACLE_JTA:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@jta"
          }, {
            "name" : "max-pool-size",
            "value" : "${org.wildfly.datasources.oracle.max-pool-size,env.ORACLE_MAX_POOL_SIZE:20}",
            "_address" : "/subsystem=datasources/data-source=*@@@max-pool-size"
          }, {
            "name" : "min-pool-size",
            "value" : "${org.wildfly.datasources.oracle.min-pool-size,env.ORACLE_MIN_POOL_SIZE:0}",
            "_address" : "/subsystem=datasources/data-source=*@@@min-pool-size"
          }, {
            "name" : "password",
            "value" : "${org.wildfly.datasources.oracle.password,env.ORACLE_PASSWORD,env.OPENSHIFT_ORACLE_DB_PASSWORD}",
            "_address" : "/subsystem=datasources/data-source=*@@@password"
          }, {
            "name" : "stale-connection-checker-class-name",
            "value" : "${org.wildfly.datasources.oracle.stale-connection-checker-class-name,env.ORACLE_STALE_CONNECTION_CHECKER:org.jboss.jca.adapters.jdbc.extensions.novendor.NullStaleConnectionChecker}",
            "_address" : "/subsystem=datasources/data-source=*@@@stale-connection-checker-class-name"
          }, {
            "name" : "statistics-enabled",
            "value" : "${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}",
            "_address" : "/subsystem=datasources/data-source=*@@@statistics-enabled"
          }, {
            "name" : "transaction-isolation",
            "value" : "${org.wildfly.datasources.oracle.transaction-isolation,env.ORACLE_TX_ISOLATION:TRANSACTION_READ_COMMITTED}",
            "_address" : "/subsystem=datasources/data-source=*@@@transaction-isolation"
          }, {
            "name" : "user-name",
            "value" : "${org.wildfly.datasources.oracle.user-name,env.ORACLE_USER,env.OPENSHIFT_ORACLE_DB_USERNAME}",
            "_address" : "/subsystem=datasources/data-source=*@@@user-name"
          }, {
            "name" : "valid-connection-checker-class-name",
            "value" : "${org.wildfly.datasources.oracle.valid-connection-checker-class-name,env.ORACLE_CONNECTION_CHECKER:org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker}",
            "_address" : "/subsystem=datasources/data-source=*@@@valid-connection-checker-class-name"
          }, {
            "name" : "validate-on-match",
            "value" : "${org.wildfly.datasources.oracle.validate-on-match,env.ORACLE_VALIDATE_ON_MATCH:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@validate-on-match"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required
oracle-driver - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.add-on = database,oracle
org.wildfly.rule.add-on-depends-on = only:datasources
org.wildfly.rule.add-on-description = Documentation in https://github.com/wildfly-extras/wildfly-datasources-galleon-pack
org.wildfly.rule.add-on-fix-unbound-datasources = JNDI env,ORACLE_JNDI=##ITEM##
org.wildfly.rule.configuration = https://raw.githubusercontent.com/wildfly-extras/wildfly-datasources-galleon-pack/main/doc/oracle/env.yaml

oracle-default-datasource §

Management Model


{
  "subsystem" : {
    "ee" : {
      "_address" : "/subsystem=ee",
      "service" : {
        "default-bindings" : {
          "_address" : "/subsystem=ee/service=default-bindings",
          "attributes" : [ {
            "name" : "datasource",
            "value" : "java:jboss/datasources/${env.ORACLE_DATASOURCE,env.OPENSHIFT_ORACLE_DATASOURCE:OracleDS}",
            "_address" : "/subsystem=ee/service=default-bindings@@@datasource"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required
oracle-datasource - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.add-on = database,oracle:default
org.wildfly.rule.add-on-depends-on = only:datasources
org.wildfly.rule.add-on-description = Documentation in https://github.com/wildfly-extras/wildfly-datasources-galleon-pack
org.wildfly.rule.add-on-fix-no-default-datasource =
org.wildfly.rule.configuration = https://raw.githubusercontent.com/wildfly-extras/wildfly-datasources-galleon-pack/main/doc/oracle/env.yaml

oracle-driver §

Management Model


{
  "subsystem" : {
    "datasources" : {
      "_address" : "/subsystem=datasources",
      "jdbc-driver" : {
        "oracle" : {
          "_address" : "/subsystem=datasources/jdbc-driver=*",
          "attributes" : [ {
            "name" : "driver-module-name",
            "value" : "com.oracle.database.jdbc",
            "_address" : "/subsystem=datasources/jdbc-driver=*@@@driver-module-name"
          }, {
            "name" : "driver-xa-datasource-class-name",
            "value" : "oracle.jdbc.xa.client.OracleXADataSource",
            "_address" : "/subsystem=datasources/jdbc-driver=*@@@driver-xa-datasource-class-name"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.annotation.field.value-className = jakarta.annotation.sql.DataSourceDefinition,className=oracle.jdbc.*
org.wildfly.rule.annotation.field.value-url = jakarta.annotation.sql.DataSourceDefinition,url=jdbc:oracle:*
org.wildfly.rule.xml-path = [/META-INF/*.xml,/WEB-INF/*.xml],/datasources/datasource/driver,oracle
org.wildfly.rule.xml-path-xa = [/META-INF/*.xml,/WEB-INF/*.xml],/datasources/xa-datasource/driver,oracle

Packages

com.oracle.database.jdbc
org.jboss.as.connector

postgresql-datasource §

Management Model


{
  "subsystem" : {
    "datasources" : {
      "_address" : "/subsystem=datasources",
      "data-source" : {
        "PostgreSQLDS" : {
          "_address" : "/subsystem=datasources/data-source=*",
          "attributes" : [ {
            "name" : "background-validation",
            "value" : "${org.wildfly.datasources.postgresql.background-validation,env.POSTGRESQL_BACKGROUND_VALIDATION:false}",
            "_address" : "/subsystem=datasources/data-source=*@@@background-validation"
          }, {
            "name" : "background-validation-millis",
            "value" : "${org.wildfly.datasources.postgresql.background-validation-millis,env.POSTGRESQL_BACKGROUND_VALIDATION_MILLIS:10000}",
            "_address" : "/subsystem=datasources/data-source=*@@@background-validation-millis"
          }, {
            "name" : "connection-url",
            "value" : "${org.wildfly.datasources.postgresql.connection-url,env.POSTGRESQL_URL:jdbc:postgresql://${org.wildfly.datasources.postgresql.host,env.POSTGRESQL_SERVICE_HOST,env.OPENSHIFT_POSTGRESQL_DB_HOST,env.POSTGRESQL_HOST:localhost}:${org.wildfly.datasources.postgresql.port,env.POSTGRESQL_SERVICE_PORT,env.OPENSHIFT_POSTGRESQL_DB_PORT,env.POSTGRESQL_PORT:5432}/${org.wildfly.datasources.postgresql.database,env.POSTGRESQL_DATABASE,env.OPENSHIFT_POSTGRESQL_DB_NAME}}",
            "_address" : "/subsystem=datasources/data-source=*@@@connection-url"
          }, {
            "name" : "driver-name",
            "value" : "postgresql",
            "_address" : "/subsystem=datasources/data-source=*@@@driver-name"
          }, {
            "name" : "enabled",
            "value" : "${org.wildfly.datasources.postgresql.enabled, env.POSTGRESQL_ENABLED:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@enabled"
          }, {
            "name" : "exception-sorter-class-name",
            "value" : "${org.wildfly.datasources.postgresql.exception-sorter-class-name, env.POSTGRESQL_EXCEPTION_SORTER:org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter}",
            "_address" : "/subsystem=datasources/data-source=*@@@exception-sorter-class-name"
          }, {
            "name" : "flush-strategy",
            "value" : "${org.wildfly.datasources.postgresql.flush-strategy,env.POSTGRESQL_FLUSH_STRATEGY:FailingConnectionOnly}",
            "_address" : "/subsystem=datasources/data-source=*@@@flush-strategy"
          }, {
            "name" : "idle-timeout-minutes",
            "value" : "${org.wildfly.datasources.postgresql.idle-timeout-minutes,env.POSTGRESQL_IDLE_TIMEOUT_MINUTES:30}",
            "_address" : "/subsystem=datasources/data-source=*@@@idle-timeout-minutes"
          }, {
            "name" : "jndi-name",
            "value" : "${org.wildfly.datasources.postgresql.jndi-name,env.POSTGRESQL_JNDI:java:jboss/datasources/${org.wildfly.datasources.postgresql.datasource, env.POSTGRESQL_DATASOURCE,env.OPENSHIFT_POSTGRESQL_DATASOURCE:PostgreSQLDS}}",
            "_address" : "/subsystem=datasources/data-source=*@@@jndi-name"
          }, {
            "name" : "jta",
            "value" : "${org.wildfly.datasources.postgresql.jta,env.POSTGRESQL_JTA:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@jta"
          }, {
            "name" : "max-pool-size",
            "value" : "${org.wildfly.datasources.postgresql.max-pool-size,env.POSTGRESQL_MAX_POOL_SIZE:20}",
            "_address" : "/subsystem=datasources/data-source=*@@@max-pool-size"
          }, {
            "name" : "min-pool-size",
            "value" : "${org.wildfly.datasources.postgresql.min-pool-size,env.POSTGRESQL_MIN_POOL_SIZE:0}",
            "_address" : "/subsystem=datasources/data-source=*@@@min-pool-size"
          }, {
            "name" : "password",
            "value" : "${org.wildfly.datasources.postgresql.password,env.POSTGRESQL_PASSWORD,env.OPENSHIFT_POSTGRESQL_DB_PASSWORD}",
            "_address" : "/subsystem=datasources/data-source=*@@@password"
          }, {
            "name" : "stale-connection-checker-class-name",
            "value" : "${org.wildfly.datasources.postgresql.stale-connection-checker-class-name,env.POSTGRESQL_STALE_CONNECTION_CHECKER:org.jboss.jca.adapters.jdbc.extensions.novendor.NullStaleConnectionChecker}",
            "_address" : "/subsystem=datasources/data-source=*@@@stale-connection-checker-class-name"
          }, {
            "name" : "statistics-enabled",
            "value" : "${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}",
            "_address" : "/subsystem=datasources/data-source=*@@@statistics-enabled"
          }, {
            "name" : "transaction-isolation",
            "value" : "${org.wildfly.datasources.postgresql.transaction-isolation,env.POSTGRESQL_TX_ISOLATION:TRANSACTION_READ_COMMITTED}",
            "_address" : "/subsystem=datasources/data-source=*@@@transaction-isolation"
          }, {
            "name" : "user-name",
            "value" : "${org.wildfly.datasources.postgresql.user-name,env.POSTGRESQL_USER,env.OPENSHIFT_POSTGRESQL_DB_USERNAME}",
            "_address" : "/subsystem=datasources/data-source=*@@@user-name"
          }, {
            "name" : "valid-connection-checker-class-name",
            "value" : "${org.wildfly.datasources.postgresql.valid-connection-checker-class-name,env.POSTGRESQL_CONNECTION_CHECKER:org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker}",
            "_address" : "/subsystem=datasources/data-source=*@@@valid-connection-checker-class-name"
          }, {
            "name" : "validate-on-match",
            "value" : "${org.wildfly.datasources.postgresql.validate-on-match,env.POSTGRESQL_VALIDATE_ON_MATCH:true}",
            "_address" : "/subsystem=datasources/data-source=*@@@validate-on-match"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required
postgresql-driver - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.add-on = database,postgresql
org.wildfly.rule.add-on-depends-on = only:datasources
org.wildfly.rule.add-on-description = Documentation in https://github.com/wildfly-extras/wildfly-datasources-galleon-pack
org.wildfly.rule.add-on-fix-unbound-datasources = JNDI env,POSTGRESQL_JNDI=##ITEM##
org.wildfly.rule.configuration = https://raw.githubusercontent.com/wildfly-extras/wildfly-datasources-galleon-pack/main/doc/postgresql/env.yaml

postgresql-default-datasource §

Management Model


{
  "subsystem" : {
    "ee" : {
      "_address" : "/subsystem=ee",
      "service" : {
        "default-bindings" : {
          "_address" : "/subsystem=ee/service=default-bindings",
          "attributes" : [ {
            "name" : "datasource",
            "value" : "${org.wildfly.datasources.postgresql.jndi-name,env.POSTGRESQL_JNDI:java:jboss/datasources/${org.wildfly.datasources.postgresql.datasource, env.POSTGRESQL_DATASOURCE,env.OPENSHIFT_POSTGRESQL_DATASOURCE:PostgreSQLDS}}",
            "_address" : "/subsystem=ee/service=default-bindings@@@datasource"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required
postgresql-datasource - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.add-on = database,postgresql:default
org.wildfly.rule.add-on-depends-on = only:datasources
org.wildfly.rule.add-on-description = Documentation in https://github.com/wildfly-extras/wildfly-datasources-galleon-pack
org.wildfly.rule.add-on-fix-no-default-datasource =
org.wildfly.rule.configuration = https://raw.githubusercontent.com/wildfly-extras/wildfly-datasources-galleon-pack/main/doc/postgresql/env.yaml

postgresql-driver §

Management Model


{
  "subsystem" : {
    "datasources" : {
      "_address" : "/subsystem=datasources",
      "jdbc-driver" : {
        "postgresql" : {
          "_address" : "/subsystem=datasources/jdbc-driver=*",
          "attributes" : [ {
            "name" : "driver-module-name",
            "value" : "org.postgresql.jdbc",
            "_address" : "/subsystem=datasources/jdbc-driver=*@@@driver-module-name"
          }, {
            "name" : "driver-xa-datasource-class-name",
            "value" : "org.postgresql.xa.PGXADataSource",
            "_address" : "/subsystem=datasources/jdbc-driver=*@@@driver-xa-datasource-class-name"
          } ]
        }
      }
    }
  }
}

Dependencies

datasources - required

Layer Properties

org.wildfly.category = Database
org.wildfly.rule.annotation.field.value-className = jakarta.annotation.sql.DataSourceDefinition,className=org.postgresql.*
org.wildfly.rule.annotation.field.value-url = jakarta.annotation.sql.DataSourceDefinition,url=jdbc:postgresql:*
org.wildfly.rule.xml-path = [/META-INF/*.xml,/WEB-INF/*.xml],/datasources/datasource/driver,postgresql
org.wildfly.rule.xml-path-xa = [/META-INF/*.xml,/WEB-INF/*.xml],/datasources/xa-datasource/driver,postgresql

Packages

org.jboss.as.connector
org.postgresql.jdbc

About

This feature pack is hosted at https://github.com/wildfly/wildfly-datasources-galleon-pack

Source code of this feature pack is hosted at https://github.com/wildfly/wildfly-datasources-galleon-pack

This feature pack is licensed under:

Apache License, Version 2.0