Hi, For 1: If you can reproduce this problem, can you reply with the table structure? And I will reopen that issue.
For 2: Can you provide more information? Like config and SQLs. For 3: Is data updated successfully? Please provide more information like config and SQLs. If you like, please open new issues on GitHub for 2 and 3. Zhang Yonglun Apache ShardingSphere Jiang Raigor <[email protected]> 于2019年11月19日周二 上午10:51写道： > Hi, everyone, > > I found some issues with Sharding-Proxy when using postgres and collected > as follows: > > First, I prepared an environment like: > > https://github.com/apache/incubator-shardingsphere/issues/3419, > > my postgres version is 12.0, and use the latest Proxy source code. > (commit 962a9656 zhaojun <[email protected]> on 2019-11-17 at 17:18) > > > The issues are: > > 1) Cannot find JDBC type '2003' in PostgreSQL column type (Existing) > > https://github.com/apache/incubator-shardingsphere/issues/3104 > > > 2) receiveErrorResponse for postgres client (new) > > When use JDBC client to insert record with Proxy, whether use Statement or > PreparedStatement, the Proxy can insert successful, > but the JDBC client receives error response. > > Error log of Statement: > org.postgresql.util.PSQLException: > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) > at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303) > at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289) > at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266) > at org.postgresql.jdbc.PgStatement.executeUpdate(PgStatement.java:246) > > > Error log of PreparedStatement: > org.postgresql.util.PSQLException: > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430) > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356) > at > org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168) > at > org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:135) > > 3) when update a record, response of num is 0 (new) > > When use JDBC client to update record with Proxy, it will success, but the > result num is 0; > Otherwise, if excute update SQL without Proxy, the result num is 1; > > I don't know if these issues need to be dealt with together? > > 获取 Outlook for Android<https://aka.ms/ghei36> >
