1.使用mycat連接mysql已經成功
2.server.xml的配置
<user name="root">
<property name="password">123456</property>
<property name="schemas">TESTDB</property>
<!-- 表級 DML 權限設定 -->
<!--
<privileges check="false">
<schema name="TESTDB" dml="0110" >
<table name="tb01" dml="0000"></table>
<table name="tb02" dml="1111"></table>
</schema>
</privileges>
-->
</user>
<user name="user">
<property name="password">user</property>
<property name="schemas">TESTDB</property>
<property name="readOnly">true</property>
</user>
2.schema.xml的配置
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
<schema name="TESTDB" checkSQLschema="true" sqlMaxLimit="100">
<table name="g_pd_cablepsr" primaryKey="fid" dataNode="dn1" />
</schema>
<!-- <dataNode name="dn1$0-743" dataHost="localhost1" database="db$0-743"
/> -->
<dataNode name="dn1" dataHost="localhost1" database="gisdb" />
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="0"
writeType="0" dbType="postgresql" dbDriver="jdbc" switchType="1" slaveThreshold="100">
<heartbeat>select user</heartbeat>
<!-- can have multi write hosts -->
<writeHost host="hostM1" url="jdbc:postgresql://localhost:5432/gisdb" user="postgres"
password="***">
<!-- can have multi read hosts -->
<readHost host="hostS2" url="jdbc:postgresql://localhost:5432/gisdb" user="postgres" password="***" />
</writeHost>
</dataHost>
</mycat:schema>
3.遇到的問題
3.1 若使用myeclipse通過代碼連接(連接能建立,sql為：select * from 模式.表名，前面加模式，報錯:find no route)，mysql和postgresql的驅動都用過
3.2 若使用navicat連(用連mysql的方式連接，能連上，但是沒有表，點擊視圖就會報錯
用連postgresql的方式連接,則報:received invalid response to SSL negotiation: U)
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/54237.html
標籤：PostgreSQL