DB2数据库的安装与Spring Boot配置_springboot db2

win10 下的DB2数据库安装

1. DB2的下载

官网下载：https://www.ibm.com/cn-zh/products/db2 (需要翻墙)
阿里云盘：DB2
链接：https://www.aliyundrive.com/s/GLHE87MaYdZ
提取码: 53zl

参考文章
https://blog.csdn.net/Traditional_/article/details/108773056

Springboot配置连接db2

1. 添加maven依赖

   <dependency>
            <groupId>com.ibm.db2</groupId>
            <artifactId>db2jcc4</artifactId>
            <version>11.1.4.4</version>
  </dependency>
  
  <dependency>
         <groupId>com.ibm.db2</groupId>
         <artifactId>db2jcc_license_cu</artifactId>
         <version>11.1.4.4</version>
  </dependency>
1
2
3
4
5
6
7
8
9
10
11

2. 如果下载不到依赖，从上面的链接下载，maven手动导入

mvn install:install-file "-DgroupId=com.ibm.db2" "-DartifactId=db2jcc_license_cu" "-Dversion=11.1.4.4" "-Dpackaging=jar" "-Dfile=xxxx\db2jcc_license_cu.jar"

mvn install:install-file "-DgroupId=com.ibm.db2" "-DartifactId=db2jcc4" "-Dversion=11.1.4.4" "-Dpackaging=jar" "-Dfile=xxxxx\db2jcc4.jar"
1
2
3

3. yml文件中配置

server:
  port: 8080
spring:
  application:
    name: db2
  datasource:
    driver-class-name: com.ibm.db2.jcc.DB2Driver
    url: jdbc:db2://127.0.0.1:50000/sample;
    username: db2admin
    password: root

1
2
3
4
5
6
7
8
9
10
11

4. 连接数据库时报错：DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=YXUAT.TEST, DRIVER=4.25.13

解决办法1：在写sql语句时，在sql中表名前面加上schemas

例如：SELECT * from SANJIN.TEST

解决办法2：在配置datasource时添加schemas（推荐使用）

例如：
spring:
  datasource:
    driver-class-name: com.ibm.db2.jcc.DB2Driver
    url: jdbc:db2://127.0.0.1:50000/sample:currentSchema=SANJIN;
    username: db2admin
    password: root

1
2
3
4
5
6
7
8
9
10
11
12
13
14