Revize 36a51dd4

fuck me

pom.xml

@@ -236 +236 @@
 		</dependency>
 
 		<!-- MS SQL Server DataBase -->
+
+		<dependency>
+			<groupId>com.microsoft.sqlserver</groupId>
+			<artifactId>mssql-jdbc</artifactId>
+			<version>12.2.0.jre11</version>
+		</dependency>
         <dependency>
             <groupId>com.google.code.gson</groupId>
             <artifactId>gson</artifactId>

src/main/resources/application-docker.properties

@@ -1 +1 @@
 ## oauth2 -> keycloak
-spring.second-datasource.jdbc-url=jdbc:mysql://mysql-db:3306/authspade
+spring.second-datasource.jdbc-url=jdbc:sqlserver://mssql:1433;databaseName=authspade;encrypt=true;trustServerCertificate=true
 spring.datasource.jdbc-url=jdbc:mysql://mysql-db:3306/spade
-spring.security.oauth2.resourceserver.jwt.issuer-uri=http://keycloak:9080/auth/realms/spade
+spring.security.oauth2.resourceserver.jwt.jwk-set-uri=http://keycloak:9080/auth/realms/spade/protocol/openid-connect/certs
 DATA_PATH=/usr/local/etc/data/

src/main/resources/application-local.properties

@@ -1 +1 @@
 ## oauth2 -> keycloak
-spring.second-datasource.jdbc-url=jdbc:mysql://localhost:3306/authspade
+spring.second-datasource.jdbc-url=jdbc:sqlserver://localhost:1433;databaseName=authspade;encrypt=true;trustServerCertificate=true
 spring.datasource.jdbc-url=jdbc:mysql://localhost:3306/spade
 spring.security.oauth2.resourceserver.jwt.issuer-uri=http://localhost:9080/auth/realms/spade
 DATA_PATH=data/

src/main/resources/application.properties

@@ -10 +10 @@
 spring.datasource.password=testtest
 spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
 
-# second mysql database connection:
-spring.second-datasource.username=root
-spring.second-datasource.password=testtest
-spring.second-datasource.driverClassName=com.mysql.cj.jdbc.Driver
-
+# mssql database connection:
+spring.second-datasource.username=test
+spring.second-datasource.password=test
+spring.second-datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
 
+spring.security.oauth2.resourceserver.jwt.issuer-uri=http://localhost:9080/auth/realms/spade
 
 # custom error pages
 server.error.whitelabel.enabled=false