You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/10/10 06:30:35 UTC

[GitHub] [shardingsphere] GissilyWork opened a new issue, #19946: Only support timezone start with prefix GMT ?

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

   version about my project
   spring boot 2.6.10
   shardingsphere 5.1.2
   mysql 8.0
   
   
   DB configuration
   ```
   spring:
     shardingsphere:
       datasource:
         names: ds
         ds:
           type: com.zaxxer.hikari.HikariDataSource
           driver-class-name: com.mysql.cj.jdbc.Driver
           jdbc-url: jdbc:mysql://x.x.x.x:3306/data_demo?serverTimezone=UTC%2B8&characterEncoding=utf-8&useUnicode=yes&autoReconnect=true&useSSL=false
          
   ```
   
   When the timezone in jdbc url is UTC+8, shardingsphere will ignore it, all timestamp persisted in db are UTC time, so I test this jdbc url with other jpa or mybatis project without shardingsphere all timestamp of them are UTC+8, if serverTimezone is GMT+8, timestamp persisted in db are GMT+8. 
   I know most of time GMT and UTC are the same, but it will be annoying when updating some features for old project, cause most of them are using UTC way.


-- 
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 closed issue #19946: Only support timezone start with prefix GMT ?

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.

RaigorJiang closed issue #19946: Only support timezone start with prefix GMT ?
URL: https://github.com/apache/shardingsphere/issues/19946


-- 
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] github-actions[bot] closed issue #19946: Only support timezone start with prefix GMT ?

Posted by GitBox <gi...@apache.org>.

github-actions[bot] closed issue #19946: Only support timezone start with prefix GMT ?
URL: https://github.com/apache/shardingsphere/issues/19946


-- 
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] github-actions[bot] commented on issue #19946: Only support timezone start with prefix GMT ?

Posted by GitBox <gi...@apache.org>.

github-actions[bot] commented on issue #19946:
URL: https://github.com/apache/shardingsphere/issues/19946#issuecomment-1272349043

   Hello , this issue has not received a reply for several days.
   This issue is supposed to be closed.


-- 
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 commented on issue #19946: Only support timezone start with prefix GMT ?

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.

RaigorJiang commented on issue #19946:
URL: https://github.com/apache/shardingsphere/issues/19946#issuecomment-1407418217

   In ShardingSphere-JDBC, the jdbc url parameter is directly used to connect to the physical DB, and there is no such thing as ShardingSphere ignoring it.
   
   Considering this issue has been around for a long time, I'm closing it now. If you still have the same problem, please reopen it or submit a new one


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