注册

通过java来执行创建表sql,一直提示语法分析错误

. 2022/08/03 1025 4

创建表sql:
CREATE TABLE SDS_DATA_MODEL_DEMO(
BGQ VARCHAR(53),
DCDXXTM VARCHAR(50),
ZZJGDM VARCHAR(50),
XMMC VARCHAR(50),
XMDM VARCHAR(50),
DJCCLX VARCHAR(50),
XMJCSZSF VARCHAR(50),
XMJCSZDQ VARCHAR(50),
BNTCSJ DATE,
NAME DATE);
COMMENT ON TABLE SDS_DATA_MODEL_DEMO IS ‘测试’;
COMMENT ON COLUMN SDS_DATA_MODEL_DEMO.BGQ IS ‘报告期’;
COMMENT ON COLUMN SDS_DATA_MODEL_DEMO.DCDXXTM IS ‘调查对象系统码’;
COMMENT ON COLUMN SDS_DATA_MODEL_DEMO.ZZJGDM IS ‘组织机构代码’;
COMMENT ON COLUMN SDS_DATA_MODEL_DEMO.XMMC IS ‘项目名称’;
COMMENT ON COLUMN SDS_DATA_MODEL_DEMO.XMDM IS ‘项目代码’;
COMMENT ON COLUMN SDS_DATA_MODEL_DEMO.DJCCLX IS ‘登记注册类型’;
COMMENT ON COLUMN SDS_DATA_MODEL_DEMO.XMJCSZSF IS ‘项目所在省份’;
COMMENT ON COLUMN SDS_DATA_MODEL_DEMO.XMJCSZDQ IS ‘项目所在地区’;
COMMENT ON COLUMN SDS_DATA_MODEL_DEMO.BNTCSJ IS ‘本能全部投产时间’;
COMMENT ON COLUMN SDS_DATA_MODEL_DEMO.NAME IS ‘本能全部投产时间’;
错误信息:
dm.jdbc.driver.DMException: 第 12 行, 第 8 列[COMMENT]附近出现错误:
语法分析出错
at dm.jdbc.driver.DBError.throwException(DBError.java:660)
at dm.jdbc.a.b.p.D(MSG.java:584)
at dm.jdbc.a.b.p.A(MSG.java:544)
at dm.jdbc.a.b.p.z(MSG.java:525)
at dm.jdbc.a.a.a(DBAccess.java:810)
at dm.jdbc.a.a.a(DBAccess.java:223)
通过DM管理工具执行sql可以执行成功,通过java执行就报上面的错误

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