win10 下的DB2数据库安装
- 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
- 添加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>
- 如果下载不到依赖,从上面的链接下载,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"
- 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
- 连接数据库时报错: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