适配Nacos2.4.1 达梦数据库DM8版本

2024-08-22 04:12
文章标签 数据库 版本 适配 达梦 dm8 nacos2.4

本文主要是介绍适配Nacos2.4.1 达梦数据库DM8版本，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

目前已经适配2.4.1版本

若需要直接使用可以下载是适配后源码进行编译
https://gogs.zyjblogs.cn/zhuyijun/nacos
若需要看适配过程可参阅下面适配操作

安装达梦驱动到本地仓库

mvn install:install-file -Dfile=DmJdbcDriver-1.8.jar -DgroupId=dm.jdbc -DartifactId=DmJdbcDriver  -Dversion=1.8 -Dpackaging=jar

引用DM驱动

  1. nacos-all的pom.xml文件添加
<properties><dm-jdbc.version>1.8</dm-jdbc.version>  
</properties><dependencies>
<dependency>  <groupId>dm.jdbc</groupId>  <artifactId>DmJdbcDriver</artifactId>  <version>${dm-jdbc.version}</version>  
</dependency>
</dependencies>
  1. nacos-common、nacos-naming、nacos-config工程的pom.xml文件添加
<dependencies>
<dependency>  <groupId>dm.jdbc</groupId>  <artifactId>DmJdbcDriver</artifactId>  <version>${dm-jdbc.version}</version>  
</dependency>
</dependencies>

修改代码

DataSourceConstant 数据源常量修改

class: com.alibaba.nacos.plugin.datasource.constants.DataSourceConstant
添加 public static final String DM = “dm”;

public class DataSourceConstant {  public static final String MYSQL = "mysql";  public static final String DERBY = "derby";  public static final String DM = "dm";  
}

修改Mapper

目录: com.alibaba.nacos.plugin.datasource.impl
1、复制com.alibaba.nacos.plugin.datasource.impl.mysql -> com.alibaba.nacos.plugin.datasource.impl.dm
2、修改mapper中的getDataSource方法，改为DataSourceConstant.DM

image.png

修改resoure

datasource（nacos-datasource-plugin）工程 resources目录下的META-INF/services/com.alibaba.nacos.plugin.datasource.mapper.Mapper

com.alibaba.nacos.plugin.datasource.impl.dm.ConfigInfoAggrMapperByDm  
com.alibaba.nacos.plugin.datasource.impl.dm.ConfigInfoBetaMapperByDm  
com.alibaba.nacos.plugin.datasource.impl.dm.ConfigInfoMapperByDm  
com.alibaba.nacos.plugin.datasource.impl.dm.ConfigInfoTagMapperByDm  
com.alibaba.nacos.plugin.datasource.impl.dm.ConfigTagsRelationMapperByDm  
com.alibaba.nacos.plugin.datasource.impl.dm.HistoryConfigInfoMapperByDm  
com.alibaba.nacos.plugin.datasource.impl.dm.TenantInfoMapperByDm  
com.alibaba.nacos.plugin.datasource.impl.dm.TenantCapacityMapperByDm  
com.alibaba.nacos.plugin.datasource.impl.dm.GroupCapacityMapperByDm

image.png

添加DM程序适配器

PersistenceConstant添加

class: com.alibaba.nacos.persistence.constants.PersistenceConstant

public static final String DM = "dm";

image.png

添加DM分页适配器

目录: com.alibaba.nacos.plugin.auth.impl.persistence.handler.support
该目录下添加DM适配器类

public class DmPageHandlerAdapter implements PageHandlerAdapter {  @Override  public boolean supports(String dataSourceType) {  return PersistenceConstant.DM.equals(dataSourceType);  }  @Override  public OffsetFetchResult addOffsetAndFetchNext(String fetchSql, Object[] arg, int pageNo, int pageSize) {  if (!fetchSql.contains(AuthPageConstant.LIMIT)) {  fetchSql += " " + AuthPageConstant.LIMIT_SIZE;  List<Object> newArgsList = new ArrayList<>(Arrays.asList(arg));  newArgsList.add((pageNo - 1) * pageSize);  newArgsList.add(pageSize);  Object[] newArgs = newArgsList.toArray(new Object[0]);  return new OffsetFetchResult(fetchSql, newArgs);  }  return new OffsetFetchResult(fetchSql, arg);  }  }
分页适配工厂添加DM分页适配器

class: com.alibaba.nacos.plugin.auth.impl.persistence.handler.PageHandlerAdapterFactory
添加分页适配器:

private PageHandlerAdapterFactory() {  List<PageHandlerAdapter> handlerAdapters = new ArrayList<>(3);  Map<String, PageHandlerAdapter> handlerAdapterMap = new HashMap<>(3);  Consumer<PageHandlerAdapter> addHandlerAdapter = handlerAdapter -> {  handlerAdapters.add(handlerAdapter);  handlerAdapterMap.put(handlerAdapter.getClass().getName(), handlerAdapter);  };  // DmPageHandlerAdapter  addHandlerAdapter.accept(new DmPageHandlerAdapter());  // MysqlPageHandlerAdapter  addHandlerAdapter.accept(new MysqlPageHandlerAdapter());  // DerbyPageHandlerAdapter  addHandlerAdapter.accept(new DerbyPageHandlerAdapter());  // DefaultPageHandlerAdapter  addHandlerAdapter.accept(new DefaultPageHandlerAdapter());  this.handlerAdapters = Collections.unmodifiableList(handlerAdapters);  this.handlerAdapterMap = Collections.unmodifiableMap(handlerAdapterMap);  
}

