Mycat-Server
Mycat-Server copied to clipboard
连接sqlserver2012不显示表信息
2019-01-22 22:22:34.394 WARN [BusinessExecutor1] (io.mycat.backend.mysql.nio.handler.SingleNodeHandler.backConnectionErr(SingleNodeHandler.java:267))
- execute sql err : errno:207 列名 'COLUMN_TYPE' 无效。 con:JDBCConnection [id=16,autocommit=true,pool=io.mycat.backend.jdbc.JDBCDatasource@2503b4ae, schema=xxxx, dbType=SQLSERVER, oldSchema=xxxx, packetId=1, txIsolation=0, running=false, borrowed=true, host=null, port=-1, con=net.sourceforge.jtds.jdbc.JtdsConnection@7210d129, respHandler=SingleNodeHandler [node=xxx{SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'xxx' ORDER BY TABLE_SCHEMA, TABLE_NAME}, packetId=1], attachement=xxx{SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'xxxx' ORDER BY TABLE_SCHEMA, TABLE_NAME}, headerOutputed=false, modifiedSQLExecuted=false, startTime=1548213724720, lastTime=1548213754388, isSpark=false, processor=io.mycat.net.NIOProcessor@7245923a]
2019-01-22 22:22:34.435 WARN [BusinessExecutor2] (io.mycat.backend.mysql.nio.handler.SingleNodeHandler.backConnectionErr(SingleNodeHandler.java:267))
- execute sql err : errno:156 关键字 'ORDER' 附近有语法错误。 con:JDBCConnection [id=20,autocommit=true,pool=io.mycat.backend.jdbc.JDBCDatasource@2503b4ae, schema=xxxx, dbType=SQLSERVER, oldSchema=xxxx, packetId=6, txIsolation=0, running=false, borrowed=true, host=null, port=-1, con=net.sourceforge.jtds.jdbc.JtdsConnection@3bbad8c2, respHandler=SingleNodeHandler [node=xxxx{SELECT DISTINCT ROUTINE_SCHEMA, ROUTINE_NAME, PARAMS.PARAMETER FROM information_schema.ROUTINES LEFT JOIN ( SELECT SPECIFIC_SCHEMA, SPECIFIC_NAME, GROUP_CONCAT(CONCAT(DATA_TYPE, ' ', PARAMETER_NAME) ORDER BY ORDINAL_POSITION SEPARATOR ', ') PARAMETER, ROUTINE_TYPE FROM information_schema.PARAMETERS GROUP BY SPECIFIC_SCHEMA, SPECIFIC_NAME, ROUTINE_TYPE ) PARAMS ON ROUTINES.ROUTINE_SCHEMA = PARAMS.SPECIFIC_SCHEMA AND ROUTINES.ROUTINE_NAME = PARAMS.SPECIFIC_NAME AND ROUTINES.ROUTINE_TYPE = PARAMS.ROUTINE_TYPE WHERE ROUTINE_SCHEMA = 'xxxx' ORDER BY ROUTINE_SCHEMA}, packetId=1], attachement=xxxx{SELECT DISTINCT ROUTINE_SCHEMA, ROUTINE_NAME, PARAMS.PARAMETER FROM information_schema.ROUTINES LEFT JOIN ( SELECT SPECIFIC_SCHEMA, SPECIFIC_NAME, GROUP_CONCAT(CONCAT(DATA_TYPE, ' ', PARAMETER_NAME) ORDER BY ORDINAL_POSITION SEPARATOR ', ') PARAMETER, ROUTINE_TYPE FROM information_schema.PARAMETERS GROUP BY SPECIFIC_SCHEMA, SPECIFIC_NAME, ROUTINE_TYPE ) PARAMS ON ROUTINES.ROUTINE_SCHEMA = PARAMS.SPECIFIC_SCHEMA AND ROUTINES.ROUTINE_NAME = PARAMS.SPECIFIC_NAME AND ROUTINES.ROUTINE_TYPE = PARAMS.ROUTINE_TYPE WHERE ROUTINE_SCHEMA = 'xxxx' ORDER BY ROUTINE_SCHEMA}, headerOutputed=false, modifiedSQLExecuted=false, startTime=1548213724725, lastTime=1548213754433, isSpark=false, processor=io.mycat.net.NIOProcessor@7245923a]
兄弟你这个问题解决了吗?
我也有这个问题,请问你怎么解决的
我也是。。。我是sqlServer 2014
同样,我是sqlServer 2008
有没有大哥救命下啊 现在sqlserver2012就是接不上 官方文档和狗屎一样
兄弟你这个问题解决了吗?
大哥你解决了吗
同样,我是sqlServer 2008
大哥你解决了吗
我也是。。。我是sqlServer 2014
大哥你解决了吗
我也有这个问题,请问你怎么解决的
大哥你解决了吗