Mycat链接SQLServer2005出现TDS 预登录响应不完整

1、不支持native格式

2016-12-17 21:03:36,984 [WARN ][main] table conf : table [ TRAVELRECORD ] rule function [ murmur ] partition size : 2 < table datanode size : 3 , this cause some datanode to be redundant  (io.mycat.config.loader.xml.XMLSchemaLoader:XMLSchemaLoader.java:571) 

Exception in thread "main" java.lang.ExceptionInInitializerError

at io.mycat.MycatStartup.main(MycatStartup.java:53)

Caused by: io.mycat.config.util.ConfigException: not supported yet !localhost1_gaojingsong2

at io.mycat.config.ConfigInitializer.createDataSource(ConfigInitializer.java:289)

at io.mycat.config.ConfigInitializer.getPhysicalDBPool(ConfigInitializer.java:302)

at io.mycat.config.ConfigInitializer.initDataHosts(ConfigInitializer.java:258)

at io.mycat.config.ConfigInitializer.<init>(ConfigInitializer.java:88)

at io.mycat.config.MycatConfig.<init>(MycatConfig.java:72)

at io.mycat.MycatServer.<init>(MycatServer.java:154)

at io.mycat.MycatServer.<clinit>(MycatServer.java:105)

... 1 more

 

【Mycat操作之分库分表入门】 

解决方案：修改dbDriver="jdbc"

<dataHost name="localhost1_gaojingsong2" maxCon="1000" minCon="10"

balance="0" writeType="0" dbType="sqlserver" dbDriver="jdbc" slaveThreshold="100">

 

 

 

2、缺少数据库驱动

2016-12-17 21:05:14,406 [ERROR][Timer1] JDBCHeartBeat error java.sql.SQLException: No suitable driver found for localhost:1433

at java.sql.DriverManager.getConnection(DriverManager.java:604)

at java.sql.DriverManager.getConnection(DriverManager.java:221)

at io.mycat.backend.jdbc.JDBCDatasource.getConnection(JDBCDatasource.java:108)

at io.mycat.backend.jdbc.JDBCHeartbeat.heartbeat(JDBCHeartbeat.java:100)

at io.mycat.backend.datasource.PhysicalDatasource.doHeartbeat(PhysicalDatasource.java:347)

at io.mycat.backend.datasource.PhysicalDBPool.doHeartbeat(PhysicalDBPool.java:336)

at io.mycat.MycatServer$8$1.run(MycatServer.java:808)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:722)

 (io.mycat.backend.jdbc.JDBCHeartbeat:JDBCHeartbeat.java:114) 

 

3、端口号错误，或者tcpip未开启

com.microsoft.sqlserver.jdbc.SQLServerException: 到主机  的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)

at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:579)

at java.sql.DriverManager.getConnection(DriverManager.java:221)

at demo.test.SqlServer.main(SqlServer.java:13)

 

 

4、测试

Mycat不行

 com.microsoft.sqlserver.jdbc.SQLServerException: TDS 预登录响应不完整。目标服务器必须是 SQL Server 2000 或更高版本。

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)

at com.microsoft.sqlserver.jdbc.DBComms.Prelogin(Unknown Source)

原生的可以