db-read-write

This is a spring boot application which uses different data sources for read and write calls. No code change is required to implement it in existing application. Only Spring configuration needs to be changed. Based on transaction properties, read or write data source will be used at runtime.

You can set a debug point at this line to verify which datasource is being used - https://github.com/spring-projects/spring-framework/blob/master/spring-jdbc/src/main/java/org/springframework/jdbc/datasource/lookup/AbstractRoutingDataSource.java#L209

Start Database

cd database
docker build -t db .
docker run -p 5432:5432 -d db

Start Application

mvn spring-boot:run

Post Request

POST /employee/ HTTP/1.1
Host: localhost:8080
Accept: application/json
Content-Type: application/json
Cache-Control: no-cache

{
	"id":"1",
	"name": "vikash",
	"dept":"IT",
	"salary": 2000
}

GET Request

GET /employee/1 HTTP/1.1
Host: localhost:8080
Accept: application/json
Cache-Control: no-cache