注册

MyCat1.6.5可以连接达梦,但是1.6.7.5却连不上了

Joe 2025/12/16 183 0

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: 8.1.3.162 驱动
【操作系统】:windows 11
【CPU】:
【问题描述】:当采用MyCat版本1.6.5时,可以正常访问达梦数据库。
同样的达梦驱动和配置参数,采用1.6.7.5的mycat时,却访问不了,报如下异常:
[BusinessExecutor1] (io.mycat.backend.mysql.nio.handler.SingleNodeHandler.backConnectionErr(SingleNodeHandler.java:284)) - execute sql err : errno:63529 -2007 第 1 行, 第 99 列[.]附近出现错误:
语法分析出错 con:JDBCConnection [id=29,autocommit=true,pool=io.mycat.backend.jdbc.JDBCDatasource@4d0f2471, schema=MAAS_BUS_DB, dbType=ORACLE, oldSchema=MAAS_BUS_DB, packetId=5, txIsolation=0, running=false, borrowed=true, host=192.168.1.90, port=5237, con=dm.jdbc.driver.DmdbConnection@12689533, respHandler=SingleNodeHandler [node=dn1{/
mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c) /SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@collation_connection AS collation_connection, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_write_timeout AS net_write_timeout, @@performance_schema AS performance_schema, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout}, packetId=1], attachement=dn1{/ mysql-connector-j-8.2.0 (Revision: 06a1f724497fd81c6a659131fda822c9e5085b6c) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@collation_connection AS collation_connection, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_write_timeout AS net_write_timeout, @@performance_schema AS performance_schema, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout}, headerOutputed=false, modifiedSQLExecuted=false, startTime=1765873537923, lastTime=1765873581348, isSpark=false, processor=io.mycat.net.NIOProcessor@e21239c] frontend host:127.0.0.1/52361/mycat

请问要如何解决?

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