1.springboot添加达梦依赖
<!-- 达梦数据库 -->
<dependency>
<groupId>com.dameng</groupId>
<artifactId>DmJdbcDriver18</artifactId>
<version>8.1.1.193</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.2.0</version>
</dependency>
2.填写配置文件
spring:
application:
name: demo-cdd
datasource:
driver-class-name: dm.jdbc.driver.DmDriver
url: jdbc:dm://192.168.xxx.xxx:5236/SYSDBA?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
username: SYSDBA
password: cdd123456
open-in-view: false
properties:
hibernate:
dialect: org.hibernate.dialect.DmDialect
但是这样配置,数据会在达梦的数据库驱动中强制大写,这对某些接口的数据返回给前端数据大小写出现问题,影响范围较大可以统一将查询操作结果转换成LinkHashMap键值对,再通过BeanMap映射成对应的实体类。具体代码不同情况分开编写,比如clob长文本处理:
Object value = map.get(resultkey);
if(value instanceof ClobProxyImpl){
try {
value = ((ClobProxyImpl) value).getSubString(1,(int)((ClobProxyImpl) value).length());
} catch (Exception e) {
e.printStackTrace();
}
}
文章
阅读量
获赞