java.sql.SQLNonTransientException: find no Route:SELECT * FROM `wechat`.`activities` LIMIT 0 java.sql.SQLNonTransientException: find no Route:SELECT * FROM `wechat`.`activities` LIMIT 0

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by Kagamine
, 1 year ago
find no Route:SELECT * FROM `wechat`.`activities` LIMIT 0 java.sql.SQLNonTransientException: find no Route:SELECT * FROM `wechat`.`activities` LIMIT 0
via GitHub by githublaohu
, 1 year ago
find no Route:SELECT * FROM `vp_user_800000001`.`vp_user_info` LIMIT 0
via GitHub by nimei1248
, 8 months ago
(ServerConnection.java:281)) - ServerConnection [id=13, schema=ucenter, host=10.5.9.22, user=test,txIsolation=3, autocommit=true, schema=ucenter]SELECT * FROM `user_a01`.`t2` LIMIT 0 err:java.sql.SQLNonTransientException: find no Route:SELECT * FROM `user_a01`.`t2` LIMIT 0 **java.sql.SQLNonTransientException: find no Route:SELECT * FROM `user_a01`.`t2` LIMIT 0**
java.sql.SQLNonTransientException: find no Route:SELECT * FROM `wechat`.`activities` LIMIT 0 java.sql.SQLNonTransientException: find no Route:SELECT * FROM `wechat`.`activities` LIMIT 0
at io.mycat.route.parser.druid.impl.DruidSelectParser.tryRoute(DruidSelectParser.java:437)
at io.mycat.route.parser.druid.impl.DruidSelectParser.changeSql(DruidSelectParser.java:287)
at io.mycat.route.parser.druid.impl.DefaultDruidParser.parser(DefaultDruidParser.java:67)
at io.mycat.route.impl.DruidMycatRouteStrategy.routeNormalSqlWithAST(DruidMycatRouteStrategy.java:77)
at io.mycat.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:81)
at io.mycat.route.RouteService.route(RouteService.java:133)
at io.mycat.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:260)
at io.mycat.server.ServerConnection.execute(ServerConnection.java:209)
at io.mycat.server.handler.SelectHandler.handle(SelectHandler.java:105)
at io.mycat.server.ServerQueryHandler.query(ServerQueryHandler.java:79)
at io.mycat.net.FrontendConnection.query(FrontendConnection.java:317)
at io.mycat.net.FrontendConnection.query(FrontendConnection.java:337)
at io.mycat.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:71)
at io.mycat.net.FrontendConnection.rawHandle(FrontendConnection.java:462)
at io.mycat.net.FrontendConnection.handle(FrontendConnection.java:444)
at io.mycat.net.AbstractConnection.onReadData(AbstractConnection.java:321)
at io.mycat.net.NIOSocketWR.asynRead(NIOSocketWR.java:190)
at io.mycat.net.AbstractConnection.asynRead(AbstractConnection.java:273)
at io.mycat.net.NIOReactor$RW.run(NIOReactor.java:102)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.