注册

mycat连接达梦报错

芮烽 2022/08/24 1538 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: 8
【操作系统】:
【CPU】:
【问题描述】:按照应用开发指南->JAVA 语言->mycat连接池的配置说明配置完成后,mycat中schema连接成功了,但是通过jdbc方式使用时,报错如下:
2022-08-24 10:16:13.573 ERROR [BusinessExecutor6] (io.mycat.backend.jdbc.JDBCConnection.executeSQL(JDBCConnection.java:388)) - sql execute error, 第 1 行, 第 105 列[.]附近出现错误:
语法分析出错
dm.jdbc.driver.DMException: 第 1 行, 第 105 列[.]附近出现错误:
语法分析出错
at dm.jdbc.driver.DBError.throwException(DBError.java:696) ~[DmJdbcDriver16.jar:- 8.1.2.128 - Production]
at dm.jdbc.b.b.o.J(MSG.java:560) ~[DmJdbcDriver16.jar:- 8.1.2.128 - Production]
at dm.jdbc.b.b.o.G(MSG.java:520) ~[DmJdbcDriver16.jar:- 8.1.2.128 - Production]
at dm.jdbc.b.b.o.F(MSG.java:501) ~[DmJdbcDriver16.jar:- 8.1.2.128 - Production]
at dm.jdbc.b.a.a(DBAccess.java:230) ~[DmJdbcDriver16.jar:- 8.1.2.128 - Production]
at dm.jdbc.b.a.a(DBAccess.java:701) ~[DmJdbcDriver16.jar:- 8.1.2.128 - Production]
at dm.jdbc.driver.DmdbStatement.executeInner(DmdbStatement.java:723) ~[DmJdbcDriver16.jar:- 8.1.2.128 - Production]
at dm.jdbc.driver.DmdbStatement.do_executeQuery(DmdbStatement.java:219) ~[DmJdbcDriver16.jar:- 8.1.2.128 - Production]
at dm.jdbc.driver.DmdbStatement.executeQuery(DmdbStatement.java:1014) ~[DmJdbcDriver16.jar:- 8.1.2.128 - Production]
at io.mycat.backend.jdbc.JDBCConnection.ouputResultSet(JDBCConnection.java:712) ~[Mycat-server-1.6.7.6-release.jar:?]
at io.mycat.backend.jdbc.JDBCConnection.executeSQL(JDBCConnection.java:375) [Mycat-server-1.6.7.6-release.jar:?]
at io.mycat.backend.jdbc.JDBCConnection.access$000(JDBCConnection.java:48) [Mycat-server-1.6.7.6-release.jar:?]
at io.mycat.backend.jdbc.JDBCConnection$1.run(JDBCConnection.java:868) [Mycat-server-1.6.7.6-release.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_291]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_291]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_291]
2022-08-24 10:16:13.574 WARN [BusinessExecutor6] (io.mycat.backend.mysql.nio.handler.SingleNodeHandler.backConnectionErr(SingleNodeHandler.java:287)) - execute sql err : errno:63529 第 1 行, 第 105 列[.]附近出现错误:
语法分析出错 con:JDBCConnection [id=7,autocommit=true,pool=io.mycat.backend.jdbc.JDBCDatasource@dce8b75, schema=mydb2, dbType=ORACLE, oldSchema=mydb2, packetId=1, txIsolation=0, running=false, borrowed=true, host=172.21.40.183, port=5538, con=dm.jdbc.driver.DmdbConnection@6215e10, respHandler=SingleNodeHandler [node=dn2{/
mysql-connector-java-5.1.44 ( Revision: b3cda4f864902ffdde495b9df93937c3e20009be ) /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, @@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_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@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 tx_isolation, @@wait_timeout AS wait_timeout}, packetId=1], attachement=dn2{/ mysql-connector-java-5.1.44 ( Revision: b3cda4f864902ffdde495b9df93937c3e20009be ) /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, @@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_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@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 tx_isolation, @@wait_timeout AS wait_timeout}, headerOutputed=false, modifiedSQLExecuted=false, startTime=1661305612603, lastTime=1661307373572, isSpark=false, processor=io.mycat.net.NIOProcessor@452a143b] frontend host:172.20.0.21/50749/root
2022-08-24 10:16:13.574 ERROR [BusinessExecutor6] (io.mycat.net.FrontendConnection.writeErrMessage(FrontendConnection.java:231)) - ServerConnection [
*****]第 1 行, 第 105 列[.]附近出现错误:
语法分析出错java.lang.Thread .getStackTrace1559
io.mycat.net.FrontendConnection .getStack245
io.mycat.net.FrontendConnection .writeErrMessage231
io.mycat.backend.mysql.nio.handler.SingleNodeHandler .backConnectionErr314
io.mycat.backend.mysql.nio.handler.SingleNodeHandler .errorResponse275
io.mycat.backend.jdbc.JDBCConnection .executeSQL389
io.mycat.backend.jdbc.JDBCConnection .access$00048
io.mycat.backend.jdbc.JDBCConnection$1 .run868
java.util.concurrent.ThreadPoolExecutor .runWorker1149
java.util.concurrent.ThreadPoolExecutor$Worker .run624
java.lang.Thread .run748
write errorMsg:{} error

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