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.

pom.xml

@@ -140 +140 @@
 			<scope>test</scope>
 		</dependency>
 
+		<dependency>
+			<groupId>com.microsoft.sqlserver</groupId>
+			<artifactId>mssql-jdbc</artifactId>
+			<version>12.2.0.jre11</version>
+		</dependency>
+
 	</dependencies>
 
 	<build>

src/main/java/cz/zcu/fav/kiv/antipatterndetectionapp/AntiPatternDetectionAppApplication.java

@@ -2 +2 @@
 
 import cz.zcu.fav.kiv.antipatterndetectionapp.spring.AppConfig;
 import org.springframework.boot.SpringApplication;
+import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
 import org.springframework.boot.autoconfigure.SpringBootApplication;
 import org.springframework.context.annotation.Import;
 

src/main/java/cz/zcu/fav/kiv/antipatterndetectionapp/spring/ApplicationProperties.java

@@ -11 +11 @@
     private Environment environment;
 
     public String getDataSourceUrl () {
-        return environment.getProperty("spring.datasource.url");
+        return environment.getProperty("spring.datasource.jdbc-url");
     }
 
     public String getDataSourceUsername() {

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