修改数据源配置类ExternalDataSourceProperties

class: com.alibaba.nacos.persistence.datasource.ExternalDataSourceProperties
添加属性: private List<String> jdbcDriverName

private List<String> jdbcDriverName = new ArrayList<>();  public List<String> getJdbcDriverName() {  return jdbcDriverName;  
}  public void setJdbcDriverName(List<String> jdbcDriverName) {  this.jdbcDriverName = jdbcDriverName;  
}

image.png

修改 build方法中的数据源驱动部分
class: com.alibaba.nacos.persistence.datasource.ExternalDataSourceProperties#build

poolProperties.setDriverClassName(getOrDefault(jdbcDriverName,index,jdbcDriverName.get(index)).trim());

image.png

配置文件修改

  1. spring.sql.init.platform的值改为dm
  2. 添加db.jdbc-driver-name.0=dm.jdbc.driver.DmDriver
#驱动添加db.pool.config.driverClassName或者db.jdbc-driver-name二选一，（若有多数据源且数据库类型不同时可使用db.jdbc-driver-name），推荐使用db.jdbc-driver-name
# db.pool.config.driverClassName=dm.jdbc.driver.DmDriver
# db.jdbc-driver-name.0=dm.jdbc.driver.DmDriver# db.url.0=jdbc:dm://IP:5236/NACOS
# db.user.0=nacos
# db.password.0=nacos
  1. 修改url为db.url.0=jdbc:dm://IP:5236/DB
  2. nacos.core.auth.enabled修改为true
  3. 修改identity.key和identity.value为
nacos.core.auth.server.identity.key=${NACOS_AUTH_IDENTITY_KEY:nacos_key}
nacos.core.auth.server.identity.value=${NACOS_AUTH_IDENTITY_KEY:nacos_value}
  1. nacos.core.auth.plugin.nacos.token.secret.key改为
nacos.core.auth.plugin.nacos.token.secret.key=${NACOS_AUTH_TOKEN:TmFjb3NEbXp5ajk5ODEhQCMhUUFaWFNXMWRxaXVkdDhxaWN0ODczMmRhZGhhaXVkZzg2M2tqdg==}
  1. 添加: server.tomcat.accesslog.max-days=30

添加dm-scheme.sql

