empire-db-examples/empire-db-example-spring-boot/src/main/resources/application.yml

# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements.  See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership.  The ASF licenses this file
# to you under the Apache License, Version 2.0 (the
# "License"); you may not use this file except in compliance
# with the License.  You may obtain a copy of the License at
 *
#  http://www.apache.org/licenses/LICENSE-2.0
 *
# Unless required by applicable law or agreed to in writing,
# software distributed under the License is distributed on an
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
# KIND, either express or implied.  See the License for the
# specific language governing permissions and limitations
# under the License.

spring:
  profiles:
    active: hsqldb
  datasource:
    url: 'jdbc:hsqldb:file:hsqldb/sample;shutdown=true'
    username: 'sa'
    password: ''

empiredb:
  driverClass: 'org.apache.empire.db.hsql.DBDatabaseDriverHSql'

---

spring:
  config:
    activate:
      on-profile: mysql
  datasource:
    url: 'jdbc:mysql://localhost'
    username: 'root'
    password: 'esteam'

empiredb:
  driverClass: 'org.apache.empire.db.mysql.DBDatabaseDriverMySQL'
  driverProperties:
    databaseName: 'DBSAMPLE'

---

spring:
  config:
    activate:
      on-profile: postgresql
  datasource:
    url: 'jdbc:postgresql://localhost'
    username: 'postgres'
    password: 'postgres'

empiredb:
  driverClass: 'org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL'
  driverProperties:
    databaseName: 'DBSAMPLE'

---

spring:
  config:
    activate:
      on-profile: h2
  datasource:
    url: 'jdbc:h2:h2/DBSAMPLE'
    username: 'sa'
    password: ''

empiredb:
  driverClass: 'org.apache.empire.db.h2.DBDatabaseDriverH2'
  driverProperties:
    databaseName: 'DBSAMPLE'

---

spring:
  config:
    activate:
      on-profile: derby
  datasource:
    url: 'jdbc:derby:derby/DBSAMPLE;create=true'
    username: ''
    password: ''

empiredb:
  driverClass: 'org.apache.empire.db.derby.DBDatabaseDriverDerby'
  driverProperties:
    databaseName: 'DBSAMPLE'

---

spring:
  config:
    activate:
      on-profile: oracle
  datasource:
    url: 'jdbc:oracle:thin:@192.168.0.2:1521:ora10'
    username: 'DBSAMPLE'
    password: 'DBSAMPLE'

empiredb:
  driverClass: 'org.apache.empire.db.oracle.DBDatabaseDriverOracle'

---

spring:
  config:
    activate:
      on-profile: sqlserver
  datasource:
    url: 'jdbc:sqlserver://esteamsvr12\sql14'
    username: 'jdbcUser'
    password: 'jdbcPwd'

empiredb:
  driverClass: 'org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL'
  driverProperties:
    databaseName: 'DBSAMPLE'
    useSequenceTable: false
    useDateTime2: true