search

nakagami / firebirdsql

Firebird RDBMS sql driver for Go (golang)
MIT License
224 stars 60 forks source link

Support for changing lock resolution params (WAIT | NO_WAIT) #126

Closed strobil closed 3 years ago

strobil commented 3 years ago

Hi there! It will be cool if the firebirdsql driver will have support for changing these params. Apparently the standard sql.TxOptions does not provide required fields to pass this option to firebirdsql driver.

Any ideas how to solve this?

nakagami commented 3 years ago

Look at the IsolationLevel value https://golang.org/pkg/database/sql/#IsolationLevel

We don't support everything, but we've set the transaction level as high as we can. https://github.com/nakagami/firebirdsql/blob/master/driver_go18.go#L62