How to connect Relational and NoSQL databases with Spring Boot

Let's take a look at how various popular Databases can be configured using Spring Boot.

1. MySQL

spring.datasource.url=jdbc:mysql://localhost:3306/mysqldb
spring.datasource.username=root
spring.datasource.password=msqyl-server-password
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.26</version>
</dependency>

2. PostgreSQL

spring.datasource.url=jdbc:postgresql://localhost:5432/postgredb
spring.datasource.username=user
spring.datasource.password=postgresql-server-password

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>43.0.1</version>
</dependency>

3. Oracle Server

spring.datasource.url=jdbc:oracle:thin:@localhost:1521:oracledb
spring.datasource.username=oracle-db-user
spring.datasource.password=oracle-server-password

<dependency>
    <groupId>com.oracle.ojdbc</groupId>
    <artifactId>ojdbc8</artifactId>
    <version>9.3.0.0</version>
</dependency>

4. Microsoft SQL Server

spring.datasource.url=jdbc:sqlserver://localhost:1433;databaseName=sqldb
spring.datasource.username=sql-db-user
spring.datasource.password=sql-db-password

<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>9.4.0.jre8</version>
</dependency>

We took a look at some Relational Databases configurations, now lets take a look at some NoSQL database configurations with Spring Boot.

1. DynamoDB

spring.data.mongodb.uri=mongodb://localhost:27017/dynamodb

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-mongodb</artifactId>
    <version>2.6.3</version>
</dependency>

2. Cassandra

spring.data.cassandra.contact-points=localhost
spring.data.cassandra.port=9042
spring.data.cassandra.keyspace-name=cassandradb

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-cassandra</artifactId>
    <version>2.6.3</version>
</dependency>

3. Redis

spring.redis.host=localhost
spring.redis.port=6379

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-redis</artifactId>
    <version>2.6.3</version>
</dependency>

4. Apache HBase

spring.data.hbase.quorum=localhost
spring.data.hbase.zk-port=2181

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-hadoop</artifactId>
    <version>2.6.3</version>
</dependency>

5. Couchbase

spring.couchbase.bootstrap-hosts=localhost
spring.couchbase.bucket.name=bucket-name
spring.couchbase.bucket.password=server-password

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-couchbase</artifactId>
    <version>2.6.3</version>
</dependency>