How to reset the connection status getting from go database/sql pool?

Question

If I exec a db.exec("set time_zone = "+00:00""), the status time_zone of connection to exec the SQL will change and will the connection be put back to the pool?

If so, will it be reused by another processor who doesn't know the status of connection has been changed?

amantur · Accepted Answer · 2016-11-10 23:12:02Z

1

The correct way is to set a timezone in the connection string:

sql.Open("mysql", "root@tcp(127.0.0.1:3306)/dbname?charset=utf8&parseTime=true&time_zone=%2B00%3A00")

Note that time_zone value must be urlencoded. Also you can set other system variables in conn string.

edited Nov 10, 2016 at 23:12

amantur

40.6k22 gold badges136 silver badges192 bronze badges

answered Nov 9, 2016 at 5:19

Alex Pliutau

22k28 gold badges115 silver badges144 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to reset the connection status getting from go database/sql pool?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related