CREATE TABLE "USERS"  
(  "USERNAME" VARCHAR(50) NOT NULL,  "PASSWORD" VARCHAR(500) NOT NULL,  "ENABLED" TINYINT NOT NULL  
);  CREATE TABLE "TENANT_INFO"  
(  "ID" BIGINT IDENTITY(1,1) NOT NULL,  "KP" VARCHAR(128) NOT NULL,  "TENANT_ID" VARCHAR(128) DEFAULT ''  NULL,  "TENANT_NAME" VARCHAR(128) DEFAULT ''  NULL,  "TENANT_DESC" VARCHAR(256) NULL,  "CREATE_SOURCE" VARCHAR(32) NULL,  "GMT_CREATE" BIGINT NOT NULL,  "GMT_MODIFIED" BIGINT NOT NULL  
);  CREATE TABLE "TENANT_CAPACITY"  
(  "ID" BIGINT IDENTITY(1,1) NOT NULL,  "TENANT_ID" VARCHAR(128) DEFAULT ''  NOT NULL,  "QUOTA" BIGINT DEFAULT 0  NOT NULL,  "USAGE" BIGINT DEFAULT 0  NOT NULL,  "MAX_SIZE" BIGINT DEFAULT 0  NOT NULL,  "MAX_AGGR_COUNT" BIGINT DEFAULT 0  NOT NULL,  "MAX_AGGR_SIZE" BIGINT DEFAULT 0  NOT NULL,  "MAX_HISTORY_COUNT" BIGINT DEFAULT 0  NOT NULL,  "GMT_CREATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()  NOT NULL,  "GMT_MODIFIED" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()  NOT NULL  
);  CREATE TABLE "ROLES"  
(  "USERNAME" VARCHAR(50) NOT NULL,  "ROLE" VARCHAR(50) NOT NULL  
);  CREATE TABLE "PERMISSIONS"  
(  "ROLE" VARCHAR(50) NOT NULL,  "RESOURCE" VARCHAR(255) NOT NULL,  "ACTION" VARCHAR(8) NOT NULL  
);  CREATE TABLE "HIS_CONFIG_INFO"  
(  "ID" DECIMAL(20,0) NOT NULL,  "NID" BIGINT IDENTITY(1,1) NOT NULL,  "DATA_ID" VARCHAR(255) NOT NULL,  "GROUP_ID" VARCHAR(128) NOT NULL,  "APP_NAME" VARCHAR(128) NULL,  "CONTENT" CLOB NOT NULL,  "MD5" VARCHAR(32) NULL,  "GMT_CREATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()  NOT NULL,  "GMT_MODIFIED" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()  NOT NULL,  "SRC_USER" TEXT NULL,  "SRC_IP" VARCHAR(50) NULL,  "OP_TYPE" CHAR(10) NULL,  "TENANT_ID" VARCHAR(128) DEFAULT ''  NULL,  "ENCRYPTED_DATA_KEY" TEXT NOT NULL  
);  CREATE TABLE "GROUP_CAPACITY"  
(  "ID" BIGINT IDENTITY(1,1) NOT NULL,  "GROUP_ID" VARCHAR(128) DEFAULT ''  NOT NULL,  "QUOTA" BIGINT DEFAULT 0  NOT NULL,  "USAGE" BIGINT DEFAULT 0  NOT NULL,  "MAX_SIZE" BIGINT DEFAULT 0  NOT NULL,  "MAX_AGGR_COUNT" BIGINT DEFAULT 0  NOT NULL,  "MAX_AGGR_SIZE" BIGINT DEFAULT 0  NOT NULL,  "MAX_HISTORY_COUNT" BIGINT DEFAULT 0  NOT NULL,  "GMT_CREATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()  NOT NULL,  "GMT_MODIFIED" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()  NOT NULL  
);  CREATE TABLE "CONFIG_TAGS_RELATION"  
(  "ID" BIGINT NOT NULL,  "TAG_NAME" VARCHAR(128) NOT NULL,  "TAG_TYPE" VARCHAR(64) NULL,  "DATA_ID" VARCHAR(255) NOT NULL,  "GROUP_ID" VARCHAR(128) NOT NULL,  "TENANT_ID" VARCHAR(128) DEFAULT ''  NULL,  "NID" BIGINT IDENTITY(1,1) NOT NULL  
);  CREATE TABLE "CONFIG_INFO_TAG"  
(  "ID" BIGINT IDENTITY(1,1) NOT NULL,  "DATA_ID" VARCHAR(255) NOT NULL,  "GROUP_ID" VARCHAR(128) NOT NULL,  "TENANT_ID" VARCHAR(128) DEFAULT ''  NULL,  "TAG_ID" VARCHAR(128) NOT NULL,  "APP_NAME" VARCHAR(128) NULL,  "CONTENT" CLOB NOT NULL,  "MD5" VARCHAR(32) NULL,  "GMT_CREATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()  NOT NULL,  "GMT_MODIFIED" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()  NOT NULL,  "SRC_USER" TEXT NULL,  "SRC_IP" VARCHAR(50) NULL  
);  CREATE TABLE "CONFIG_INFO_BETA"  
(  "ID" BIGINT IDENTITY(1,1) NOT NULL,  "DATA_ID" VARCHAR(255) NOT NULL,  "GROUP_ID" VARCHAR(128) NOT NULL,  "APP_NAME" VARCHAR(128) NULL,  "CONTENT" CLOB NOT NULL,  "BETA_IPS" VARCHAR(1024) NULL,  "MD5" VARCHAR(32) NULL,  "GMT_CREATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()  NOT NULL,  "GMT_MODIFIED" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()  NOT NULL,  "SRC_USER" TEXT NULL,  "SRC_IP" VARCHAR(50) NULL,  "TENANT_ID" VARCHAR(128) DEFAULT ''  NULL,  "ENCRYPTED_DATA_KEY" TEXT NOT NULL  
);  CREATE TABLE "CONFIG_INFO_AGGR"  
(  "ID" BIGINT IDENTITY(1,1) NOT NULL,  "DATA_ID" VARCHAR(255) NOT NULL,  "GROUP_ID" VARCHAR(128) NOT NULL,  "DATUM_ID" VARCHAR(255) NOT NULL,  "CONTENT" CLOB NOT NULL,  "GMT_MODIFIED" TIMESTAMP(0) NOT NULL,  "APP_NAME" VARCHAR(128) NULL,  "TENANT_ID" VARCHAR(128) DEFAULT ''  NULL  
);  CREATE TABLE "CONFIG_INFO"  
(  "ID" BIGINT IDENTITY(1,1) NOT NULL,  "DATA_ID" VARCHAR(255) NOT NULL,  "GROUP_ID" VARCHAR(128) NULL,  "CONTENT" CLOB NOT NULL,  "MD5" VARCHAR(32) NULL,  "GMT_CREATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()  NOT NULL,  "GMT_MODIFIED" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP()  NOT NULL,  "SRC_USER" TEXT NULL,  "SRC_IP" VARCHAR(50) NULL,  "APP_NAME" VARCHAR(128) NULL,  "TENANT_ID" VARCHAR(128) DEFAULT ''  NULL,  "C_DESC" VARCHAR(256) NULL,  "C_USE" VARCHAR(64) NULL,  "EFFECT" VARCHAR(64) NULL,  "TYPE" VARCHAR(64) NULL,  "C_SCHEMA" TEXT NULL,  "ENCRYPTED_DATA_KEY" TEXT NOT NULL  
);  SET IDENTITY_INSERT "CONFIG_INFO" ON;  
SET IDENTITY_INSERT "CONFIG_INFO" OFF;  
SET IDENTITY_INSERT "CONFIG_INFO_AGGR" ON;  
SET IDENTITY_INSERT "CONFIG_INFO_AGGR" OFF;  
SET IDENTITY_INSERT "CONFIG_INFO_BETA" ON;  
SET IDENTITY_INSERT "CONFIG_INFO_BETA" OFF;  
SET IDENTITY_INSERT "CONFIG_INFO_TAG" ON;  
SET IDENTITY_INSERT "CONFIG_INFO_TAG" OFF;  
SET IDENTITY_INSERT "CONFIG_TAGS_RELATION" ON;  
SET IDENTITY_INSERT "CONFIG_TAGS_RELATION" OFF;  
SET IDENTITY_INSERT "GROUP_CAPACITY" ON;  
SET IDENTITY_INSERT "GROUP_CAPACITY" OFF;  
SET IDENTITY_INSERT "HIS_CONFIG_INFO" ON;  
SET IDENTITY_INSERT "HIS_CONFIG_INFO" OFF;  
INSERT INTO "ROLES"("USERNAME","ROLE") VALUES('nacos','ROLE_ADMIN');  SET IDENTITY_INSERT "TENANT_CAPACITY" ON;  
SET IDENTITY_INSERT "TENANT_CAPACITY" OFF;  
SET IDENTITY_INSERT "TENANT_INFO" ON;  
SET IDENTITY_INSERT "TENANT_INFO" OFF;  
INSERT INTO "USERS"("USERNAME","PASSWORD","ENABLED") VALUES('nacos','$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu',1);  ALTER TABLE "USERS" ADD CONSTRAINT  PRIMARY KEY("USERNAME") ;  ALTER TABLE "TENANT_INFO" ADD CONSTRAINT  PRIMARY KEY("ID") ;  ALTER TABLE "TENANT_INFO" ADD CONSTRAINT "UK_TENANT_INFO_KPTENANTID" UNIQUE("KP","TENANT_ID") ;  ALTER TABLE "TENANT_CAPACITY" ADD CONSTRAINT  PRIMARY KEY("ID") ;  ALTER TABLE "TENANT_CAPACITY" ADD CONSTRAINT "UK_TENANT_ID" UNIQUE("TENANT_ID") ;  ALTER TABLE "ROLES" ADD CONSTRAINT "IDX_USER_ROLE" UNIQUE("USERNAME","ROLE") ;  ALTER TABLE "PERMISSIONS" ADD CONSTRAINT "UK_ROLE_PERMISSION" UNIQUE("ROLE","RESOURCE","ACTION") ;  ALTER TABLE "HIS_CONFIG_INFO" ADD CONSTRAINT  PRIMARY KEY("NID") ;  ALTER TABLE "GROUP_CAPACITY" ADD CONSTRAINT  PRIMARY KEY("ID") ;  ALTER TABLE "GROUP_CAPACITY" ADD CONSTRAINT "UK_GROUP_ID" UNIQUE("GROUP_ID") ;  ALTER TABLE "CONFIG_TAGS_RELATION" ADD CONSTRAINT  PRIMARY KEY("NID") ;  ALTER TABLE "CONFIG_TAGS_RELATION" ADD CONSTRAINT "UK_CONFIGTAGRELATION_CONFIGIDTAG" UNIQUE("ID","TAG_NAME","TAG_TYPE") ;  ALTER TABLE "CONFIG_INFO_TAG" ADD CONSTRAINT  PRIMARY KEY("ID") ;  ALTER TABLE "CONFIG_INFO_TAG" ADD CONSTRAINT "UK_CONFIGINFOTAG_DATAGROUPTENANTTAG" UNIQUE("DATA_ID","GROUP_ID","TENANT_ID","TAG_ID") ;  ALTER TABLE "CONFIG_INFO_BETA" ADD CONSTRAINT  PRIMARY KEY("ID") ;  ALTER TABLE "CONFIG_INFO_BETA" ADD CONSTRAINT "UK_CONFIGINFOBETA_DATAGROUPTENANT" UNIQUE("DATA_ID","GROUP_ID","TENANT_ID") ;  ALTER TABLE "CONFIG_INFO_AGGR" ADD CONSTRAINT  PRIMARY KEY("ID") ;  ALTER TABLE "CONFIG_INFO_AGGR" ADD CONSTRAINT "UK_CONFIGINFOAGGR_DATAGROUPTENANTDATUM" UNIQUE("DATA_ID","GROUP_ID","TENANT_ID","DATUM_ID") ;  ALTER TABLE "CONFIG_INFO" ADD CONSTRAINT  PRIMARY KEY("ID") ;  ALTER TABLE "CONFIG_INFO" ADD CONSTRAINT "UK_CONFIGINFO_DATAGROUPTENANT" UNIQUE("DATA_ID","GROUP_ID","TENANT_ID") ;  CREATE UNIQUE INDEX "PRIMARY"  
ON "USERS"("USERNAME");  COMMENT ON COLUMN "USERS"."USERNAME" IS 'username';  COMMENT ON COLUMN "USERS"."PASSWORD" IS 'password';  COMMENT ON COLUMN "USERS"."ENABLED" IS 'enabled';  CREATE INDEX "IDX_TENANT_ID"  
ON "TENANT_INFO"("TENANT_ID");  CREATE UNIQUE INDEX "INDEX134402165964299"  
ON "TENANT_INFO"("ID");  COMMENT ON TABLE "TENANT_INFO" IS 'tenant_info';  COMMENT ON COLUMN "TENANT_INFO"."ID" IS 'id';  COMMENT ON COLUMN "TENANT_INFO"."KP" IS 'kp';  COMMENT ON COLUMN "TENANT_INFO"."TENANT_ID" IS 'tenant_id';  COMMENT ON COLUMN "TENANT_INFO"."TENANT_NAME" IS 'tenant_name';  COMMENT ON COLUMN "TENANT_INFO"."TENANT_DESC" IS 'tenant_desc';  COMMENT ON COLUMN "TENANT_INFO"."CREATE_SOURCE" IS 'create_source';  COMMENT ON COLUMN "TENANT_INFO"."GMT_CREATE" IS '创建时间';  COMMENT ON COLUMN "TENANT_INFO"."GMT_MODIFIED" IS '修改时间';  ALTER TABLE "TENANT_CAPACITY" ADD CHECK ("QUOTA" >= 0) ENABLE ;  ALTER TABLE "TENANT_CAPACITY" ADD CHECK ("MAX_HISTORY_COUNT" >= 0) ENABLE ;  ALTER TABLE "TENANT_CAPACITY" ADD CHECK ("MAX_AGGR_SIZE" >= 0) ENABLE ;  ALTER TABLE "TENANT_CAPACITY" ADD CHECK ("MAX_AGGR_COUNT" >= 0) ENABLE ;  ALTER TABLE "TENANT_CAPACITY" ADD CHECK ("MAX_SIZE" >= 0) ENABLE ;  ALTER TABLE "TENANT_CAPACITY" ADD CHECK ("USAGE" >= 0) ENABLE ;  CREATE UNIQUE INDEX "INDEX134403016796300"  
ON "TENANT_CAPACITY"("ID");  COMMENT ON TABLE "TENANT_CAPACITY" IS '租户容量信息表';  COMMENT ON COLUMN "TENANT_CAPACITY"."ID" IS '主键ID';  COMMENT ON COLUMN "TENANT_CAPACITY"."TENANT_ID" IS 'Tenant ID';  COMMENT ON COLUMN "TENANT_CAPACITY"."QUOTA" IS '配额，0表示使用默认值';  COMMENT ON COLUMN "TENANT_CAPACITY"."USAGE" IS '使用量';  COMMENT ON COLUMN "TENANT_CAPACITY"."MAX_SIZE" IS '单个配置大小上限，单位为字节，0表示使用默认值';  COMMENT ON COLUMN "TENANT_CAPACITY"."MAX_AGGR_COUNT" IS '聚合子配置最大个数';  COMMENT ON COLUMN "TENANT_CAPACITY"."MAX_AGGR_SIZE" IS '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值';  COMMENT ON COLUMN "TENANT_CAPACITY"."MAX_HISTORY_COUNT" IS '最大变更历史数量';  COMMENT ON COLUMN "TENANT_CAPACITY"."GMT_CREATE" IS '创建时间';  COMMENT ON COLUMN "TENANT_CAPACITY"."GMT_MODIFIED" IS '修改时间';  COMMENT ON COLUMN "ROLES"."USERNAME" IS 'username';  COMMENT ON COLUMN "ROLES"."ROLE" IS 'role';  COMMENT ON COLUMN "PERMISSIONS"."ROLE" IS 'role';  COMMENT ON COLUMN "PERMISSIONS"."RESOURCE" IS 'resource';  COMMENT ON COLUMN "PERMISSIONS"."ACTION" IS 'action';  ALTER TABLE "HIS_CONFIG_INFO" ADD CHECK ("ID" >= 0) ENABLE ;  CREATE INDEX "IDX_DID"  
ON "HIS_CONFIG_INFO"("DATA_ID");  CREATE INDEX "IDX_GMT_MODIFIED"  
ON "HIS_CONFIG_INFO"("GMT_MODIFIED");  CREATE INDEX "IDX_GMT_CREATE"  
ON "HIS_CONFIG_INFO"("GMT_CREATE");  CREATE UNIQUE INDEX "INDEX134404266256800"  
ON "HIS_CONFIG_INFO"("NID");  COMMENT ON TABLE "HIS_CONFIG_INFO" IS '多租户改造';  COMMENT ON COLUMN "HIS_CONFIG_INFO"."ID" IS 'id';  COMMENT ON COLUMN "HIS_CONFIG_INFO"."NID" IS 'nid, 自增标识';  COMMENT ON COLUMN "HIS_CONFIG_INFO"."DATA_ID" IS 'data_id';  COMMENT ON COLUMN "HIS_CONFIG_INFO"."GROUP_ID" IS 'group_id';  COMMENT ON COLUMN "HIS_CONFIG_INFO"."APP_NAME" IS 'app_name';  COMMENT ON COLUMN "HIS_CONFIG_INFO"."CONTENT" IS 'content';  COMMENT ON COLUMN "HIS_CONFIG_INFO"."MD5" IS 'md5';  COMMENT ON COLUMN "HIS_CONFIG_INFO"."GMT_CREATE" IS '创建时间';  COMMENT ON COLUMN "HIS_CONFIG_INFO"."GMT_MODIFIED" IS '修改时间';  COMMENT ON COLUMN "HIS_CONFIG_INFO"."SRC_USER" IS 'source user';  COMMENT ON COLUMN "HIS_CONFIG_INFO"."SRC_IP" IS 'source ip';  COMMENT ON COLUMN "HIS_CONFIG_INFO"."OP_TYPE" IS 'operation type';  COMMENT ON COLUMN "HIS_CONFIG_INFO"."TENANT_ID" IS '租户字段';  COMMENT ON COLUMN "HIS_CONFIG_INFO"."ENCRYPTED_DATA_KEY" IS '密钥';  ALTER TABLE "GROUP_CAPACITY" ADD CHECK ("QUOTA" >= 0) ENABLE ;  ALTER TABLE "GROUP_CAPACITY" ADD CHECK ("MAX_HISTORY_COUNT" >= 0) ENABLE ;  ALTER TABLE "GROUP_CAPACITY" ADD CHECK ("MAX_AGGR_SIZE" >= 0) ENABLE ;  ALTER TABLE "GROUP_CAPACITY" ADD CHECK ("MAX_AGGR_COUNT" >= 0) ENABLE ;  ALTER TABLE "GROUP_CAPACITY" ADD CHECK ("MAX_SIZE" >= 0) ENABLE ;  ALTER TABLE "GROUP_CAPACITY" ADD CHECK ("USAGE" >= 0) ENABLE ;  CREATE UNIQUE INDEX "INDEX134405629453900"  
ON "GROUP_CAPACITY"("ID");  COMMENT ON TABLE "GROUP_CAPACITY" IS '集群、各Group容量信息表';  COMMENT ON COLUMN "GROUP_CAPACITY"."ID" IS '主键ID';  COMMENT ON COLUMN "GROUP_CAPACITY"."GROUP_ID" IS 'Group ID，空字符表示整个集群';  COMMENT ON COLUMN "GROUP_CAPACITY"."QUOTA" IS '配额，0表示使用默认值';  COMMENT ON COLUMN "GROUP_CAPACITY"."USAGE" IS '使用量';  COMMENT ON COLUMN "GROUP_CAPACITY"."MAX_SIZE" IS '单个配置大小上限，单位为字节，0表示使用默认值';  COMMENT ON COLUMN "GROUP_CAPACITY"."MAX_AGGR_COUNT" IS '聚合子配置最大个数，，0表示使用默认值';  COMMENT ON COLUMN "GROUP_CAPACITY"."MAX_AGGR_SIZE" IS '单个聚合数据的子配置大小上限，单位为字节，0表示使用默认值';  COMMENT ON COLUMN "GROUP_CAPACITY"."MAX_HISTORY_COUNT" IS '最大变更历史数量';  COMMENT ON COLUMN "GROUP_CAPACITY"."GMT_CREATE" IS '创建时间';  COMMENT ON COLUMN "GROUP_CAPACITY"."GMT_MODIFIED" IS '修改时间';  CREATE INDEX "INDEX134406418558100"  
ON "CONFIG_TAGS_RELATION"("TENANT_ID");  CREATE UNIQUE INDEX "INDEX134406537578900"  
ON "CONFIG_TAGS_RELATION"("NID");  COMMENT ON TABLE "CONFIG_TAGS_RELATION" IS 'config_tag_relation';  COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."ID" IS 'id';  COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."TAG_NAME" IS 'tag_name';  COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."TAG_TYPE" IS 'tag_type';  COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."DATA_ID" IS 'data_id';  COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."GROUP_ID" IS 'group_id';  COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."TENANT_ID" IS 'tenant_id';  COMMENT ON COLUMN "CONFIG_TAGS_RELATION"."NID" IS 'nid, 自增长标识';  CREATE UNIQUE INDEX "INDEX134407033963000"  
ON "CONFIG_INFO_TAG"("ID");  COMMENT ON TABLE "CONFIG_INFO_TAG" IS 'config_info_tag';  COMMENT ON COLUMN "CONFIG_INFO_TAG"."ID" IS 'id';  COMMENT ON COLUMN "CONFIG_INFO_TAG"."DATA_ID" IS 'data_id';  COMMENT ON COLUMN "CONFIG_INFO_TAG"."GROUP_ID" IS 'group_id';  COMMENT ON COLUMN "CONFIG_INFO_TAG"."TENANT_ID" IS 'tenant_id';  COMMENT ON COLUMN "CONFIG_INFO_TAG"."TAG_ID" IS 'tag_id';  COMMENT ON COLUMN "CONFIG_INFO_TAG"."APP_NAME" IS 'app_name';  COMMENT ON COLUMN "CONFIG_INFO_TAG"."CONTENT" IS 'content';  COMMENT ON COLUMN "CONFIG_INFO_TAG"."MD5" IS 'md5';  COMMENT ON COLUMN "CONFIG_INFO_TAG"."GMT_CREATE" IS '创建时间';  COMMENT ON COLUMN "CONFIG_INFO_TAG"."GMT_MODIFIED" IS '修改时间';  COMMENT ON COLUMN "CONFIG_INFO_TAG"."SRC_USER" IS 'source user';  COMMENT ON COLUMN "CONFIG_INFO_TAG"."SRC_IP" IS 'source ip';  CREATE UNIQUE INDEX "INDEX134407798104699"  
ON "CONFIG_INFO_BETA"("ID");  COMMENT ON TABLE "CONFIG_INFO_BETA" IS 'config_info_beta';  COMMENT ON COLUMN "CONFIG_INFO_BETA"."ID" IS 'id';  COMMENT ON COLUMN "CONFIG_INFO_BETA"."DATA_ID" IS 'data_id';  COMMENT ON COLUMN "CONFIG_INFO_BETA"."GROUP_ID" IS 'group_id';  COMMENT ON COLUMN "CONFIG_INFO_BETA"."APP_NAME" IS 'app_name';  COMMENT ON COLUMN "CONFIG_INFO_BETA"."CONTENT" IS 'content';  COMMENT ON COLUMN "CONFIG_INFO_BETA"."BETA_IPS" IS 'betaIps';  COMMENT ON COLUMN "CONFIG_INFO_BETA"."MD5" IS 'md5';  COMMENT ON COLUMN "CONFIG_INFO_BETA"."GMT_CREATE" IS '创建时间';  COMMENT ON COLUMN "CONFIG_INFO_BETA"."GMT_MODIFIED" IS '修改时间';  COMMENT ON COLUMN "CONFIG_INFO_BETA"."SRC_USER" IS 'source user';  COMMENT ON COLUMN "CONFIG_INFO_BETA"."SRC_IP" IS 'source ip';  COMMENT ON COLUMN "CONFIG_INFO_BETA"."TENANT_ID" IS '租户字段';  COMMENT ON COLUMN "CONFIG_INFO_BETA"."ENCRYPTED_DATA_KEY" IS '密钥';  CREATE UNIQUE INDEX "INDEX134408619300900"  
ON "CONFIG_INFO_AGGR"("ID");  COMMENT ON TABLE "CONFIG_INFO_AGGR" IS '增加租户字段';  COMMENT ON COLUMN "CONFIG_INFO_AGGR"."ID" IS 'id';  COMMENT ON COLUMN "CONFIG_INFO_AGGR"."DATA_ID" IS 'data_id';  COMMENT ON COLUMN "CONFIG_INFO_AGGR"."GROUP_ID" IS 'group_id';  COMMENT ON COLUMN "CONFIG_INFO_AGGR"."DATUM_ID" IS 'datum_id';  COMMENT ON COLUMN "CONFIG_INFO_AGGR"."CONTENT" IS '内容';  COMMENT ON COLUMN "CONFIG_INFO_AGGR"."GMT_MODIFIED" IS '修改时间';  COMMENT ON COLUMN "CONFIG_INFO_AGGR"."APP_NAME" IS 'app_name';  COMMENT ON COLUMN "CONFIG_INFO_AGGR"."TENANT_ID" IS '租户字段';  CREATE UNIQUE INDEX "INDEX134409166029299"  
ON "CONFIG_INFO"("ID");  COMMENT ON TABLE "CONFIG_INFO" IS 'config_info';  COMMENT ON COLUMN "CONFIG_INFO"."ID" IS 'id';  COMMENT ON COLUMN "CONFIG_INFO"."DATA_ID" IS 'data_id';  COMMENT ON COLUMN "CONFIG_INFO"."GROUP_ID" IS 'group_id';  COMMENT ON COLUMN "CONFIG_INFO"."CONTENT" IS 'content';  COMMENT ON COLUMN "CONFIG_INFO"."MD5" IS 'md5';  COMMENT ON COLUMN "CONFIG_INFO"."GMT_CREATE" IS '创建时间';  COMMENT ON COLUMN "CONFIG_INFO"."GMT_MODIFIED" IS '修改时间';  COMMENT ON COLUMN "CONFIG_INFO"."SRC_USER" IS 'source user';  COMMENT ON COLUMN "CONFIG_INFO"."SRC_IP" IS 'source ip';  COMMENT ON COLUMN "CONFIG_INFO"."APP_NAME" IS 'app_name';  COMMENT ON COLUMN "CONFIG_INFO"."TENANT_ID" IS '租户字段';  COMMENT ON COLUMN "CONFIG_INFO"."C_DESC" IS 'configuration description';  COMMENT ON COLUMN "CONFIG_INFO"."C_USE" IS 'configuration usage';  COMMENT ON COLUMN "CONFIG_INFO"."EFFECT" IS '配置生效的描述';  COMMENT ON COLUMN "CONFIG_INFO"."TYPE" IS '配置的类型';  COMMENT ON COLUMN "CONFIG_INFO"."C_SCHEMA" IS '配置的模式';  COMMENT ON COLUMN "CONFIG_INFO"."ENCRYPTED_DATA_KEY" IS '密钥';

