go-ora icon indicating copy to clipboard operation
go-ora copied to clipboard

Pool settings

Open bikain opened this issue 10 months ago • 1 comments

Hello. I want to use GO-ORA for connection pools in microservices. I use:

  1. parameters SESSION_TIMEOUT for set timeOut.
  2. sql.DB.SetMaxOpenConns for set maximum pool size.
  3. sql.DB.SetConnMaxLifetime for set maximum life time of connection.

But I didn't find how to install:

  1. Minimum pool open connections
  2. Wait timeOut for new connections from pool.

I found the commented code here: https://github.com/sijms/go-ora/blob/f208e5188f4b6cf28746a802e9d66b82b9d1b6bb/v2/configurations/connect_config.go

Is it possible to make these pool settings? And make settings SetMaxOpenConns, SetConnMaxLifetime in URL parameters?

OracleClient: 19.0.0.0.0 GO: 1.21 GO-ORA: v2.8.23

bikain avatar Feb 11 '25 10:02 bikain

connection pool used is that belongs to sql/database, and no custom connection pooling for the driver yet

sijms avatar Feb 25 '25 16:02 sijms