jvmtar opened a new issue #2688: 加上这一行代码 
项目就起不来了“spring.shardingsphere.sharding.tables.auth_user.key-generator.column=id“
URL: https://github.com/apache/incubator-shardingsphere/issues/2688
 
 
   
   加上这一行代码 
项目就起不来了“spring.shardingsphere.sharding.tables.auth_user.key-generator.column=id“
   
   c.example.sharding.ShardingApplication   : No active profile set, falling 
back to default profiles: default
   2019-07-10 16:10:11.520  INFO 4968 --- [  restartedMain] 
.e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! 
Set 'spring.devtools.add-properties' to 'false' to disable
   2019-07-10 16:10:11.520  INFO 4968 --- [  restartedMain] 
.e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging 
consider setting the 'logging.level.web' property to 'DEBUG'
   2019-07-10 16:10:12.634  INFO 4968 --- [  restartedMain] 
.s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data 
repositories in DEFAULT mode.
   2019-07-10 16:10:12.739  INFO 4968 --- [  restartedMain] 
.s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository 
scanning in 91ms. Found 1 repository interfaces.
   2019-07-10 16:10:13.322  INFO 4968 --- [  restartedMain] 
trationDelegate$BeanPostProcessorChecker : Bean 
'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration'
 of type 
[org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$30f59178]
 is not eligible for getting processed by all BeanPostProcessors (for example: 
not eligible for auto-proxying)
   2019-07-10 16:10:13.998  INFO 4968 --- [  restartedMain] 
o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 
9786 (http)
   2019-07-10 16:10:14.046  INFO 4968 --- [  restartedMain] 
o.apache.catalina.core.StandardService   : Starting service [Tomcat]
   2019-07-10 16:10:14.047  INFO 4968 --- [  restartedMain] 
org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache 
Tomcat/9.0.21]
   2019-07-10 16:10:14.372  INFO 4968 --- [  restartedMain] 
o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded 
WebApplicationContext
   2019-07-10 16:10:14.372  INFO 4968 --- [  restartedMain] 
o.s.web.context.ContextLoader            : Root WebApplicationContext: 
initialization completed in 2852 ms
   2019-07-10 16:10:15.001  WARN 4968 --- [  restartedMain] 
ConfigServletWebServerApplicationContext : Exception encountered during context 
initialization - cancelling refresh attempt: 
org.springframework.beans.factory.UnsatisfiedDependencyException: Error 
creating bean with name 
'org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration': 
Unsatisfied dependency expressed through constructor parameter 0; nested 
exception is org.springframework.beans.factory.BeanCreationException: Error 
creating bean with name 'dataSource' defined in class path resource 
[org/apache/shardingsphere/shardingjdbc/spring/boot/SpringBootConfiguration.class]:
 Bean instantiation via factory method failed; nested exception is 
org.springframework.beans.BeanInstantiationException: Failed to instantiate 
[javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested 
exception is java.lang.IllegalArgumentException: Type is required.
   2019-07-10 16:10:15.006  INFO 4968 --- [  restartedMain] 
o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
   2019-07-10 16:10:15.025  INFO 4968 --- [  restartedMain] 
ConditionEvaluationReportLoggingListener : 
   
   Error starting ApplicationContext. To display the conditions report re-run 
your application with 'debug' enabled.
   2019-07-10 16:10:15.042 ERROR 4968 --- [  restartedMain] 
o.s.boot.SpringApplication               : Application run failed
   
   org.springframework.beans.factory.UnsatisfiedDependencyException: Error 
creating bean with name 
'org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaConfiguration': 
Unsatisfied dependency expressed through constructor parameter 0; nested 
exception is org.springframework.beans.factory.BeanCreationException: Error 
creating bean with name 'dataSource' defined in class path resource 
[org/apache/shardingsphere/shardingjdbc/spring/boot/SpringBootConfiguration.class]:
 Bean instantiation via factory method failed; nested exception is 
org.springframework.beans.BeanInstantiationException: Failed to instantiate 
[javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested 
exception is java.lang.IllegalArgumentException: Type is required.
        at 
org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:769)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:218)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1341)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1187)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:392)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1321)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1160)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1105)
 ~[spring-context-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
 ~[spring-context-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549)
 ~[spring-context-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140)
 ~[spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
        at 
org.springframework.boot.SpringApplication.refresh(SpringApplication.java:742) 
[spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
        at 
org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:389)
 [spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
        at 
org.springframework.boot.SpringApplication.run(SpringApplication.java:311) 
[spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
        at 
org.springframework.boot.SpringApplication.run(SpringApplication.java:1213) 
[spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
        at 
org.springframework.boot.SpringApplication.run(SpringApplication.java:1202) 
[spring-boot-2.1.6.RELEASE.jar:2.1.6.RELEASE]
        at 
com.example.sharding.ShardingApplication.main(ShardingApplication.java:19) 
[classes/:na]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
~[na:1.8.0_162]
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[na:1.8.0_162]
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[na:1.8.0_162]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
        at 
org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49)
 [spring-boot-devtools-2.1.6.RELEASE.jar:2.1.6.RELEASE]
   Caused by: org.springframework.beans.factory.BeanCreationException: Error 
creating bean with name 'dataSource' defined in class path resource 
[org/apache/shardingsphere/shardingjdbc/spring/boot/SpringBootConfiguration.class]:
 Bean instantiation via factory method failed; nested exception is 
org.springframework.beans.BeanInstantiationException: Failed to instantiate 
[javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested 
exception is java.lang.IllegalArgumentException: Type is required.
        at 
org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:627)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:456)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1321)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1160)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1251)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1171)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:857)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:760)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        ... 33 common frames omitted
   Caused by: org.springframework.beans.BeanInstantiationException: Failed to 
