lklkxcxc opened a new issue #4334: Java jdbc connect sharding-proxy return 
error:Table 'test.tb_user' doesn't exist
URL: https://github.com/apache/incubator-shardingsphere/issues/4334
 
 
   - Problem description: sharding-proxy can be connected through mysql client 
and the table `tb_user` can be searched.Use Java jdbc connect sharding-proxy 
return error:`### Error querying database. Cause: 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.tb_user' 
doesn't exist ### The error may exist in class path resource 
[mybatis/mapper/TbUserMapper.xml] ### The error may involve 
cn.cechealth.kol.dao.TbUserMapper.searchUserByName-Inline ### The error 
occurred while setting parameters ### SQL: select * from tb_user where 
user_name =? ### Cause: 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.tb_user' 
doesn't exist ; bad SQL grammar []; nested exception is 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.tb_user' 
doesn't exist`
   
   
   - JDBC conifg:`datasource:
   
       url: 
jdbc:mysql://${MYSQL_SERVICE_HOST:192.16.56.44}:${MYSQL_SERVICE_PORT:3306}/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&allowMultiQueries=true
   `

----------------------------------------------------------------
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:
us...@infra.apache.org


With regards,
Apache Git Services

Reply via email to