达梦数据库(DM8)实战教程：从入门到问题排查

DECLARE
  num NUMBER;
BEGIN
  SELECT COUNT(1) INTO num from user_tab_columns where table_name = upper('GIS_ASSETS_CONFIG');
  IF num = 0 THEN
    EXECUTE IMMEDIATE 'CREATE TABLE GIS_ASSETS_CONFIG
    (
      ID          NUMBER(20,0) NOT NULL PRIMARY KEY,
      TENANT_ID   VARCHAR2(12),
      DEPT_ID     NUMBER(20,0),
      DEPT_CODE   VARCHAR2(100),
      DEPT_NAME   VARCHAR2(45),
      MATERIAL    VARCHAR2(100),
      DIAMETER    VARCHAR2(100),
      PRICE       NUMBER(12,7),
      CREATE_USER NUMBER(20,0),
      UPDATE_USER NUMBER(20,0),
      CREATE_TIME DATE,
      UPDATE_TIME DATE,
      IS_DELETED  NUMBER DEFAULT 0
    )';
    EXECUTE IMMEDIATE 'COMMENT ON TABLE GIS_ASSETS_CONFIG IS ''资产报表配置''';
    EXECUTE IMMEDIATE 'COMMENT ON COLUMN GIS_ASSETS_CONFIG.ID IS ''主键''';
    EXECUTE IMMEDIATE 'COMMENT ON COLUMN GIS_ASSETS_CONFIG.TENANT_ID IS ''租户ID''';
    EXECUTE IMMEDIATE 'COMMENT ON COLUMN GIS_ASSETS_CONFIG.DEPT_ID IS ''机构ID''';
    EXECUTE IMMEDIATE 'COMMENT ON COLUMN GIS_ASSETS_CONFIG.DEPT_CODE IS ''机构编码''';
    EXECUTE IMMEDIATE 'COMMENT ON COLUMN GIS_ASSETS_CONFIG.DEPT_NAME IS ''机构名称''';
    EXECUTE IMMEDIATE 'COMMENT ON COLUMN GIS_ASSETS_CONFIG.MATERIAL IS ''材质''';
    EXECUTE IMMEDIATE 'COMMENT ON COLUMN GIS_ASSETS_CONFIG.DIAMETER IS ''管径''';
    EXECUTE IMMEDIATE 'COMMENT ON COLUMN GIS_ASSETS_CONFIG.PRICE IS ''价格''';
    EXECUTE IMMEDIATE 'COMMENT ON COLUMN GIS_ASSETS_CONFIG.CREATE_USER IS ''创建用户''';
    EXECUTE IMMEDIATE 'COMMENT ON COLUMN GIS_ASSETS_CONFIG.UPDATE_USER IS ''更新用户''';
    EXECUTE IMMEDIATE 'COMMENT ON COLUMN GIS_ASSETS_CONFIG.CREATE_TIME IS ''创建时间''';
    EXECUTE IMMEDIATE 'COMMENT ON COLUMN GIS_ASSETS_CONFIG.UPDATE_TIME IS ''更新时间''';
    EXECUTE IMMEDIATE 'COMMENT ON COLUMN GIS_ASSETS_CONFIG.IS_DELETED IS ''是否删除''';
  END IF;
END;

DECLARE
  num NUMBER;
BEGIN
  SELECT COUNT(1) INTO num from user_tab_columns where table_name = upper('GIS_LAYER_DATA') and column_name = upper('DISPLAY_FIELD');
  IF num = 0 THEN
    execute immediate 'ALTER TABLE IES_POMP_MASTER.GIS_LAYER_DATA ADD (DISPLAY_FIELD VARCHAR2(255))'; 
    execute immediate 'COMMENT ON COLUMN IES_POMP_MASTER.GIS_LAYER_DATA.DISPLAY_FIELD IS ''展示字段''';
  execute immediate 'UPDATE IES_POMP_MASTER.GIS_LAYER_DATA SET DISPLAY_FIELD = '''''; 
  END IF;
END;

8.1.1.193：正常
8.1.2.79：index out of range
8.1.2.141：正常
8.1.2.192：网络通信异常，Cannot assign requested address: connect
8.1.3.62：无效的模式名[ies_pomp_master_v2]

<!-- https://mvnrepository.com/artifact/com.dameng/DmJdbcDriver18 -->
<dependency>
    <groupId>com.dameng</groupId>
    <artifactId>DmJdbcDriver18</artifactId>
    <version>8.1.2.141</version>
</dependency>

<!-- https://central.sonatype.com/artifact/com.dameng/DmDialect-for-hibernate5.4 -->
<dependency>
    <groupId>com.dameng</groupId>
    <artifactId>DmDialect-for-hibernate5.4</artifactId>
    <version>8.1.3.62</version>
</dependency>

spring:
  jpa:
    database-platform: org.hibernate.dialect.DmDialect

./dminit PATH=/dm/data/  PAGE_SIZE=32 EXTENT_SIZE=32 CASE_SENSITIVE=N CHARSET=0 LENGTH_IN_CHAR=Y DB_NAME=DAMENG LOG_SIZE=2048 INSTANCE_NAME=DMSERVER PORT_NUM=5236