fdlzp commented on issue #2362: {dataSource-1} inited takes a long time when
use ORA12c
URL:
https://github.com/apache/incubator-shardingsphere/issues/2362#issuecomment-494284415
Thank you for your time.
My sharding configuration:
spring.shardingsphere.datasource.names=mytest ( I don't know if this is
it? )
spring.shardingsphere.datasource.mytest.type=com.alibaba.druid.pool.DruidDataSource
spring.shardingsphere.datasource.mytest.driver-class-name=oracle.jdbc.OracleDriver
spring.shardingsphere.datasource.mytest.url=jdbc:oracle:thin:@localhost:1521:orcl
spring.shardingsphere.datasource.mytest.username=c##mytest
spring.shardingsphere.datasource.mytest.password=root
#所有数据节点
spring.shardingsphere.sharding.tables.terminal.actual-data-nodes=mytest.terminal_0$->{1..9},mytest.terminal_$->{10..12}
#自定义分片（多表时）
#分片列名称 注意用table-strategy不是database-strategy
spring.shardingsphere.sharding.tables.terminal.table-strategy.standard.sharding-column=date_time
#精确分片算法类名称，用于=和IN。该类需实现PreciseShardingAlgorithm接口并提供无参数的构造器
spring.shardingsphere.sharding.tables.terminal.table-strategy.standard.precise-algorithm-class-name=com.fudabd.oracletest.algorithm.MyPreciseShardingTableAlgorithm
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:
[email protected]
With regards,
Apache Git Services
