Home > database >  Postgresql integration issues mycat, bosses, please help!!!!!!
Postgresql integration issues mycat, bosses, please help!!!!!!

Time:09-19

1. Use mycat connect mysql has successfully
2. The server.xml configuration







-->






2. The schema. The XML configuration
<? The XML version="1.0"?>


/> -->
WriteType="0" dbType="postgresql dbDriver"="JDBC" switchType="1" slaveThreshold="100" & gt;
The select user
Password="* * *" & gt;



Problems 3.
3.1 if use myeclipse through code links (links to establish, SQL is: select * from pattern. The table name, adding mode, an error: find no route), mysql and postgresql driver used
3.2 if use navicat can't even use (even the mysql connection, can connect, but there is no table, click on view will be an error
Connect with the postgresql, then quote: received invalid response to SSL negotiation: U)