Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languageyml
titleConfiguration YAML
blueriq:
  <service>:
    datasource:
      <datasource-name>:
        url: <url>
        username: <username>
        password: <password>
        driver-class-name: <driver-class>
        validation-query: <validation-query>
        testWhileIdle: true
        timeBetweenEvictionRunsMillis: 5000
	 	defaultQueryTimeoutSeconds: 10

hibernate:
  dialect: <dialect>
  hbm2ddl:
    auto: validate
  id:
    new_generator_mappings: true
  show_sql: false
  use_nationalized_character_data: true

...

Code Block
languageyml
titleOracle
blueriq:
  <service>:
    datasource:
      <datasource-name>:
        url: jdbc:oracle:thin:@<host>:<port>/<servicename>
        username: <username>
        password: <password>
        driver-class-name: oracle.jdbc.driver.OracleDriver
        validation-query: SELECT 1 FROM DUAL
        testWhileIdle: true
        timeBetweenEvictionRunsMillis: 5000
	 	defaultQueryTimeoutSeconds: 10

hibernate:
  dialect: org.hibernate.dialect.OracleDialect
  hbm2ddl:
    auto: validate
  id:
    new_generator_mappings: true
  show_sql: false
  use_nationalized_character_data: true

...

Code Block
languageyml
titleSQL Server
blueriq:
  <service>:
    datasource:
      <datasource-name>:
        url: jdbc:sqlserver://<host>:<port>;databaseName=<database>;trustServerCertificate=true
        username: <username>
        password: <password>
        driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
        validation-query: SELECT 1
        testWhileIdle: true
        timeBetweenEvictionRunsMillis: 5000
	 	defaultQueryTimeoutSeconds: 10
 
hibernate:
  dialect: org.hibernate.dialect.SQLServer2012Dialect
  hbm2ddl:
    auto: validate
  id:
    new_generator_mappings: true
  show_sql: false
  use_nationalized_character_data: true

...

Code Block
languageyml
titlePostgreSQL
blueriq:
   <service>:
    datasource:
      <datasource-name>:
        url: jdbc:postgresql://<host>:<port>/<database>
        username: <username>
        password: <password>
        driver-class-name: org.postgresql.Driver
        validation-query: SELECT 1
        testWhileIdle: true
        timeBetweenEvictionRunsMillis: 5000
	 	defaultQueryTimeoutSeconds: 10
 
hibernate:
  dialect: org.hibernate.dialect.PostgreSQLDialect
  hbm2ddl:
    auto: validate
  id:
    new_generator_mappings: true
  show_sql: false
  use_nationalized_character_data: true