stephensuxun removed a comment on issue #11293:
URL:
https://github.com/apache/shardingsphere/issues/11293#issuecomment-878253717
现在已经将版本更新到5.0.0-beta
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core</artifactId>
<version>5.0.0-beta</version>
</dependency>
配置文件为
spring.shardingsphere.props.sql-show=true
spring.shardingsphere.datasource.common.driver-class-name=com.mysql.cj.jdbc.Driver
spring.shardingsphere.datasource.names=ds0
spring.shardingsphere.datasource.ds0.username=root
spring.shardingsphere.datasource.ds0.password=st18ts!20
spring.shardingsphere.datasource.ds0.url=jdbc:mysql://172.16.20.3:3306/ainewssystem-cloud?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai
spring.shardingsphere.datasource.ds0.type=com.alibaba.druid.pool.DruidDataSource
spring.shardingsphere.rules.sharding.sharding-algorithms.table-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.table-inline.props.algorithm-expression=ainews_user_$->{user_id
% 2}
spring.shardingsphere.rules.sharding.tables.t_user.actual-data-nodes=ds0.ainews_user_$->{0..1}
spring.shardingsphere.rules.sharding.tables.t_user.table-strategy.standard.sharding-column=user_id
spring.shardingsphere.rules.sharding.tables.t_user.table-strategy.standard.sharding-algorithm-name=table-inline
spring.shardingsphere.rules.sharding.key-generators.snowflake.type=SNOWFLAKE
spring.shardingsphere.rules.sharding.key-generators.snowflake.props.worker-id=123
##查看sql的输出日志
spring.shardingsphere.props.sql.show=true
##一个实体类对应两张表的设置
spring.main.allow-bean-definition-overriding = true
启动报错为
Error starting ApplicationContext. To display the conditions report re-run
your application with 'debug' enabled.
2021-07-12 20:49:55.658 ERROR 3664 --- [ restartedMain]
o.s.boot.SpringApplication : Application run failed
org.springframework.beans.factory.UnsatisfiedDependencyException: Error
creating bean with name 'userController': Unsatisfied dependency expressed
through field 'aiNewsUserService'; nested exception is
org.springframework.beans.factory.UnsatisfiedDependencyException: Error
creating bean with name 'aiNewsUserService': Unsatisfied dependency expressed
through field 'aiNewsUserMapper'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'aiNewsUserMapper' defined in file
[/usr/local/var/www/handehand/AinewSystem/ainewssystem_cloud_api/ainewssystem-cloud-api/ainewssystem-user/target/classes/com/ainewssystem/cloud/user/core/user/mapper/AiNewsUserMapper.class]:
Invocation of init method failed; nested exception is
java.lang.IllegalArgumentException: Property 'sqlSessionFactory' or
'sqlSessionTemplate' are required
at
org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:643)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:130)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1420)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:897)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879)
~[spring-context-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551)
~[spring-context-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143)
~[spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE]
at
org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758)
[spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE]
at
org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750)
[spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE]
at
org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397)
[spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:315)
[spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1237)
[spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE]
at
org.springframework.boot.SpringApplication.run(SpringApplication.java:1226)
[spring-boot-2.3.4.RELEASE.jar:2.3.4.RELEASE]
at
com.ainewssystem.cloud.user.AiUserApplication.main(AiUserApplication.java:24)
[classes/:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_211]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_211]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_211]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_211]
at
org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49)
[spring-boot-devtools-2.3.4.RELEASE.jar:2.3.4.RELEASE]
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException:
Error creating bean with name 'aiNewsUserService': Unsatisfied dependency
expressed through field 'aiNewsUserMapper'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'aiNewsUserMapper' defined in file
[/usr/local/var/www/handehand/AinewSystem/ainewssystem_cloud_api/ainewssystem-cloud-api/ainewssystem-user/target/classes/com/ainewssystem/cloud/user/core/user/mapper/AiNewsUserMapper.class]:
Invocation of init method failed; nested exception is
java.lang.IllegalArgumentException: Property 'sqlSessionFactory' or
'sqlSessionTemplate' are required
at
org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:643)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:130)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1420)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1307)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1227)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
... 25 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'aiNewsUserMapper' defined in file
[/usr/local/var/www/handehand/AinewSystem/ainewssystem_cloud_api/ainewssystem-cloud-api/ainewssystem-user/target/classes/com/ainewssystem/cloud/user/core/user/mapper/AiNewsUserMapper.class]:
Invocation of init method failed; nested exception is
java.lang.IllegalArgumentException: Property 'sqlSessionFactory' or
'sqlSessionTemplate' are required
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1794)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1307)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1227)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
... 38 common frames omitted
Caused by: java.lang.IllegalArgumentException: Property 'sqlSessionFactory'
or 'sqlSessionTemplate' are required
at org.springframework.util.Assert.notNull(Assert.java:201)
~[spring-core-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.mybatis.spring.support.SqlSessionDaoSupport.checkDaoConfig(SqlSessionDaoSupport.java:122)
~[mybatis-spring-2.0.6.jar:2.0.6]
at
org.mybatis.spring.mapper.MapperFactoryBean.checkDaoConfig(MapperFactoryBean.java:73)
~[mybatis-spring-2.0.6.jar:2.0.6]
at
org.springframework.dao.support.DaoSupport.afterPropertiesSet(DaoSupport.java:44)
~[spring-tx-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1853)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1790)
~[spring-beans-5.2.9.RELEASE.jar:5.2.9.RELEASE]
... 48 common frames omitted
2021-07-12 20:49:56.538 WARN 3664 --- [ Thread-22]
c.a.nacos.common.notify.NotifyCenter : [NotifyCenter] Start destroying
Publisher
2021-07-12 20:49:56.539 WARN 3664 --- [ Thread-13]
c.a.n.common.http.HttpClientBeanHolder : [HttpClientBeanHolder] Start
destroying common HttpClient
2021-07-12 20:49:56.539 WARN 3664 --- [ Thread-22]
c.a.nacos.common.notify.NotifyCenter : [NotifyCenter] Destruction of the end
2021-07-12 20:49:56.540 WARN 3664 --- [ Thread-13]
c.a.n.common.http.HttpClientBeanHolder : [HttpClientBeanHolder] Destruction
of the end
Process finished with exit code 1
--
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]
