Configuring database parameter

Edit online
  • Used to configure database connection parameters.
  • At least one of the database configurations - oracle, db2, postgreql is mandatory.
Note: 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: ""      
    #   secure: false
    #   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 Default value 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 DB2, Oracle, and PostgreSQL (<vendor>) database parameters.

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.
Note: Ensure that the password for the database is provided under stringData.dbPassword attribute of the secret created in Create a Secret page.
<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.
<vendor>.url   string No Specify the JDBC URL of the database.
Note: You cannot provide name, host, and port, if url is provided.