注册

一样的建表sql管理工具中能执行政策,代码中jdbc执行sql报 不支持的语句类型

Relax man 2024/02/28 451 1

CREATE TABLE "WINBILL"."UPAY_INFO_20240227"
(
"ID" BIGINT IDENTITY(1, 1) NOT NULL,
"YYDM" VARCHAR(64),
"YYDDH" VARCHAR(64),
"DDLX" VARCHAR(4),
"DDLY" VARCHAR(4),
"PATID" VARCHAR(32),
"HZXM" VARCHAR(512),
"PTLSH" VARCHAR(128),
"SUBJECT" VARCHAR(256),
"YSJE" DOUBLE,
"TFJE" DOUBLE,
"ZFLSH" VARCHAR(128),
"ZJE" DOUBLE,
"PAYTYPE" INT,
"PAYACTION" VARCHAR(128),
"ORDER_STATUS" INT DEFAULT 0,
"JSSJ" VARCHAR(32),
"ZFSJ" VARCHAR(32),
"TZSJ" VARCHAR(32),
"CXSJ" VARCHAR(32),
"TFSJ" VARCHAR(32),
"NOTIFYURL" VARCHAR(256),
"NOTIFY" VARCHAR(4) DEFAULT 2,
"CZYH" VARCHAR(16),
"MERCHANTID" VARCHAR(64),
"AUTHCODE" VARCHAR(256),
"QRCODE" VARCHAR(256),
"YXSJ" VARCHAR(16),
"CJSJ" TIMESTAMP(3) DEFAULT CURRENT_TIMESTAMP,
"SOURCEID" BIGINT DEFAULT 0,
UNIQUE("ID"),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "BILL", CLUSTERBTR) ;

BILL表空间已经存在
dm.jdbc.driver.DMException: 第34 行附近出现错误:
不支持的语句类型

回答 0
暂无回答
扫一扫
联系客服