commit 4a4742946340c3f907c39935c12b3494c43d059c
author Ralf Eichinger <ralf.eichinger@bsb-muenchen.de> Mon Aug 09 23:06:33 2021 +0200
committer Ralf Eichinger <ralf.eichinger@bsb-muenchen.de> Mon Aug 09 23:06:33 2021 +0200
tree 974d874f4f6bd82ff9b43cb89b0ee0ca7abb1edb
parent e868df126cc3d4aa28da26c216e37c7dcb6b8650

Add all database configs

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

diff --git a/empire-db-examples/empire-db-example-spring-boot/src/main/resources/application.yml b/empire-db-examples/empire-db-example-spring-boot/src/main/resources/application.yml
index ef268f8..1a244c5 100644
--- a/empire-db-examples/empire-db-example-spring-boot/src/main/resources/application.yml
+++ b/empire-db-examples/empire-db-example-spring-boot/src/main/resources/application.yml
@@ -15,6 +15,10 @@
   config:
     activate:
       on-profile: mysql
+  datasource:
+    url: 'jdbc:mysql://localhost'
+    username: 'root'
+    password: 'esteam'
 
 empiredb:
   driverClass: 'org.apache.empire.db.mysql.DBDatabaseDriverMySQL'
@@ -27,6 +31,15 @@
   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'
 
 ---
 
@@ -34,6 +47,15 @@
   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'
 
 ---
 
@@ -41,6 +63,15 @@
   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'
 
 ---
 
@@ -48,6 +79,13 @@
   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'
 
 ---
 
@@ -55,3 +93,14 @@
   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
\ No newline at end of file