[GitHub] [incubator-shardingsphere] RaigorJiang opened a new issue #3555: (Proxy) Receive error response for postgres JDBC client

[GitBox <gi...@apache.org>]

RaigorJiang opened a new issue #3555: (Proxy) Receive error response for postgres JDBC client
URL: https://github.com/apache/incubator-shardingsphere/issues/3555
 
 
   ### Which version of ShardingSphere did you use?
   sharding-proxy : 4.0.0-RC3-SNAPSHOT
   
   ### Expected behavior
   Insert record successful and get a correct response.
   
   ### Actual behavior
   Insert record successful but the client get an error response.
   
   ### Steps to reproduce the behavior
   Table structure:
   ----------------------------------
   CREATETABLE public.t_encrypt (
   pwd varchar(32) NULL,
   "content"varchar(32) NULL
   )
   ----------------------------------
   config-encrypt.yaml:
   ----------------------------------
   schemaName: encrypt_db
   
   dataSource:
     url: jdbc:postgresql://127.0.0.1:5432/ds_encrypt?serverTimezone=UTC&useSSL=false
     username: postgres
     password: 123456
     connectionTimeoutMilliseconds: 30000
     idleTimeoutMilliseconds: 60000
     maxLifetimeMilliseconds: 1800000
     maxPoolSize: 50
   
   encryptRule:
     encryptors:
       encryptor_aes:
         type: aes
         props:
           aes.key.value: 123456abc
       encryptor_md5:
         type: md5
     tables:
       t_encrypt:
         columns:
           user_id:
             plainColumn: plainpwd
             cipherColumn: cipher_pwd
             encryptor: encryptor_aes
           order_id:
             cipherColumn: cipher_content
             encryptor: encryptor_md5
   ----------------------------------
   Code:
   `statement.executeUpdate(SQL_INSERT);`
   
   Actual behavior:
   The insert is successful and Proxy is OK, but the client gets an error.
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services