1. Overview

In this guide, we will walk through the steps to connect your Spring Boot application with either a MySQL or PostgreSQL database. By the end, you’ll be able to set up and configure these databases and perform basic operations.

2. Adding Dependencies

First, include the necessary dependencies in your pom.xml (for Maven) or build.gradle (for Gradle) file.

For MySQL:

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
</dependency>

For PostgreSQL:

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <scope>runtime</scope>
</dependency>

3. Database Configuration

Spring Boot automatically configures a datasource based on the properties provided in application.properties or application.yml.

MySQL Configuration:

In src/main/resources/application.properties:

spring.jpa.hibernate.ddl-auto=update
spring.datasource.url=jdbc:mysql://localhost:3306/mydatabase
spring.datasource.username=myuser
spring.datasource.password=secret
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.jpa.show-sql: true

PostgreSQL Configuration:

For PostgreSQL, in application.properties:

spring.jpa.hibernate.ddl-auto=update
spring.datasource.url=jdbc:mysql://localhost:5432/mydatabase
spring.datasource.username=myuser
spring.datasource.password=secret
spring.datasource.driver-class-name=org.postgresql.Driver
spring.jpa.show-sql: true

4. Testing the Connection

With your database set up and your configuration complete, you can now run your Spring Boot application. Spring Boot will automatically detect the database configuration and connect to it. You can test your connection by creating a simple repository and performing basic operations like saving and fetching data.

@Entity
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String name;
    private String email;

    // Getters and Setters
}

And a corresponding UserRepository:

public interface UserRepository extends JpaRepository<User, Long> {}

4. Conclusion

Configuring MySQL or PostgreSQL with Spring Boot is straightforward. By setting the right properties, Spring Boot handles much of the configuration automatically, allowing you to focus on building your application.

Posted on 09-25-2024

Links