In this tutorial, we will show how to connect the Spring boot application to the DB2 database.
DB2 is a database product from IBM. It is a Relational Database Management System (RDBMS). DB2 is designed to store, analyze and retrieve the data efficiently. DB2 product is extended with the support of Object-Oriented features and non-relational structures with XML.Steps to Connect Spring Boot Application to DB2 Database
Step 1: Create Database
create database EXAMPLE
Step2: Add DB2 Driver Dependency
<dependency>
<groupId>com.ibm.db2.jcc</groupId>
<artifactId>db2jcc4</artifactId>
<version>10.1</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
Step 3: Configure DB2 database in Spring Boot Application
Next, we need to configure DB2 database details in our Spring boot application. Open the application.properties file and add the following configuration to it:
# ===============================
# = DATA SOURCE
# ===============================
# Set here configurations for the database connection
spring.datasource.url=jdbc:db2://localhost:50000/EXAMPLE
spring.datasource.username=db2inst1
spring.datasource.password=db2inst1-pwd
spring.datasource.driver-class-name=com.ibm.db2.jcc.DB2Driver
# Keep the connection alive if idle for a long time (needed in production)
spring.datasource.testWhileIdle=true
spring.datasource.validationQuery=SELECT 1
# ===============================
# = JPA / HIBERNATE
# ===============================
# Show or not log for each sql query
spring.jpa.show-sql=true
# Hibernate ddl auto (create, create-drop, update): with "create-drop" the database
# schema will be automatically created afresh for every start of application
spring.jpa.hibernate.ddl-auto=create-drop
# Naming strategy
spring.jpa.hibernate.naming.implicit-strategy=org.hibernate.boot.model.naming.ImplicitNamingStrategyLegacyHbmImpl
spring.jpa.hibernate.naming.physical-strategy=org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy
# Allows Hibernate to generate SQL optimized for a particular DBMS
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.DB2Dialect
Make sure that you have changed the database username and password as per your DB2 installation on your machine.
We have added DB2 JDBC driver class:
spring.datasource.driver-class-name=com.ibm.db2.jcc.DB2Driver
This property will create and drop a database every start and stop of the Spring boot application:
spring.jpa.hibernate.ddl-auto=create-drop
We have added Hibernate dialect for the DB2 database:
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.DB2Dialect
Complete Source code on GitHub
You can find the complete Spring boot project that uses the DB2 database on GitHub at https://github.com/sourcecodeexamples/spring-boot-db2-example
Comments
Post a Comment