[GitHub] [shardingsphere] 15935561673 commented on issue #12128: Hope to attach importance to oracle support

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

15935561673 commented on issue #12128:
URL: https://github.com/apache/shardingsphere/issues/12128#issuecomment-911061291


   > @15935561673你能提供更多信息吗？如：版本、分片配置等。
   
   spring:
     shardingsphere:
       datasource:
         names: user1
         user1:
           #监控统计拦截的filters
           filters: stat
           driver-class-name: oracle.jdbc.OracleDriver
           #配置基本属性
           url: jdbc:oracle:thin:@127.0.0.1:1521:orcl
           username: micloud
           password: micloudindex
           type: com.alibaba.druid.pool.DruidDataSource
           #配置初始化大小/最小/最大
           initial-size: 5
           min-idle: 1
           max-active: 50
           #获取连接等待超时时间
           max-wait: 60000
           #间隔多久进行一次检测，检测需要关闭的空闲连接
           time-between-eviction-runs-millis: 60000
           #一个连接在池中最小生存的时间
           min-evictable-idle-time-millis: 25200000
           validation-query: SELECT 1 FROM DUAL
           test-while-idle: true
           test-on-borrow: false
           test-on-return: false
           #打开PSCache，并指定每个连接上PSCache的大小。oracle设为true，mysql设为false。分库分表较多推荐设置为false
           pool-prepared-statements: false
           max-pool-prepared-statement-per-connection-size: 20
       sharding:
         tables:
           PACS_FILEINDEX:
             actualDataNodes: user1.PACS_FILEINDEX_202101
   #          actualDataNodes: user1.PACS_FILEINDEX_$->{2020..2030}0$->{1..9},user1.PACS_FILEINDEX_$->{2020..2030}$->{10..12}
             tableStrategy:
               standard:
                 shardingColumn: createDate
                 preciseAlgorithmClassName: com.example.demo.config.MemberIdShardingTableAlgorithm
                 rangeAlgorithmClassName: com.example.demo.config.MemberIdShardingTableAlgorithm


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org