为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: 8
【镜像加购】:x86_64
【问题描述】*:
2025.05.06 10:07:49.720 [] [] [Druid-ConnectionPool-Create-1548550519] ERROR [com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run:2949] - create connection SQLException, url: jdbc:dm://192.168.56.73:5236?schema=LOWCODE_PREVIEW&characterEncoding=UTF-8&useUnicode=true&useSSL=false&serverTimezone=Asia/Shanghai, errorCode -2007, state 42000 dm.jdbc.driver.DMException: 第 1 行, 第 10 列[utf8mb4]附近出现错误:
语法分析出错
at dm.jdbc.driver.DBError.throwException(DBError.java:711) ~[DmJdbcDriver18-8.1.2.192.jar:- 8.1.2.192 - Production]
at dm.jdbc.a.b.o.x(MSG.java:591) ~[DmJdbcDriver18-8.1.2.192.jar:- 8.1.2.192 - Production]
at dm.jdbc.a.b.o.C(MSG.java:526) ~[DmJdbcDriver18-8.1.2.192.jar:- 8.1.2.192 - Production]
at dm.jdbc.a.b.o.B(MSG.java:507) ~[DmJdbcDriver18-8.1.2.192.jar:- 8.1.2.192 - Production]
at dm.jdbc.a.a.a(DBAccess.java:245) ~[DmJdbcDriver18-8.1.2.192.jar:- 8.1.2.192 - Production]
at dm.jdbc.a.a.a(DBAccess.java:729) ~[DmJdbcDriver18-8.1.2.192.jar:- 8.1.2.192 - Production]
at dm.jdbc.driver.DmdbStatement.executeInner(DmdbStatement.java:730) ~[DmJdbcDriver18-8.1.2.192.jar:- 8.1.2.192 - Production]
at dm.jdbc.driver.DmdbStatement.do_execute(DmdbStatement.java:190) ~[DmJdbcDriver18-8.1.2.192.jar:- 8.1.2.192 - Production]
at dm.jdbc.driver.DmdbStatement.do_execute(DmdbStatement.java:182) ~[DmJdbcDriver18-8.1.2.192.jar:- 8.1.2.192 - Production]
at dm.jdbc.driver.DmdbStatement.execute(DmdbStatement.java:1294) ~[DmJdbcDriver18-8.1.2.192.jar:- 8.1.2.192 - Production]
at com.alibaba.druid.pool.DruidAbstractDataSource.initPhysicalConnection(DruidAbstractDataSource.java:1949) ~[druid-1.2.19.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1808) ~[druid-1.2.19.jar:?]
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2947) ~[druid-1.2.19.jar:?]
连接串只保留这一部分试试jdbc:dm://192.168.56.73:5236?schema=LOWCODE_PREVIEW