使用mycat配置SQLserver无法操作表报1184 - Invalid Datasource:0

悬赏园豆：100 [已解决问题] 解决于 2022-09-27 17:06

对表进行任何操作都不行双击打开也不行

schema.xml配置文件

<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">

<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100"> 
    <table name="sys_user" dataNode="dn1"   splitTableNames ="true"/> 
</schema> 
<dataNode name="dn1" dataHost="localhost1" database="pdb_getOffice" />  
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="0"
          writeType="0" dbType="sqlserver" dbDriver="jdbc" switchType="1"  slaveThreshold="100">
    <heartbeat>select user()</heartbeat> 
    <writeHost host="hostM1" url="jdbc:sqlserver://localhost:1433" user="sa"
               password="get">
    </writeHost> 
</dataHost>

</mycat:schema>

而改成连接MySQL 又不会有这样的问题