database parameter

Use the database parameter to configure database connection parameters.

At least one of the database configurations - oracle, db2, postgreql is mandatory. Ensure that the database is accessible from within the cluster.

The following .yaml file is a sample schema of database:

database:
    # db2:
    #   name: ""
    #   host: ""
    #   port:
    #   url: "" 
    #   user: ""
    #   schema: ""      
    #   secure: false
    #   dataSourceName: "jdbc/OMDS"
    # oracle:
    #   name: ""
    #   host: ""
    #   port:
    #   url: "" 
    #   user: ""
    #   schema: ""      
    #   dataSourceName: "jdbc/OMDS"
    # postgresql:
    #   name: ""
    #   host: ""
    #   port:
    #   url: "" 
    #   user: ""
    #   schema: ""      
    #   secure: false
    #   dataSourceName: "jdbc/OMDS"

The following table explains the attributes applicable for the database parameter of OMEnvironment.

Property	Value type	Required	Description
`db2`	object	No	DB2 configuration
`oracle`	object	No	Oracle configuration
`postgresql`	object	No	PostgreSQL configuration

The following table explains the attributes applicable for the <vendor> which can DB2, Oracle, or PostgreSQL.

Property	Default value	Value type	Required	Description
`<vendor>.host`		string	Yes	Specify the IP address or hostname or FQDN of database server.
`<vendor>.name`		string	Yes	Specify the database name.
`<vendor>.port`		integer	Yes	Specify the database port.
`<vendor>.schema`		string	Yes	Specify the database schema name. If you are using multi-schema model, specify your meta data instance in `<vendor>.schema`.
`<vendor>.user`		string	Yes	Specify the database user name. Ensure that the password for the database is provided under `stringData.dbPassword` attribute of the secret. For more information, see Creating a secret.
`<vendor>.dataSourceName`	`jdbc/OMDS`	string	No	Specify the name of the datasource to be used in liberty.
`<vendor>.secure`	`false`	boolean	No	Specify whether database connection is SSL enabled or not. For Oracle, do not configure the `security` property, as it is directly included into the URL.
`<vendor>.url`		string	No	Specify the JDBC URL of the database. You cannot provide `name`, `host`, and `port`, if `url` is provided.