wuguowei19880907 commented on issue #14077: URL: https://github.com/apache/shardingsphere/issues/14077#issuecomment-994447339
> [config-sharding.yaml.zip](https://github.com/apache/shardingsphere/files/7712050/config-sharding.yaml.zip) > > Maybe, you can use it replace your configuration. I test like this,but get error: ``` Cannot create property=rules for JavaBean=org.apache.shardingsphere.infra.yaml.config.pojo.YamlRootConfiguration@63949798 in 'reader', line 1, column 1: schemaName: sharding_db ^ Can't construct a java object for !SHARDING; exception=Invalid tag: !SHARDING in 'reader', line 16, column 3: - !SHARDING ^ in 'reader', line 16, column 1: - !SHARDING ^ at org.yaml.snakeyaml.constructor.Constructor$ConstructMapping.constructJavaBean2ndStep(Constructor.java:312) at org.yaml.snakeyaml.constructor.Constructor$ConstructMapping.construct(Constructor.java:189) at org.yaml.snakeyaml.constructor.Constructor$ConstructYamlObject.construct(Constructor.java:345) at org.yaml.snakeyaml.constructor.BaseConstructor.constructObject(BaseConstructor.java:182) at org.yaml.snakeyaml.constructor.BaseConstructor.constructDocument(BaseConstructor.java:141) at org.yaml.snakeyaml.constructor.BaseConstructor.getSingleData(BaseConstructor.java:127) at org.yaml.snakeyaml.Yaml.loadFromReader(Yaml.java:450) at org.yaml.snakeyaml.Yaml.loadAs(Yaml.java:444) at org.apache.shardingsphere.infra.yaml.engine.YamlEngine.unmarshal(YamlEngine.java:71) at org.apache.shardingsphere.driver.api.yaml.YamlShardingSphereDataSourceFactory.createDataSource(YamlShardingSphereDataSourceFactory.java:73) at org.apache.shardingsphere.benchmark.db.shardingjdbc.ShardingJDBCDataSourceFactory.newInstance(ShardingJDBCDataSourceFactory.java:49) at org.apache.shardingsphere.benchmark.jmeter.common.datapreparation.shardingsphere.sharding.JMeterShardingSphereCommonShardingInsert.<clinit>(JMeterShardingSphereCommonShardingInsert.java:24) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.apache.jmeter.protocol.java.sampler.JavaSampler.createJavaClient(JavaSampler.java:222) at org.apache.jmeter.protocol.java.sampler.JavaSampler.sample(JavaSampler.java:193) at org.apache.jmeter.threads.JMeterThread.doSampling(JMeterThread.java:630) at org.apache.jmeter.threads.JMeterThread.executeSamplePackage(JMeterThread.java:558) at org.apache.jmeter.threads.JMeterThread.processSampler(JMeterThread.java:489) at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:256) at java.lang.Thread.run(Thread.java:748) Caused by: Can't construct a java object for !SHARDING; exception=Invalid tag: !SHARDING in 'reader', line 16, column 3: - !SHARDING ^ at org.yaml.snakeyaml.constructor.Constructor$ConstructYamlObject.construct(Constructor.java:349) at org.yaml.snakeyaml.constructor.BaseConstructor.constructObject(BaseConstructor.java:182) at org.yaml.snakeyaml.constructor.BaseConstructor.constructSequenceStep2(BaseConstructor.java:275) at org.yaml.snakeyaml.constructor.BaseConstructor.constructSequence(BaseConstructor.java:246) at org.yaml.snakeyaml.constructor.Constructor$ConstructSequence.construct(Constructor.java:536) at org.yaml.snakeyaml.constructor.BaseConstructor.constructObject(BaseConstructor.java:182) at org.yaml.snakeyaml.constructor.Constructor$ConstructMapping.constructJavaBean2ndStep(Constructor.java:297) ... 22 more Caused by: org.yaml.snakeyaml.error.YAMLException: Invalid tag: !SHARDING at org.yaml.snakeyaml.nodes.Tag.getClassName(Tag.java:112) at org.yaml.snakeyaml.constructor.Constructor.getClassForNode(Constructor.java:655) at org.yaml.snakeyaml.constructor.Constructor$ConstructYamlObject.getConstructor(Constructor.java:335) at org.yaml.snakeyaml.constructor.Constructor$ConstructYamlObject.construct(Constructor.java:345) ... 28 more ``` The configuration like this: ``` schemaName: sharding_db dataSources: ds_0: dataSourceClassName: com.zaxxer.hikari.HikariDataSource url: jdbc:mysql://127.0.0.1:3306/demo_ds_0?serverTimezone=UTC&useSSL=false username: root password: 123456 connectionTimeoutMilliseconds: 30000 idleTimeoutMilliseconds: 60000 maxLifetimeMilliseconds: 1800000 maxPoolSize: 50 minPoolSize: 1 rules: - !SHARDING tables: sbtest: actualDataNodes: ds_0.sbtest${0..1} databaseStrategy: standard: shardingColumn: id shardingAlgorithmName: database_inline tableStrategy: standard: shardingColumn: k shardingAlgorithmName: table_inline keyGenerateStrategy: column: id keyGeneratorName: increment shardingAlgorithms: database_inline: type: INLINE props: algorithm-expression: ds_0 table_inline: type: INLINE props: algorithm-expression: sbtest${order_id % 2} keyGenerators: increment: type: SNOWFLAKE ``` -- 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]
