[GitHub] [shardingsphere] chenfei430124 commented on issue #2712: 【4.0.0-RC2 & 4.0.0-RC3-SNAPSHOT】sharding-jdbc-spring-boot-starter init dataSource failed

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

chenfei430124 commented on issue #2712:
URL: https://github.com/apache/shardingsphere/issues/2712#issuecomment-616416379


   > I have the same problem but I only use mybatis.
   > 
   > **the error stack info:**
   > 
   > APPLICATION FAILED TO START
   > 
   > Description:
   > 
   > Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could be configured.
   > 
   > Reason: Failed to determine a suitable driver class
   > 
   > Action:
   > 
   > Consider the following:
   > If you want an embedded database (H2, HSQL or Derby), please put it on the classpath.
   > If you have database settings to be loaded from a particular profile you may need to activate it (no profiles are currently active).
   > 
   > Disconnected from the target VM, address: '127.0.0.1:51648', transport: 'socket'
   > 
   > Process finished with exit code 1
   > 
   > **my application.properties is**
   > spring.shardingsphere.datasource.names=ds_0,ds_1
   > 
   > spring.shardingsphere.datasource.ds_0.type=com.zaxxer.hikari.HikariDataSource
   > spring.shardingsphere.datasource.ds_0.driver-class-name=com.mysql.jdbc.Driver
   > spring.shardingsphere.datasource.ds_0.jdbc-url=jdbc:mysql://localhost:3306/ds0?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
   > spring.shardingsphere.datasource.ds_0.username=root
   > spring.shardingsphere.datasource.ds_0.password=
   > 
   > spring.shardingsphere.datasource.ds_1.type=com.zaxxer.hikari.HikariDataSource
   > spring.shardingsphere.datasource.ds_1.driver-class-name=com.mysql.jdbc.Driver
   > spring.shardingsphere.datasource.ds_1.jdbc-url=jdbc:mysql://localhost:3306/ds1?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
   > spring.shardingsphere.datasource.ds_1.username=root
   > spring.shardingsphere.datasource.ds_1.password=
   > 
   > spring.shardingsphere.sharding.default-database-strategy.inline.sharding-column=user_id
   > spring.shardingsphere.sharding.default-database-strategy.inline.algorithm-expression=ds_$->{user_id % 2}
   > 
   > spring.shardingsphere.sharding.tables.t_order.actual-data-nodes=ds$->{0..1}.t_order
   > spring.shardingsphere.sharding.tables.t_order.key-generator.column=order_id
   > spring.shardingsphere.sharding.tables.t_order.key-generator.type=SNOWFLAKE
   > spring.shardingsphere.sharding.tables.t_order.key-generator.props.worker.id=123
   > spring.shardingsphere.sharding.tables.t_order_item.actual-data-nodes=ds$->{0..3}.t_order_item
   > spring.shardingsphere.sharding.tables.t_order_item.key-generator.column=order_item_id
   > spring.shardingsphere.sharding.tables.t_order_item.key-generator.type=SNOWFLAKE
   > spring.shardingsphere.sharding.tables.t_order_item.key-generator.props.worker.id=123
   > 
   > spring.shardingsphere.props.sql.show=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:
users@infra.apache.org