maxlange commented on issue #7947:
URL: https://github.com/apache/shardingsphere/issues/7947#issuecomment-718305247
> Can you provider the configuration and the sql when exception threw?
excute SQLParserFactory#newInstance(final String databaseTypeName, final
String sql),the first parameter databaseType="MySQL",the second parameter
sql="SELECT
bill_id,sub_sn,bill_sn,return_trade_no,is_pay,service_type,payment_name,pay_config,trade_price,payment_plugin_id
FROM es_payment_bill WHERE (sub_sn = ? AND service_type = ?)",Is there any
configuration needed?The configuration of the shardingsphere is written in the
yaml file.like this:
> spring:
profiles:
shardingsphere:
props:
sql:
show: true
sharding:
default-data-source-name: ds0
datasource:
names: ds0
ds0:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.jdbc.Driver
url:
jdbc:mysql://xxx:3306/trade?useUnicode=true&characterEncoding=utf8&autoReconnect=true
username: xxx
password: xxx
----------------------------------------------------------------
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:
[email protected]
