You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "Pace2Car (via GitHub)" <gi...@apache.org> on 2023/05/25 07:14:23 UTC

[GitHub] [shardingsphere] Pace2Car opened a new issue, #25883: The style of JDBC's global rule should be consistent with Proxy

Pace2Car opened a new issue, #25883:
URL: https://github.com/apache/shardingsphere/issues/25883

   Hi community,
   
   Now the global rule configuration styles of Proxy and JDBC are not unified.
   The configuration of Proxy is like this
   ```yaml
   transaction:
     defaultType: LOCAL
   
   sqlParser:
     sqlCommentParseEnabled: false
     sqlStatementCache:
       initialCapacity: 2000
       maximumSize: 65535
     parseTreeCache:
       initialCapacity: 128
       maximumSize: 1024
   
   authority:
     users:
       - user: root@%
         password: roott
       - user: sharding
         password: sharding
     privilege:
       type: ALL_PERMITTED
   
   logging:
     loggers:
     - loggerName: ShardingSphere-SQL
       additivity: true
       level: INFO
       props:
         enable: false
   
   globalClock:
     enabled: false
     type: TSO
     provider: local
   
   sqlTranslator:
     type: NATIVE
     useOriginalSQLWhenTranslatingFailed: false
   ```
   The configuration of JDBC is like this
   ```yaml
   rules:
   - !AUTHORITY
     privilege:
       type: ALL_PERMITTED
     users:
     - password: root
       user: root@%
     - password: sharding
       user: sharding@%
   - !TRANSACTION
     defaultType: LOCAL
   - !SQL_PARSER
     parseTreeCache:
       initialCapacity: 128
       maximumSize: 1024
     sqlCommentParseEnabled: false
     sqlStatementCache:
       initialCapacity: 2000
       maximumSize: 65535
   - !SQL_TRANSLATOR
     type: NATIVE
     useOriginalSQLWhenTranslatingFailed: false
   - !GLOBAL_CLOCK
     enabled: false
     provider: local
     type: TSO
   - !LOGGING
     loggers:
     - additivity: true
       level: INFO
       loggerName: ShardingSphere-SQL
       props:
         enable: false
   ```
   
   I recommend using the Proxy style uniformly.


-- 
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.apache.org

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


[GitHub] [shardingsphere] RaigorJiang commented on issue #25883: The style of JDBC's global rule should be consistent with Proxy

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #25883:
URL: https://github.com/apache/shardingsphere/issues/25883#issuecomment-1562476326

   @Pace2Car 
   Please update example and documents, thank you!


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


[GitHub] [shardingsphere] RaigorJiang closed issue #25883: The style of JDBC's global rule should be consistent with Proxy

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #25883: The style of JDBC's global rule should be consistent with Proxy
URL: https://github.com/apache/shardingsphere/issues/25883


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