15806659098 opened a new issue, #18763:
URL: https://github.com/apache/shardingsphere/issues/18763
## Question
I have a problem when i execute select statement. I use
ShardingSphere-Proxy, version is 5.1.2 and Mysql JDBC Driver is 8.0.28. The
error is as follows. It similar to another problem #17888 . I think it may be
caused by PrepareStatement.
` Error querying database. Cause: java.sql.SQLSyntaxErrorException: This
version of ShardingSphere-Proxy doesn't yet support this SQL. 'You have an
error in your SQL syntax'
The error may exist in file
[D:\apache-tomcat-9.0.58\webapps\service_war\WEB-INF\classes\mapper\AcademicMapper.xml]
The error may involve com.dao.AcademicDao.queryAcademicByMingcheng-Inline
The error occurred while setting parameters
SQL: SELECT knowledgename,knowledgecontent FROM Academic WHERE knowledgename
like "%"?"%"
Cause: java.sql.SQLSyntaxErrorException: This version of
ShardingSphere-Proxy doesn't yet support this SQL. 'You have an error in your
SQL syntax'; bad SQL grammar []; nested exception is
java.sql.SQLSyntaxErrorException: This version of ShardingSphere-Proxy doesn't
yet support this SQL. 'You have an error in your SQL syntax'`
The select statement in my AcademicMapper.xml show in next picture.
It has no problem when i use MySql connected directly.
Thanks.
#17888
--
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:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
