为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: dm8_20230808_rev197096_x86_rh6_64_single.tar
【操作系统】:Docker X86_64
【CPU】:
【问题描述】*:
你好,在geoserver 2.14.0 版本上发布图层服务后,预览时出现如下的错误。请问怎么解决呀?使用的包gt-dmgeo2-2.14.jar,DmJdbcDriver18.jar
创建空间表的方法
CREATE TABLE "DUTY_GRID"
(
"duty_grid_id" INT AUTO_INCREMENT NOT NULL,
"duty_grid_code" VARCHAR(40),
"duty_grid_desc" VARCHAR(100),
"duty_grid_name" VARCHAR(100),
"duty_grid_type_id" INT,
"region_code" VARCHAR(200),
"duty_grid_geometry" "SYSGEO2"."ST_GEOMETRY",
"duty_grid_source" INT DEFAULT 0,
NOT CLUSTER PRIMARY KEY("duty_grid_id")) STORAGE(ON "MAIN", CLUSTERBTR);
INSERT INTO duty_grid VALUES (443, '450130001001001', NULL, '网格001', 1, '450130001001', DMGEO2.ST_GeomFromText('POLYGON((107.249188609421 24.1442177630961, 107.24892038852 24.143295083195, 107.250755019486 24.1429195739329, 107.251388020813 24.1432199813426, 107.251581139863 24.1433916427195, 107.251441664994 24.1435847617686, 107.249188609421 24.1442177630961))',0), 0);
请参考https://eco.dameng.com/document/dm/zh-cn/start/GeoServer-development.html#,此问题出现原因可能是没有执行SP_INIT_GEO2_SYS(1);启用geo2
如果你没少复制。。应该是 少 create table name