dongyuan9149 2016-11-10 12:36
浏览 198

在Go中为SQL连接设置TCP超时

When I connect to database (using standard go sql library) using VPN and VPN interface goes down, there's a 75 seconds timeout when I try to do SQL query, no matter if the interface goes up meanwhile. I'd like to decrease this timeout to some reasonable time, so my application won't be frozen for 75 seconds in such case.

db, err := sql.Open(driverName, dataSourceName)

Is it possible to set it somehow via db variable?

  • 写回答

3条回答 默认 最新

  • duanmei1922 2017-07-08 19:37
    关注

    Starting with Go 1.8, the sql.DB abstraction now accepts context.Context, which can be used to time out connections faster.

    func (c *Client) DoLookup(ctx context.Context, id int) (string, error) {
      var name string
      // create a child context with a timeout
      newCtx, cancel := context.WithTimeout(ctx, time.Second)
      // release resources used in `newCtx` if
      // the DB operation finishes faster than the timeout
      defer cancel()
    
      row := c.db.QueryRowContext(newCtx, "SELECT name FROM items WHERE id = ?", id)
    
      err := row.Scan(&name)
      if err != nil {
        return "", err
      }
    
      return name, nil
    }
    

    If your DoLookup function doesn't yet take a context.Context (and it really should!) you can create a parent one by calling context.TODO().

    评论

报告相同问题?

悬赏问题

  • ¥15 C++使用Gunplot
  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)