Revize 1261b96f

#10237 Přidání připojení ke druhé databázi - MS SQL s tabulkou Users. Vytvoření konfiguračních souborů pro obě databáze.

src/main/resources/application.properties

@@ +1 @@
+# jpa settings
 spring.jpa.hibernate.ddl-auto=update
+spring.jpa.show-sql=true
+spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.SQLServerDialect
 
-# database connection URL address:
-spring.datasource.url=jdbc:mysql://localhost:3306/spade
-
-# database connection username:
+# mysql database connection:
+spring.datasource.jdbc-url=jdbc:mysql://localhost:3306/spade
 spring.datasource.username=root
-
-# database connection password:
 spring.datasource.password=
+spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
 
-spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
+# mssql database connection:
+spring.second-datasource.jdbc-url=jdbc:sqlserver://localhost:1433;databaseName=authspade;encrypt=true;trustServerCertificate=true
+spring.second-datasource.username=test
+spring.second-datasource.password=
+spring.second-datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
 
-# admin account username:
+# admin account username and password:
 account.user.name=root
+account.user.password=
 
 DATA_PATH=data/
 
-# admin account password:
-account.user.password=
-
 # custom error pages
 server.error.whitelabel.enabled=false