Pavan Kumar Jadda pavankjadda

Sql Server with Spring Boot and Spring Data

In order to use SQL server with Spring Boot and Data JPA, we need to do the following

Add SQL server jdbc driver to pom.xml. Change the jre11 value to your JRE version

<dependency>
     <groupId>com.microsoft.sqlserver</groupId>
     <artifactId>mssql-jdbc</artifactId>
     <version>8.2.2.jre11</version>
 </dependency>

Setup Sonarqube with Postgres database using docker

Both Sonarqube and Postgres database should be same network in order communicate with each other. First create docker network using the following commands

Create docker network

Delete existing docker network and create new docker network sonarqube

docker network rm sonarqube_network
docker network create sonarqube_network

Run PostGres DB container

Create network

$ docker network create  vault_network

Use Mysql as backend

$ docker run --name vault-mysql -e MYSQL_ROOT_PASSWORD=Test@12345 -d --network vault_network  mysql:latest

$ mvn liquibase:diff -Pdev -Dliquibase.url="jdbc:mysql://localhost:3306/liquibasedemo-dev?serverTimezone=UTC" -Dliquibase.username="root" -Dliquibase.password="Test@2020" -Dliquibase.referenceUrl="jdbc:mysql://localhost:3306/liquibasedemo-local?serverTimezone=UTC" -Dliquibase.referenceUsername="root" -Dliquibase.referencePassword="Test@2020"

$ mvn liquibase:update -Pdev -Dliquibase.url="dbc:mysql://localhost:3306/liquibasedemo-dev?serverTimezone=UTC" -Dliquibase.username="username" -Dliquibase.password="password"



	### Server information
	server:
	port: 8080

	### Spring Properties
	spring:
	application:
	name: PRES 2.0

	<?xml version="1.0" encoding="UTF-8"?>
	<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-parent</artifactId>
	<version>2.3.1.RELEASE</version>
	<relativePath/> <!-- lookup parent from repository -->
	</parent>


	#### Database properties
	url=${liquibase.url}
	username=${liquibase.username}
	password=${liquibase.password}
	driver=com.mysql.cj.jdbc.Driver

	#### Reference database properties
	referenceUrl=${liquibase.referenceUrl}
	referenceDriver=com.mysql.cj.jdbc.Driver

	<?xml version="1.1" encoding="UTF-8" standalone="no"?>
	<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.5.xsd">
	<includeAll path="db/changelog/dev" />
	</databaseChangeLog>

	singleServerConfig:
	address: "redis://localhost:6379"