连接sqlserver2012不显示表信息

dengyao commented 5 years ago

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]