编译打包

mvn -Prelease-nacos clean install -Dmaven.test.skip=true -Dcheckstyle.skip=true -Dpmd.skip=true -Drat.skip=true -U

打包完成生成包的位置

image.png

这篇关于适配Nacos2.4.1 达梦数据库DM8版本的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！


http://www.chinasem.cn/article/1095207。

相关文章

Python一次性将指定版本所有包上传PyPI镜像解决方案

Python一次性将指定版本所有包上传PyPI镜像解决方案

《Python一次性将指定版本所有包上传PyPI镜像解决方案》本文主要介绍了一个安全、完整、可离线部署的解决方案,用于一次性准备指定Python版本的所有包,然后导出到内网环境,感兴趣的小伙伴可以跟随... 目录为什么需要这个方案完整解决方案1. 项目目录结构2. 创建智能下载脚本3. 创建包清单生成脚本4
阅读更多...
Linux下MySQL数据库定时备份脚本与Crontab配置教学

Linux下MySQL数据库定时备份脚本与Crontab配置教学

《Linux下MySQL数据库定时备份脚本与Crontab配置教学》在生产环境中,数据库是核心资产之一,定期备份数据库可以有效防止意外数据丢失,本文将分享一份MySQL定时备份脚本,并讲解如何通过cr... 目录备份脚本详解脚本功能说明授权与可执行权限使用 Crontab 定时执行编辑 Crontab添加定
阅读更多...
如何通过try-catch判断数据库唯一键字段是否重复

