static0807 opened a new issue, #26815:
URL: https://github.com/apache/shardingsphere/issues/26815

   ## Question
   
   my shardingsphere version is 5.3.2
   
   because i want to dynamically refresh the encrypt rule by settings. so i try 
to use the distsql refresh the rules in my program.
   
   I use jdbc to connect to postgreSQL through proxy,
   
   first,i create logic database, so i execute "create database xxx",
   
   second, i want to register storage unit , i want switch to the new database, 
so i execute "USE XXX", but an error occurred.
   
   Exception in thread "main" org.postgresql.util.PSQLException: ERROR: You 
have an error in your SQL syntax: USE test_pg, no viable alternative at input 
'USE' at line 1, position 0, near [@0,0:2='USE',<589>,1:0]
   
   i change to execute "\c xxx", but it also error.
   
   Exception in thread "main" org.postgresql.util.PSQLException: ERROR: You 
have an error in your SQL syntax: \c test_pg, no viable alternative at input 
'\' at line 1, position 0, near [@0,0:0='\',<17>,1:0]
   
   so, when i use jdbc  connect shardingsphere proxy, how i switch to other 
database on postgresql
   


-- 
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.

To unsubscribe, e-mail: 
notifications-unsubscr...@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to