信创-国产化数据库适配

一. kingbase->dm

1. 数据库迁移：主键和默认值的适配
2. 项目配置：数据库连接

url: jdbc:dm://172.21.17.77:5236?schema=xxxx&compatibleMode=mysql&characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
username: SYSDBA
password: xxxxx
driver-class-name: dm.jdbc.driver.DmDriver

3. 项目启动：activiti适配，nacos适配
4. 项目运行： 4.1 实体类关键字适配(comment,context等)实体类增加注解@TableField(value = "comment") 4.2

   NOW()- INTERVAL '1 month'==》
   

5. 修改表：锁超时

select a.*,b.NAME,c.SESS_ID 
from v$lock a 
left join sysobjects b on b.ID=a.TABLE_ID 
left join v$sessions c on a.TRX_ID=c.TRX_ID
where name like 'DGPW%'

sp_close_session(281446625842960);