如何通过try-catch判断数据库唯一键字段是否重复

《如何通过try-catch判断数据库唯一键字段是否重复》在MyBatis+MySQL中,通过try-catch捕获唯一约束异常可避免重复数据查询,优点是减少数据库交互、提升并发安全,缺点是异常处理开... 目录1、原理2、怎么理解“异常走的是数据库错误路径，开销比普通逻辑分支稍高”？1. 普通逻辑分支 v
阅读更多...
Python与MySQL实现数据库实时同步的详细步骤

Python与MySQL实现数据库实时同步的详细步骤

《Python与MySQL实现数据库实时同步的详细步骤》在日常开发中,数据同步是一项常见的需求,本篇文章将使用Python和MySQL来实现数据库实时同步,我们将围绕数据变更捕获、数据处理和数据写入这... 目录前言摘要概述：数据同步方案1. 基本思路2. mysql Binlog 简介实现步骤与代码示例1
阅读更多...
Ubuntu如何升级Python版本

Ubuntu如何升级Python版本

《Ubuntu如何升级Python版本》Ubuntu22.04Docker中,安装Python3.11后,使用update-alternatives设置为默认版本,最后用python3-V验证... 目China编程录问题描述前提环境解决方法总结问题描述Ubuntu22.04系统自带python3.10，想升级
阅读更多...
使用shardingsphere实现mysql数据库分片方式