instantiate [javax.sql.DataSource]: Factory method 'dataSource' threw 
exception; nested exception is java.lang.IllegalArgumentException: Type is 
required.
        at 
org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:622)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        ... 47 common frames omitted
   Caused by: java.lang.IllegalArgumentException: Type is required.
        at 
com.google.common.base.Preconditions.checkArgument(Preconditions.java:122) 
~[guava-18.0.jar:na]
        at 
org.apache.shardingsphere.api.config.TypeBasedSPIConfiguration.<init>(TypeBasedSPIConfiguration.java:43)
 ~[sharding-core-api-4.0.0-RC1.jar:4.0.0-RC1]
        at 
org.apache.shardingsphere.api.config.sharding.KeyGeneratorConfiguration.<init>(KeyGeneratorConfiguration.java:44)
 ~[sharding-core-api-4.0.0-RC1.jar:4.0.0-RC1]
        at 
org.apache.shardingsphere.core.yaml.swapper.impl.KeyGeneratorConfigurationYamlSwapper.swap(KeyGeneratorConfigurationYamlSwapper.java:42)
 ~[sharding-core-common-4.0.0-RC1.jar:4.0.0-RC1]
        at 
org.apache.shardingsphere.core.yaml.swapper.impl.TableRuleConfigurationYamlSwapper.swap(TableRuleConfigurationYamlSwapper.java:66)
 ~[sharding-core-common-4.0.0-RC1.jar:4.0.0-RC1]
        at 
org.apache.shardingsphere.core.yaml.swapper.impl.ShardingRuleConfigurationYamlSwapper.swap(ShardingRuleConfigurationYamlSwapper.java:82)
 ~[sharding-core-common-4.0.0-RC1.jar:4.0.0-RC1]
        at 
org.apache.shardingsphere.shardingjdbc.spring.boot.SpringBootConfiguration.dataSource(SpringBootConfiguration.java:95)
 ~[sharding-jdbc-spring-boot-starter-4.0.0-RC1.jar:4.0.0-RC1]
        at 
org.apache.shardingsphere.shardingjdbc.spring.boot.SpringBootConfiguration$$EnhancerBySpringCGLIB$$c4e678d1.CGLIB$dataSource$0(<generated>)
 ~[sharding-jdbc-spring-boot-starter-4.0.0-RC1.jar:4.0.0-RC1]
        at 
org.apache.shardingsphere.shardingjdbc.spring.boot.SpringBootConfiguration$$EnhancerBySpringCGLIB$$c4e678d1$$FastClassBySpringCGLIB$$39856f95.invoke(<generated>)
 ~[sharding-jdbc-spring-boot-starter-4.0.0-RC1.jar:4.0.0-RC1]
        at 
org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) 
~[spring-core-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:363)
 ~[spring-context-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        at 
org.apache.shardingsphere.shardingjdbc.spring.boot.SpringBootConfiguration$$EnhancerBySpringCGLIB$$c4e678d1.dataSource(<generated>)
 ~[sharding-jdbc-spring-boot-starter-4.0.0-RC1.jar:4.0.0-RC1]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
~[na:1.8.0_162]
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
~[na:1.8.0_162]
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 ~[na:1.8.0_162]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
        at 
org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)
 ~[spring-beans-5.1.8.RELEASE.jar:5.1.8.RELEASE]
        ... 48 common frames omitted
   
   Disconnected from the target VM, address: '127.0.0.1:10679', transport: 
'socket'
   
   Process finished with exit code 0
   
   
   
   这是配置
   server.port=9786
   
   spring.application.name=sharding
   
   
   
   spring.shardingsphere.datasource.names=ds0,ds1
   
   
spring.shardingsphere.datasource.ds0.type=org.apache.commons.dbcp.BasicDataSource
   spring.shardingsphere.datasource.ds0.driver-class-name=com.mysql.jdbc.Driver
   
spring.shardingsphere.datasource.ds0.url=jdbc:mysql://localhost:3306/ds0?serverTimezone=GMT
   spring.shardingsphere.datasource.ds0.username=root
   spring.shardingsphere.datasource.ds0.password=123456
   
   
spring.shardingsphere.datasource.ds1.type=org.apache.commons.dbcp.BasicDataSource
   spring.shardingsphere.datasource.ds1.driver-class-name=com.mysql.jdbc.Driver
   
spring.shardingsphere.datasource.ds1.url=jdbc:mysql://localhost:3306/ds1?serverTimezone=GMT
   spring.shardingsphere.datasource.ds1.username=root
   spring.shardingsphere.datasource.ds1.password=123456
   
   
   
spring.shardingsphere.sharding.tables.auth_user.actual-data-nodes=ds$->{0..1}.auth_user_$->{0..1}
   
spring.shardingsphere.sharding.tables.auth_user.table-strategy.inline.sharding-column=order_id
   
spring.shardingsphere.sharding.tables.auth_user.table-strategy.inline.algorithm-expression=auth_user_$->{order_id
 % 2}
   spring.shardingsphere.sharding.tables.auth_user.key-generator.column=id
   
   
   # JPA 相关配置
   spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect
   spring.jpa.show-sql=true
   spring.jpa.hibernate.ddl-auto=create

----------------------------------------------------------------
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]


With regards,
Apache Git Services

Reply via email to