{"action":"created","issue":{"url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/73","labels_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/73/labels{/name}","comments_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/73/comments","events_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/73/events","html_url":"https://github.com/MyCATApache/Mycat-Server/issues/73","id":53171126,"number":73,"title":"《MyCat_In_Action_中文版.doc》中示例，报错can't find (root) parent sharding node for sql:INSERT INTO orders (id, customer_id)","user":{"login":"victorydsk","id":4355240,"avatar_url":"https://avatars.githubusercontent.com/u/4355240?v=3","gravatar_id":"","url":"https://api.github.com/users/victorydsk","html_url":"https://github.com/victorydsk","followers_url":"https://api.github.com/users/victorydsk/followers","following_url":"https://api.github.com/users/victorydsk/following{/other_user}","gists_url":"https://api.github.com/users/victorydsk/gists{/gist_id}","starred_url":"https://api.github.com/users/victorydsk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/victorydsk/subscriptions","organizations_url":"https://api.github.com/users/victorydsk/orgs","repos_url":"https://api.github.com/users/victorydsk/repos","events_url":"https://api.github.com/users/victorydsk/events{/privacy}","received_events_url":"https://api.github.com/users/victorydsk/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2014-12-31T07:12:14Z","updated_at":"2015-01-09T00:50:25Z","closed_at":null,"body":"根据《MyCat_In_Action_中文版.doc》中的步骤在windows下面测试的时候，报标题所示错误，请各位帮忙分析下原因，具体环境如下：\r\n\r\nwindows7，64位\r\nJDK1.7\r\nMySQL5.0.45，Community Edition\r\n\r\n具体错误信息如下：\r\n2/31 14:15:53.700   WARN [$_NIOREACTOR-0-RW] (ServerConnection.java:170) -ServerConnection [id=1, schema=TESTDB, host=127.0.0.1, user=test,txIsolation=3, autocommit=true, schema=TESTDB]insert into orders(id,customer_id) values(2,2) err:java.sql.SQLNonTransientException: can't find (root) parent sharding node for sql:INSERT INTO orders (id, customer_id)\r\nVALUES (2, 2)\r\njava.sql.SQLNonTransientException: can't find (root) parent sharding node for sql:INSERT INTO orders (id, customer_id)\r\nVALUES (2, 2)\r\n\tat org.opencloudb.parser.druid.impl.DruidInsertParser.parserChildTable(DruidInsertParser.java:138)\r\n\tat org.opencloudb.parser.druid.impl.DruidInsertParser.statementParse(DruidInsertParser.java:50)\r\n\tat org.opencloudb.parser.druid.impl.DefaultDruidParser.parser(DefaultDruidParser.java:60)\r\n\tat org.opencloudb.route.impl.DruidMysqlRouteStrategy.routeNormalSqlWithAST(DruidMysqlRouteStrategy.java:35)\r\n\tat org.opencloudb.route.impl.AbstractRouteStrategy.route(AbstractRouteStrategy.java:46)\r\n\tat org.opencloudb.route.RouteService.route(RouteService.java:112)\r\n\tat org.opencloudb.server.ServerConnection.routeEndExecuteSQL(ServerConnection.java:162)\r\n\tat org.opencloudb.server.ServerConnection.execute(ServerConnection.java:154)\r\n\tat org.opencloudb.server.ServerQueryHandler.query(ServerQueryHandler.java:125)\r\n\tat org.opencloudb.net.FrontendConnection.query(FrontendConnection.java:263)\r\n\tat org.opencloudb.net.handler.FrontendCommandHandler.handle(FrontendCommandHandler.java:56)\r\n\tat org.opencloudb.net.FrontendConnection.handle(FrontendConnection.java:370)\r\n\tat org.opencloudb.net.AbstractConnection.onReadData(AbstractConnection.java:264)\r\n\tat org.opencloudb.net.NIOSocketWR.asynRead(NIOSocketWR.java:186)\r\n\tat org.opencloudb.net.AbstractConnection.asynRead(AbstractConnection.java:226)\r\n\tat org.opencloudb.net.NIOReactor$RW.run(NIOReactor.java:97)\r\n\tat java.lang.Thread.run(Thread.java:722)"},"comment":{"url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/comments/69277298","html_url":"https://github.com/MyCATApache/Mycat-Server/issues/73#issuecomment-69277298","issue_url":"https://api.github.com/repos/MyCATApache/Mycat-Server/issues/73","id":69277298,"user":{"login":"victorydsk","id":4355240,"avatar_url":"https://avatars.githubusercontent.com/u/4355240?v=3","gravatar_id":"","url":"https://api.github.com/users/victorydsk","html_url":"https://github.com/victorydsk","followers_url":"https://api.github.com/users/victorydsk/followers","following_url":"https://api.github.com/users/victorydsk/following{/other_user}","gists_url":"https://api.github.com/users/victorydsk/gists{/gist_id}","starred_url":"https://api.github.com/users/victorydsk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/victorydsk/subscriptions","organizations_url":"https://api.github.com/users/victorydsk/orgs","repos_url":"https://api.github.com/users/victorydsk/repos","events_url":"https://api.github.com/users/victorydsk/events{/privacy}","received_events_url":"https://api.github.com/users/victorydsk/received_events","type":"User","site_admin":false},"created_at":"2015-01-09T00:50:25Z","updated_at":"2015-01-09T00:50:25Z","body":"OK，感谢bluoy"}}