You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/09/10 09:53:07 UTC

[GitHub] [shardingsphere] AdelaHong opened a new issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

AdelaHong opened a new issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345


   java.lang.IllegalArgumentException: Cannot support database type 'MySQL'
   


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-916820746


   Hi @AdelaHong 
   Please provide more detail info. 


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917959356


   ![image](https://user-images.githubusercontent.com/5668787/133049879-61d32976-8da5-4369-b6d3-f5834db4b7d9.png)
   


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917360743


   > `<dependency> <groupId>org.apache.shardingsphere</groupId> <artifactId>shardingsphere-jdbc-core</artifactId> <version>5.0.0-RC1-SNAPSHO</version> </dependency>`
   
   `SNAPSHO`? Is it a spelling mistake?
   Since you are using springboot, you should consider using shardingsphere springboot starter.
   Please refer to the [document](https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-jdbc/usage/sharding/spring-boot-starter/) and [example](https://github.com/apache/shardingsphere/blob/master/examples/shardingsphere-jdbc-example/sharding-example/sharding-spring-boot-mybatis-example/pom.xml)


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918013932


   ![image](https://user-images.githubusercontent.com/5668787/133060871-9bd4fbe0-8be9-426a-994e-034871919c6c.png)
   
   So what is your dependent package name now?


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918007411


   Just checked, after rebuilding, just repackage the dependencies and use


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918744690


   > If it is determined that there is no problem with the environment, it would be strange.
   > Can you compare with the example project and see if there are any differences?
   > Or please upload a demo project to github to help us reproduce the problem.
   
   Could you provide a test project which can reproduce the problem.


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917814920


   > There is no problem with the environment, the 5.0.1-beta version starts normally, but the switch to 5.0.0-RC1-SNAPSHOT version starts an error
   
   OK, so could you provide your sharding configuration?  


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918012473


   No, what I mean is: just rebuild the master branch code, re-type the jar package for dependency reference, and make no other changes


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917371444


   Can you run the example project so that you can confirm if there is a problem with your environment.


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-916923333


   
   **ServiceLoader.load(DatabaseTypedSQLParserFacade.class)     
   the content obtained by this code is null**
   `@NoArgsConstructor(access = AccessLevel.PRIVATE)
   public final class DatabaseTypedSQLParserFacadeRegistry {
       
       private static final Map<String, DatabaseTypedSQLParserFacade> FACADES = new HashMap<>();
       
       static {
           for (DatabaseTypedSQLParserFacade each : ServiceLoader.load(DatabaseTypedSQLParserFacade.class)) {
               FACADES.put(each.getDatabaseType(), each);
           }
       }
       
       /**
        * Get database type based SQL parser facade.
        * 
        * @param databaseType database type
        * @return database type based SQL parser facade
        */
       public static DatabaseTypedSQLParserFacade getFacade(final String databaseType) {
           Preconditions.checkArgument(FACADES.containsKey(databaseType), "Cannot support database type '%s'", databaseType);
           return FACADES.get(databaseType);
       }
   }`


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917888576


   datasource configuration:
   
   `datasource.c3p0.write.jdbcUrl = jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false&serverTimezone=GMT%2B8
   datasource.c3p0.write.user = root
   datasource.c3p0.write.password = 123456
   datasource.c3p0.write.driverClass = com.mysql.jdbc.Driver
   datasource.c3p0.write.minPoolSize = 3
   datasource.c3p0.write.maxPoolSize = 100
   datasource.c3p0.write.maxIdleTime = 3600
   datasource.c3p0.write.acquireIncrement = 3
   datasource.c3p0.write.maxStatements = 1000
   datasource.c3p0.write.initialPoolSize = 3
   datasource.c3p0.write.idleConnectionTestPeriod = 60
   datasource.c3p0.write.acquireRetryAttempts = 3
   datasource.c3p0.write.acquireRetryDelay = 1000
   datasource.c3p0.write.breakAfterAcquireFailure = false
   datasource.c3p0.write.testConnectionOnCheckout = false
   datasource.c3p0.write.testConnectionOnCheckin = true
   
   
   #增加C3P0数据源配置
   datasource.c3p0.read.jdbcUrl = jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false&serverTimezone=GMT%2B8
   datasource.c3p0.read.user = root
   datasource.c3p0.read.password = 123456
   datasource.c3p0.read.driverClass = com.mysql.jdbc.Driver
   datasource.c3p0.read.minPoolSize = 3
   datasource.c3p0.read.maxPoolSize = 100
   datasource.c3p0.read.maxIdleTime = 3600
   datasource.c3p0.read.acquireIncrement = 3
   datasource.c3p0.read.maxStatements = 1000
   datasource.c3p0.read.initialPoolSize = 3
   datasource.c3p0.read.idleConnectionTestPeriod = 60
   datasource.c3p0.read.acquireRetryAttempts = 3
   datasource.c3p0.read.acquireRetryDelay = 1000
   datasource.c3p0.read.breakAfterAcquireFailure = false
   datasource.c3p0.read.testConnectionOnCheckout = false
   datasource.c3p0.read.testConnectionOnCheckin = true`
   
   
   sharding configuration:
   
   `@Configuration
   public class ShardingConfiguration {
   
       @Bean
       @ConfigurationProperties("datasource.c3p0.write")
       public DataSource writeDataSource(){
           return DataSourceBuilder.create().type(ComboPooledDataSource.class).build();
       }
   
       @Bean
       @ConfigurationProperties("datasource.c3p0.read")
       public DataSource readDataSource(){
           return DataSourceBuilder.create().type(ComboPooledDataSource.class).build();
       }
   
   
       /**
        * C3P0-0.9.1.2
        * Shard-JDBC 分库配置
        */
       @Bean
       @DependsOn({"writeDataSource", "readDataSource"})
       @Primary
       public DataSource shardDataSource(DataSource writeDataSource, DataSource readDataSource) throws Exception {
   
           Map<String,DataSource> targetDataSources = new HashMap<>();
           targetDataSources.put("ds_write", writeDataSource);
           targetDataSources.put("ds_read", readDataSource);
   
           return ShardingSphereDataSourceFactory.createDataSource(
                   targetDataSources,
                   Arrays.asList(
                           createShardingRuleConfiguration(),
                           createReadwriteSplittingConfiguration(),
                           createEncryptRuleConfiguration())
                   , new Properties());
       }
   
   
       protected ReadwriteSplittingRuleConfiguration createReadwriteSplittingConfiguration() {
           ReadwriteSplittingDataSourceRuleConfiguration dataSourceConfiguration = new ReadwriteSplittingDataSourceRuleConfiguration(
                   "ds_0", "", "ds_write", Arrays.asList("ds_read"), null, false);
           return new ReadwriteSplittingRuleConfiguration(Arrays.asList(dataSourceConfiguration), Collections.emptyMap());
       }
   
   
   
       protected ShardingRuleConfiguration createShardingRuleConfiguration() {
           ShardingRuleConfiguration shardingRuleConfig = new ShardingRuleConfiguration();
   
           String actualDataNodes = "ds_0.tf_f_finance_bill_${0.."+ (32 - 1) +"}";
   
           ShardingTableRuleConfiguration configuration =
                   new ShardingTableRuleConfiguration("tf_f_finance_bill", actualDataNodes);
           configuration.setTableShardingStrategy(new StandardShardingStrategyConfiguration("CUSTOMER_ID", MOD_32));
           shardingRuleConfig.getTables().add(configuration);
   
           return shardingRuleConfig;
       }
   
   
       public EncryptRuleConfiguration createEncryptRuleConfiguration() {
           Map<String, ShardingSphereAlgorithmConfiguration> encryptAlgorithmConfigs = new LinkedHashMap<>();
           Properties encryptProperties = new Properties();
           encryptProperties.setProperty("aes-key-value", "123456");
           encryptAlgorithmConfigs.put("aes", new ShardingSphereAlgorithmConfiguration("AES", encryptProperties));
   
   
           Collection<EncryptTableRuleConfiguration> tables = new LinkedList<>();
   
           Collection<EncryptColumnRuleConfiguration> columns = new LinkedList<>();
           EncryptColumnRuleConfiguration columnRuleConfiguration = new EncryptColumnRuleConfiguration("NUMBER","NUMBER","","","aes");
           columns.add(columnRuleConfiguration);
           EncryptTableRuleConfiguration configuration = new EncryptTableRuleConfiguration("tf_b_bill", columns);
           tables.add(configuration);
   
           EncryptRuleConfiguration encryptRuleConfiguration = new EncryptRuleConfiguration(tables,encryptAlgorithmConfigs);
           return encryptRuleConfiguration;
       }
   }
   `
   


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917958359


   Hi @AdelaHong 
   Please do a check:
   Is `shardingsphere-sql-parser-mysql` in the dependency list of your project?


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917324890


   <dependency>
   			<groupId>org.apache.shardingsphere</groupId>
   			<artifactId>shardingsphere-jdbc-core</artifactId>
   			<version>5.0.0-RC1-SNAPSHO</version>
   		</dependency>


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918001672


   Has been rebuilt without any changes, just changed the maven artifactId


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918097706


   If it is determined that there is no problem with the environment, it would be strange.
   Can you compare with the example project and see if there are any differences?
   Or please upload a demo project to github to help us reproduce the problem.


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918068825


   This is our partial reliance information:
   ![OSY)4 N_HX0XXT2N9D(M(K](https://user-images.githubusercontent.com/24450438/133070499-498db5c0-f321-4c1e-acf3-ae1d34740e41.png)
   


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917368692


   Download the shardingsphere master branch, and the packaged version number is: 5.0.0-RC1-SNAPSHOT. After the spring boot project is imported
   `<dependency>
   			<groupId>org.apache.shardingsphere</groupId>
   			<artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
   			<version>5.0.0-RC1-SNAPSHOT</version>
   		</dependency>
   		<dependency>
   			<groupId>org.mybatis.spring.boot</groupId>
   			<artifactId>mybatis-spring-boot-starter</artifactId>
   		</dependency>
   		<dependency>
   			<groupId>org.springframework.boot</groupId>
   			<artifactId>spring-boot-starter-test</artifactId>
   		</dependency>`
   , it still reports an error after the project starts successfully: 
    java.lang.IllegalArgumentException: Cannot support database type 'MySQL'
   
   Specify the database type as MySQL
   `public DataSource shardDataSource(DataSource writeDataSource, DataSource readDataSource) throws Exception {
   
           Map<String,DataSource> targetDataSources = new HashMap<>();
           targetDataSources.put("ds_write", writeDataSource);
           targetDataSources.put("ds_read", readDataSource);
   
           return ShardingSphereDataSourceFactory.createDataSource(
                   targetDataSources,
                   Arrays.asList(
                           shardingConfigurationBuilder.createShardingRuleConfiguration(),
                           createReadwriteSplittingConfiguration(),
                           shardingConfigurationBuilder.createEncryptRuleConfiguration())
                   , new Properties());
       }`
   ![image](https://user-images.githubusercontent.com/24450438/132941779-d340e8c3-24e2-4e12-b280-1658ddbe9904.png)
   


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] HoasZhang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
HoasZhang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918774300


   We tried to extract a small item, but it could not be reproduced, but our error mainly occurred when the datasourcehealthindicator called and executed select 1.
   org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-916918651


   021-09-10 17:35:25.466 [main] INFO  com.im.pps.account.biz.PpsAccountApplication - ========== StartApplication启动成功 ==========
   2021-09-10 17:35:26.085 [RMI TCP Connection(5)-192.168.88.101] INFO  o.a.c.core.ContainerBase.[Tomcat].[localhost].[/] - Initializing Spring FrameworkServlet 'dispatcherServlet'
   2021-09-10 17:35:26.086 [RMI TCP Connection(5)-192.168.88.101] INFO  org.springframework.web.servlet.DispatcherServlet - FrameworkServlet 'dispatcherServlet': initialization started
   2021-09-10 17:35:26.126 [RMI TCP Connection(5)-192.168.88.101] INFO  org.springframework.web.servlet.DispatcherServlet - FrameworkServlet 'dispatcherServlet': initialization completed in 40 ms
   2021-09-10 17:35:46.495 [RMI TCP Connection(4)-192.168.88.101] WARN  o.s.boot.actuate.jdbc.DataSourceHealthIndicator - DataSource health check failed
   java.lang.IllegalArgumentException: Cannot support database type 'MySQL'
   	at com.google.common.base.Preconditions.checkArgument(Preconditions.java:216)
   	at org.apache.shardingsphere.sql.parser.core.database.parser.DatabaseTypedSQLParserFacadeRegistry.getFacade(DatabaseTypedSQLParserFacadeRegistry.java:50)
   	at org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.twoPhaseParse(SQLParserExecutor.java:55)
   	at org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.parse(SQLParserExecutor.java:47)
   	at org.apache.shardingsphere.sql.parser.api.SQLParserEngine.parse(SQLParserEngine.java:51)
   	at org.apache.shardingsphere.infra.parser.sql.SQLStatementParserExecutor.parse(SQLStatementParserExecutor.java:47)
   	at org.apache.shardingsphere.infra.parser.sql.SQLStatementParserEngine.parse(SQLStatementParserEngine.java:48)
   	at org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse0(ShardingSphereSQLParserEngine.java:67)
   	at org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse(ShardingSphereSQLParserEngine.java:56)
   	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.createLogicSQL(ShardingSphereStatement.java:364)
   	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.createExecutionContext(ShardingSphereStatement.java:372)
   	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.executeQuery(ShardingSphereStatement.java:146)
   	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:433)
   	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
   	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:446)
   	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
   	at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doDataSourceHealthCheck(DataSourceHealthIndicator.java:114)
   	at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doHealthCheck(DataSourceHealthIndicator.java:104)
   	at org.springframework.boot.actuate.health.AbstractHealthIndicator.health(AbstractHealthIndicator.java:84)
   	at org.springframework.boot.actuate.health.CompositeHealthIndicator.health(CompositeHealthIndicator.java:68)
   	at org.springframework.boot.actuate.health.CompositeHealthIndicator.health(CompositeHealthIndicator.java:68)
   	at org.springframework.boot.actuate.health.HealthEndpoint.health(HealthEndpoint.java:47)
   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.lang.reflect.Method.invoke(Method.java:483)
   	at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:223)
   	at org.springframework.boot.actuate.endpoint.invoke.reflect.ReflectiveOperationInvoker.invoke(ReflectiveOperationInvoker.java:76)
   	at org.springframework.boot.actuate.endpoint.annotation.AbstractDiscoveredOperation.invoke(AbstractDiscoveredOperation.java:61)
   	at org.springframework.boot.actuate.endpoint.jmx.EndpointMBean.invoke(EndpointMBean.java:102)
   	at org.springframework.boot.actuate.endpoint.jmx.EndpointMBean.invoke(EndpointMBean.java:93)
   	at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)
   	at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
   	at javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1466)
   	at javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:76)
   	at javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1307)
   	at javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1399)
   	at javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:828)
   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.lang.reflect.Method.invoke(Method.java:483)
   	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:323)
   	at sun.rmi.transport.Transport$1.run(Transport.java:178)
   	at sun.rmi.transport.Transport$1.run(Transport.java:175)
   	at java.security.AccessController.doPrivileged(Native Method)
   	at sun.rmi.transport.Transport.serviceCall(Transport.java:174)
   	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:557)
   	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:812)
   	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:671)
   	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
   	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
   	at java.lang.Thread.run(Thread.java:745)
   2021-09-10 17:35:46.626 [RMI TCP Connection(4)-192.168.88.101] INFO  io.lettuce.core.EpollProvider - Starting without optional epoll library
   2021-09-10 17:35:46.631 [RMI TCP Connection(4)-192.168.88.101] INFO  io.lettuce.core.KqueueProvider - Starting without optional kqueue library


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918017674


   Because according to your previous screenshot, the jar package name is not standardized, so maven cannot find the right dependent package.


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917994356


   Because the Cannot find strategy for generate keys problem occurred in the 5.0.0-beta version, check the GitHub that the master branch has fixed this problem, so I downloaded the master branch to the local and renamed it


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918016890


   > `<dependency> <groupId>org.apache.shardingsphere</groupId> <artifactId>shardingsphere-sql-parser-mysql</artifactId> <version>5.0.0-RC1-SNAPSHOT</version> </dependency>`
   
   What about the jar file name.


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong removed a comment on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong removed a comment on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918007038


   Just checked, after rebuilding, just repackage the dependencies and use


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917997388


   Can you rebuild it without making any changes?


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918003505


   Why you change artifactId?


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] HoasZhang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
HoasZhang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918739907


   This is my exception information. I guess the springboot DB health check uses JDBC template, but we use other instead.
   Similar problems link:https://www.cnblogs.com/maohuidong/p/15006724.html
   ---------------
   java.lang.IllegalArgumentException: Cannot support database type 'MySQL'
   	at com.google.common.base.Preconditions.checkArgument(Preconditions.java:216)
   	at org.apache.shardingsphere.sql.parser.core.database.parser.DatabaseTypedSQLParserFacadeRegistry.getFacade(DatabaseTypedSQLParserFacadeRegistry.java:50)
   	at org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.twoPhaseParse(SQLParserExecutor.java:55)
   	at org.apache.shardingsphere.sql.parser.core.database.parser.SQLParserExecutor.parse(SQLParserExecutor.java:47)
   	at org.apache.shardingsphere.sql.parser.api.SQLParserEngine.parse(SQLParserEngine.java:51)
   	at org.apache.shardingsphere.infra.parser.sql.SQLStatementParserExecutor.parse(SQLStatementParserExecutor.java:47)
   	at org.apache.shardingsphere.infra.parser.sql.SQLStatementParserEngine.parse(SQLStatementParserEngine.java:48)
   	at org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse0(ShardingSphereSQLParserEngine.java:67)
   	at org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse(ShardingSphereSQLParserEngine.java:56)
   	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.createLogicSQL(ShardingSphereStatement.java:364)
   	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.createExecutionContext(ShardingSphereStatement.java:372)
   	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.executeQuery(ShardingSphereStatement.java:146)
   	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:433)
   	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:376)
   	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:446)
   	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917991515


   > In the following code
   static { for (DatabaseTypedSQLParserFacade each : ServiceLoader.load(DatabaseTypedSQLParserFacade.class)) { FACADES.put(each.getDatabaseType(), each); } }
   ServiceLoader.load(DatabaseTypedSQLParserFacade.class) Nothing is loaded, so the FACADES field is empty
   
   Yes, the SPI should not be empty, so I suggest you check the dependencies.
   How did you build ShardingSphere?


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918015788


   <dependency>
   			<groupId>org.apache.shardingsphere</groupId>
   			<artifactId>shardingsphere-sql-parser-mysql</artifactId>
   			<version>5.0.0-RC1-SNAPSHOT</version>
   		</dependency>


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918015886


   `<dependency>
   			<groupId>org.apache.shardingsphere</groupId>
   			<artifactId>shardingsphere-sql-parser-mysql</artifactId>
   			<version>5.0.0-RC1-SNAPSHOT</version>
   		</dependency>`


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917984712


   shardingsphere-sql-parser-mysql is already dependent
   ![image](https://user-images.githubusercontent.com/24450438/133052400-6d39f6dc-4e8a-4859-a081-46a04bb644c3.png)
   
   <dependency>
   			<groupId>org.apache.shardingsphere</groupId>
   			<artifactId>shardingsphere-jdbc-core</artifactId>
   			<version>5.0.0-RC1-SNAPSHOT</version>
   		</dependency>
   		<dependency>
   			<groupId>org.apache.shardingsphere</groupId>
   			<artifactId>shardingsphere-sql-parser-mysql</artifactId>
   			<version>5.0.0-RC1-SNAPSHOT</version>
   		</dependency>
   
   DatabaseTypedSQLParserFacadeRegistry.class
   
   In the following code
   `static {
           for (DatabaseTypedSQLParserFacade each : ServiceLoader.load(DatabaseTypedSQLParserFacade.class)) {
               FACADES.put(each.getDatabaseType(), each);
           }
       }`
   ServiceLoader.load(DatabaseTypedSQLParserFacade.class) Nothing is loaded, so the FACADES field is empty
   


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang edited a comment on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang edited a comment on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917992073


   The name of your dependent packages is not standardized. Did you make any changes?


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918776613


   Thanks for your feedback, I have logged this issue and will continue to investigate, but it may take a long time.


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] HoasZhang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
HoasZhang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918745795


   We use the following configuration to temporarily solve this problem. Is there a better solution here? We don't want to turn off the health check of DB,and test insert one record。
   I think it's because the springboot JDBC template doesn't come under shardingjdbc's supervision
   -------
   management.health.db.enabled=false
   
   


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918749930


   This is the first time that this problem has been mentioned. Welcome to study and propose a solution together.
   
   > ## We use the following configuration to temporarily solve this problem. Is there a better solution here? We don't want to turn off the health check of DB,and test insert one record。
   > I think it's because the springboot JDBC template doesn't come under shardingjdbc's supervision
   > management.health.db.enabled=false
   
   


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-916989904


   @AdelaHong 
   - What is your version of ShardingSphere?
   - What is the name of the dependent pom?
   I ask these questions because it looks like some dependencies are missing.
   


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917325587


   When I first used version 5.0.1-beta, it appeared: Cannot find strategy for generate keys;
   After downloading the master version, there appeared: java.lang.IllegalArgumentException: Cannot support database type'MySQL'


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917324990


   `<dependency>
   			<groupId>org.apache.shardingsphere</groupId>
   			<artifactId>shardingsphere-jdbc-core</artifactId>
   			<version>5.0.0-RC1-SNAPSHO</version>
   		</dependency>`


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] wuma commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
wuma commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918079879


   > Why you change artifactId?
   
   We changed the artifactid because we used version 4.0.0-rc1 before


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918010430


   Can it work? 
   
   > Just checked, after rebuilding, just repackage the dependencies and use
   
   


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917800214


   There is no problem with the environment, the 5.0.1-beta version starts normally, but the switch to 5.0.0-RC1-SNAPSHOT version starts an error


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong removed a comment on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong removed a comment on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918015788


   <dependency>
   			<groupId>org.apache.shardingsphere</groupId>
   			<artifactId>shardingsphere-sql-parser-mysql</artifactId>
   			<version>5.0.0-RC1-SNAPSHOT</version>
   		</dependency>


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang edited a comment on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang edited a comment on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917371444


   Can you run the example project so that you can confirm if there is a problem with your environment.
   https://github.com/apache/shardingsphere/tree/master/examples/shardingsphere-jdbc-example/sharding-example


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918744381


   I think It does not look similar. 
   Your exception is because the SPI is not loaded. Since the health check is in the same process, the dependent packages can also be found.


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] AdelaHong commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
AdelaHong commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-918007038


   Just checked, after rebuilding, just repackage the dependencies and use


-- 
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-unsubscribe@shardingsphere.apache.org

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



[GitHub] [shardingsphere] RaigorJiang commented on issue #12345: 5.0.0-RC1 The Springboot project failed to start:java.lang.IllegalArgumentException: Cannot support database type 'MySQL'

Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #12345:
URL: https://github.com/apache/shardingsphere/issues/12345#issuecomment-917992073


   The naming of your dependent packages is not standardized. Did you make any changes?


-- 
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-unsubscribe@shardingsphere.apache.org

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