为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: DM8
【操作系统】:win10
【CPU】:
【问题描述】*:
操作系统win10,数据库版本为DM8, 驱动依赖为DM8:
<dependency>
<groupId>com.dameng</groupId>
<artifactId>DmJdbcDriver18</artifactId>
<version>8.1.1.193</version>
</dependency>
本来连接正常,后面为了兼容mysql,修改了配置,红框处修改为4,如图:
重启数据库后,然后就报以下错误:
2023-03-29 19:09:32.914 ERROR --- [] [reate-528846922] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:dm://localhost:5236/DAMENG?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&useSSL=true&characterEncoding=UTF-8, errorCode -118, state 22000
dm.jdbc.driver.DMException: 无效的客户端版本
at dm.jdbc.driver.DBError.throwException(DBError.java:667)
at dm.jdbc.a.b.p.F(MSG.java:536)
at dm.jdbc.a.b.w.r(STARTUP.java:265)
at dm.jdbc.a.b.w.q(STARTUP.java:1)
at dm.jdbc.a.b.p.B(MSG.java:483)
at dm.jdbc.a.a.a(DBAccess.java:837)
at dm.jdbc.a.a.a(DBAccess.java:170)
at dm.jdbc.driver.DmdbConnection.openConnection(DmdbConnection.java:651)
at dm.jdbc.desc.EP.connect(EP.java:185)
at dm.jdbc.desc.EPGroup$EPSelector.select(EPGroup.java:149)
at dm.jdbc.desc.EPGroup.connect(EPGroup.java:97)
at dm.jdbc.driver.DmDriver.do_connect(DmDriver.java:142)
at dm.jdbc.driver.DmDriver.connect(DmDriver.java:436)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156)
at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:787)
at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:227)
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1659)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723)
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2801)
后面配置修改回0,重启数据库后还是报相同的错误,这个问题要怎么解决?
检查下ini文件里有没有这个参数,IFUN_DATETIME_MODE=1,如果有把这个参数改成0试试。