[GitHub] [shardingsphere] maxlange commented on issue #7947: java.lang.UnsupportedOperationException: Cannot support database type 'MySQL'

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

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