使用shardingsphere实现mysql数据库分片方式

《使用shardingsphere实现mysql数据库分片方式》本文介绍如何使用ShardingSphere-JDBC在SpringBoot中实现MySQL水平分库,涵盖分片策略、路由算法及零侵入配置... 目录一、ShardingSphere 简介1.1 对比1.2 核心概念1.3 Sharding-Sp
阅读更多...
Go语言连接MySQL数据库执行基本的增删改查

Go语言连接MySQL数据库执行基本的增删改查

《Go语言连接MySQL数据库执行基本的增删改查》在后端开发中,MySQL是最常用的关系型数据库之一,本文主要为大家详细介绍了如何使用Go连接MySQL数据库并执行基本的增删改查吧... 目录Go语言连接mysql数据库准备工作安装 MySQL 驱动代码实现运行结果注意事项Go语言执行基本的增删改查准备工作
阅读更多...
MySQL 数据库表操作完全指南:创建、读取、更新与删除实战

MySQL 数据库表操作完全指南:创建、读取、更新与删除实战

《MySQL数据库表操作完全指南:创建、读取、更新与删除实战》本文系统讲解MySQL表的增删查改（CURD）操作,涵盖创建、更新、查询、删除及插入查询结果,也是贯穿各类项目开发全流程的基础数据交互原... 目录mysql系列前言一、Create(创建)并插入数据1.1 单行数据 + 全列插入1.2 多行数据
阅读更多...
MySQL 数据库表与查询操作实战案例

MySQL 数据库表与查询操作实战案例

《MySQL数据库表与查询操作实战案例》本文将通过实际案例,详细介绍MySQL中数据库表的设计、数据插入以及常用的查询操作,帮助初学者快速上手,感兴趣的朋友跟随小编一起看看吧... 目录mysql 数据库表操作与查询实战案例项目一：产品相关数据库设计与创建一、数据库及表结构设计二、数据库与表的创建项目二：员
阅读更多...
MybatisPlus中removeById删除数据库未变解决方案

MybatisPlus中removeById删除数据库未变解决方案

《MybatisPlus中removeById删除数据库未变解决方案》MyBatisPlus中,removeById需实体类标注@TableId注解以识别数据库主键,若字段名不一致,应通过value属... 目录MyBATisPlus中removeBypythonId删除数据库未变removeById(Se
阅读更多...

Copyright China编程 23002807@qq.com

沪ICP备2023033072号-2