[empire-db] 03/07: Add all database configs

[doebele]

This is an automated email from the ASF dual-hosted git repository.

doebele pushed a commit to branch spring-boot
in repository https://gitbox.apache.org/repos/asf/empire-db.git

commit 4a4742946340c3f907c39935c12b3494c43d059c
Author: Ralf Eichinger <ralf.eichin...@bsb-muenchen.de>
AuthorDate: Mon Aug 9 23:06:33 2021 +0200

    Add all database configs
---
 .../src/main/resources/application.yml             | 49 ++++++++++++++++++++++
 1 file changed, 49 insertions(+)

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 @@ spring:
   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 @@ 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'
 
 ---
 
@@ -34,6 +47,15 @@ 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'
 
 ---
 
@@ -41,6 +63,15 @@ 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'
 
 ---
 
@@ -48,6 +79,13 @@ 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'
 
 ---
 
@@ -55,3 +93,14 @@ 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
\ No newline at end of file