Springboot+gradle+db2

db2での設定メモ

ソースはこちら

application.properties

# ===============================
# = DATA SOURCE
# ===============================
# Set here configurations for the database connection
spring.datasource.url=jdbc:db2://[hostname]:[port]/[dbname]
spring.datasource.username=[connect user name]
spring.datasource.password=[connect user pw]
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 RAND() AS RANDOM_NUMBER FROM DUAL

build.gradle

dependencies {
        ~
	implementation 'com.ibm.db2.jcc:db2jcc:db2jcc4'
        ~
}