Oracle driver for Go using database/sql

mattn

Last update: Dec 30, 2022

Related tags

Database Drivers go-oci8

Overview

go-oci8

Description

Golang Oracle database driver conforming to the Go database/sql interface

Installation

Install Oracle full client or Instant Client:

https://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html

Install a C/C++ compiler

Install pkg-config, edit your package config file oci8.pc (examples below), then set environment variable PKG_CONFIG_PATH to oci8.pc file location (Or can use Go tag noPkgConfig then setup environment variables CGO_CFLAGS and CGO_LDFLAGS)

Go get with Go version 1.9 or higher

go get github.com/mattn/go-oci8

Try the simple select example:

https://godoc.org/github.com/mattn/go-oci8#example-package--SqlSelect

If you have a build error it is normaly because of a misconfiguration, make sure to search close issues for help

oci8.pc Examples

Windows

prefix=/devel/target/XXXXXXXXXXXXXXXXXXXXXXXXXX
exec_prefix=${prefix}
libdir=C:/app/instantclient_12_2/sdk/oci/lib/msvc
includedir=C:/app/instantclient_12_2/sdk/include

glib_genmarshal=glib-genmarshal
gobject_query=gobject-query
glib_mkenums=glib-mkenums

Name: oci8
Description: oci8 library
Libs: -L${libdir} -loci
Cflags: -I${includedir}
Version: 12.2

Linux

prefix=/devel/target/XXXXXXXXXXXXXXXXXXXXXXXXXX
exec_prefix=${prefix}
libdir=/usr/lib/oracle/12.2/client64/lib
includedir=/usr/include/oracle/12.2/client64

glib_genmarshal=glib-genmarshal
gobject_query=gobject-query
glib_mkenums=glib-mkenums

Name: oci8
Description: oci8 library
Libs: -L${libdir} -lclntsh
Cflags: -I${includedir}
Version: 12.2

MacOs

Please install pkg-config with brew if not already present. Download the instant client and the sdk and unpack it e.g. in your Downloads folder and create therein a file names oci8.pc. Please replace <username> with your actual username.

prefixdir=/Users/<username>/Downloads/instantclient_12_2/
libdir=${prefixdir}
includedir=${prefixdir}/sdk/include

Name: OCI
Description: Oracle database driver
Version: 12.2
Libs: -L${libdir} -lclntsh
Cflags: -I${includedir}

You also have to set these environment variables (e.g. permanently by adding them to your .bashrc)

export LD_LIBRARY_PATH=/Users/<username>/Downloads/instantclient_12_2
export PKG_CONFIG_PATH=/Users/<username>/Downloads/instantclient_12_2

SQL Examples

SQL examples can be found in the GoDoc reference:

https://godoc.org/github.com/mattn/go-oci8

And in _example:

https://github.com/mattn/go-oci8/tree/master/_example

Author

Yasuhiro Matsumoto (a.k.a mattn)

Special Thanks

Jamil Djadala

Comments

Cursor leak in QueryContext when context is cancelled

Running the following will eventually crash with ORA-01000: maximum open cursors exceeded

package main

import (
	"context"
	"database/sql"
	"flag"
	_ "github.com/mattn/go-oci8"
	"log"
	"strings"
	"sync"
	"time"
)

func main() {
	dsn := flag.String("dsn", "", "Oracle DSN")
	flag.Parse()

	db, err := sql.Open("oci8", *dsn)
	if err != nil {
		panic(err)
	}
	defer db.Close()

	db.SetMaxOpenConns(4)
	db.SetMaxIdleConns(4)
	db.SetConnMaxLifetime(30 * time.Minute)

	log.Print("Trying to crash")

	for i := 0; i < 10; i++ {
		go crasher(db)
	}

	log.Print("Waiting...")

	time.Sleep(60 * time.Second)

	log.Print("No crash?")
}

func crasher(db *sql.DB) {
	for {
		var wg sync.WaitGroup
		ctx, cancel := context.WithCancel(context.Background())
		wg.Add(1)
		go func() {
			defer wg.Done()
			rows, err := db.QueryContext(ctx,
				`select * from sys.audit_actions`,
			)
			if err != nil {
				if err == context.Canceled || strings.Contains(err.Error(), "ORA-01013") { // ORA-01013: user requested cancel of current operation
				if rows != nil {
					log.Print("Non-nil rows returned during error? closing rows")
					err  =rows.Close()
					if err != nil {
						panic(err)
					}
				}
					return
				}
				panic(err)
			}
			err = rows.Close()
			if err != nil {
				panic(err)
			}
		}()

		// Seems to crash faster if we wait a little bit
		time.Sleep(1 * time.Millisecond)

		cancel()
		wg.Wait()
	}
}

I was attempting to reproduce a nasty crash (malloc(): memory corruption (fast)) which seemed to be related to cancelling the context of a running query with go-oci8 when I ran into this issue. I'm not sure if this is also the cause of my memory corruption crash or not, but it's making it difficult to reproduce with this issue. Removing the cancel() call makes the issue stop occurring.

outside bug

opened by nvx 74

How do I compile this on windows

I read this document and other documents but can't find exact solution for using oracle with golang.

When i build my go file it stops due to:

pkg-config --cflags oci8

pkg-config: exec: "pkg-config": executable file not found in %PATH%

I have some gaps in my mind about this document can anybody help me? 1- Should i install pkg-config for windows? 2- Should i set environment variables for oci8.pc 3- Is my oci8.pc file true? <-- oci8.pc file --> prefix=C:/instantclient libdir=${prefix} includedir=${prefix}/sdk/include/

Name: OCI Description: Oracle database engine Version: 11.2 Libs: -L${libdir} -lclntsh Libs.private: Cflags: -I${includedir}

fmt.Println("THANK YOU")

opened by ugurozgen 50
Periodic hangs on Next()

I get a very reproduceable hangs when running GetColumns from xorm using go-oci8. It hangs on a column of type NUMBER, although it processed another column of type NUMBER in the same table. Also, out of 50 tables, it hangs on 3. I cant see a pattern here.

I got a stacktrace and it looks hung in OCIStmtFetch2. Any ideas?

Here is the stack trace:

goroutine 10 [syscall, 2 minutes]: runtime.notetsleepg(0x31b84d8, 0x6fbc0c3fa, 0x0) /usr/local/go/src/runtime/lock_futex.go:205 +0x42 fp=0xc42002af60 sp=0xc42002af30 runtime.timerproc() /usr/local/go/src/runtime/time.go:209 +0x327 fp=0xc42002afe0 sp=0xc42002af60 runtime.goexit() /usr/local/go/src/runtime/asm_amd64.s:2197 +0x1 fp=0xc42002afe8 sp=0xc42002afe0 created by runtime.addtimerLocked /usr/local/go/src/runtime/time.go:116 +0xed

goroutine 1 [syscall, 10 minutes, locked to thread]: github.com/mattn/go-oci8._Cfunc_OCIStmtFetch2(0x7f96bc09d470, 0x7f96bc089eb0, 0x200000001, 0x0, 0x0) github.com/mattn/go-oci8/_obj/_cgo_gotypes.go:576 +0x4d github.com/mattn/go-oci8.(*OCI8Rows).Next.func1(0x7f96bc09d470, 0x7f96bc089eb0, 0x200000001, 0x0, 0x0) /ddn/work/ddn/src/github.com/mattn/go-oci8/oci8.go:1537 +0xc5 github.com/mattn/go-oci8.(*OCI8Rows).Next(0xc420383630, 0xc420054f50, 0x7, 0x7, 0x42adae, 0xc400000008) /ddn/work/ddn/src/github.com/mattn/go-oci8/oci8.go:1543 +0x7a database/sql.(*Rows).nextLocked(0xc4206c4800, 0xc42089b938) /usr/local/go/src/database/sql/sql.go:2149 +0x6c database/sql.(*Rows).Next.func1() /usr/local/go/src/database/sql/sql.go:2134 +0x3c database/sql.withLock(0x312b200, 0xc4206c4830, 0xc42089b978) /usr/local/go/src/database/sql/sql.go:2545 +0x65 database/sql.(*Rows).Next(0xc4206c4800, 0x15) /usr/local/go/src/database/sql/sql.go:2135 +0x83 github.com/go-xorm/xorm.(*oracle).GetColumns(0xc420383a90, 0xc42067d9f0, 0xc, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0) /ddn/work/ddn/src/github.com/go-xorm/xorm/dialect_oracle.go:705 +0x2a3 github.com/go-xorm/xorm.(*Engine).DBMetas(0xc4203f2fa0, 0x22, 0x0, 0x0, 0x0, 0xc) /ddn/work/ddn/src/github.com/go-xorm/xorm/engine.go:357 +0x301

opened by rajeevb2 38
Improve fetch performance by fetching more rows at a time
I have been comparing go-oci8 to other drivers written in Go and other languages. I have executed a simple test where I query and fetch all the records (rows.Next()) from a single table with 32 columns, 2 million rows and an average row size of 58 bytes. The application and database are on the same Windows machine. Here are the results, from fastest to slowest:

PL/SQL - 4.8 seconds .Net (System.Data.OracleClient) - 6 seconds go-oci8 - 18 seconds goracle - 33 seconds Delphi (DOA) - 58 seconds

go-oci8 has good performance compared to goracle and Delphi, however it is around 3x slower than .Net.

I started investigating and the most obvious difference is that in go-oci8 when OCIStmtFetch is called the nrows parameter is always 1:

func (rc *OCI8Rows) Next(dest []driver.Value) error { rv := C.OCIStmtFetch( (*C.OCIStmt)(rc.s.s), (*C.OCIError)(rc.s.c.err), 1, // nrows C.OCI_FETCH_NEXT, C.OCI_DEFAULT)

.Net, however, has a variable amount of rows:

rc = TracedNativeMethods.OCIStmtFetch( _statementHandle, // stmtp ErrorHandle, // errhp _rowsToPrefetch, // crows OCI.FETCH.OCI_FETCH_NEXT, // orientation OCI.MODE.OCI_DEFAULT // mode );

From what I've seen from the code, .Net fetches around 64 kb of data each time, which in my case would mean around 1100 rows.

I'm trying to make go-oci8 fetch more rows, however when I do that errors start appearing everywhere, especially on the calls to close the cursors.

Before I dig any deeper I was wondering if you have already tried anything similar, and maybe have some idea on what would be the parts that need to be modified in order to do that.
opened by ricsmania 38
go 1.8 with go-oci8 crashed !

fatal error: unexpected signal during runtime execution [signal SIGSEGV: segmentation violation code=0x1 addr=0x196aca8 pc=0x7f58d1bd35c3]

runtime stack: runtime.throw(0xbc6be4, 0x2a) /home/lhs/soft/go/go1.8.0/go/src/runtime/panic.go:596 +0x95 runtime.sigpanic() /home/lhs/soft/go/go1.8.0/go/src/runtime/signal_unix.go:274 +0x2db

goroutine 4 [syscall, locked to thread]: runtime.cgocall(0xa50d60, 0xc42002d6c8, 0xbc5a59) /home/lhs/soft/go/go1.8.0/go/src/runtime/cgocall.go:131 +0xe2 fp=0xc42002d688 sp=0xc42002d648 github.com/mattn/go-oci8._Cfunc_OCIHandleFree(0x196aca8, 0x4, 0x0) github.com/mattn/go-oci8/_obj/_cgo_gotypes.go:479 +0x4d fp=0xc42002d6c8 sp=0xc42002d688 github.com/mattn/go-oci8.(*OCI8Stmt).Close.func1(0x196aca8, 0xc400000004, 0x43155e) /home/lhs/soft/go/go1.8.0/gopath/src/github.com/mattn/go-oci8/oci8.go:755 +0x68 fp=0xc42002d700 sp=0xc42002d6c8 github.com/mattn/go-oci8.(*OCI8Stmt).Close(0xc4202a1f20, 0x0, 0x0) /home/lhs/soft/go/go1.8.0/gopath/src/github.com/mattn/go-oci8/oci8.go:759 +0x47 fp=0xc42002d728 sp=0xc42002d700 runtime.call32(0x0, 0xbd9aa8, 0xc420216000, 0x2000000020) /home/lhs/soft/go/go1.8.0/go/src/runtime/asm_amd64.s:514 +0x48 fp=0xc42002d758 sp=0xc42002d728 runtime.runfinq() /home/lhs/soft/go/go1.8.0/go/src/runtime/mfinal.go:208 +0x205 fp=0xc42002d7e0 sp=0xc42002d758 runtime.goexit() /home/lhs/soft/go/go1.8.0/go/src/runtime/asm_amd64.s:2197 +0x1 fp=0xc42002d7e8 sp=0xc42002d7e0 created by runtime.createfing /home/lhs/soft/go/go1.8.0/go/src/runtime/mfinal.go:142 +0x62

opened by toplinuxsir 33

Why I can not close database connection?

`package main

import ( "context" "database/sql" "fmt" "log" "net/http" "os" "os/signal" "syscall" "time"

_ "github.com/mattn/go-oci8"

)

func main() {

db, err := sql.Open("oci8", fmt.Sprintf(
	"%v/%v@%v:%v/%v",
	"user",
	"pass",
	"0.0.0.0",
	"000",
	"serve-id"))
if err != nil {
	log.Fatal(err)
}

router := http.NewServeMux()

router.HandleFunc("/poc-close-connect-db", func(res http.ResponseWriter, req *http.Request) {
	if err := db.PingContext(req.Context()); err != nil {
		res.WriteHeader(503)
	}

	rows, err := db.Query("select sysdate from dual")
	if err != nil {
		fmt.Println("Error running query")
		fmt.Println(err)
		return
	}
	defer rows.Close()

	var thedate string
	for rows.Next() {

		rows.Scan(&thedate)
	}
	fmt.Printf("The date is: %s\n", thedate)
})

srv := &http.Server{
	Handler: router,
	Addr:    fmt.Sprintf(":%s", "8080"),
}

go func() {
	log.Fatal(srv.ListenAndServe())
}()

stop := make(chan os.Signal, 1)
signal.Notify(stop, os.Interrupt)
signal.Notify(stop, syscall.SIGTERM)

<-stop
ctx, cancel := context.WithTimeout(context.Background(), 10*time.Second)
defer cancel()

if err := srv.Shutdown(ctx); err != nil {
	log.Printf("error shutting down server %s", err)
} else {
	log.Println("Server gracefully stopped")
}

stats := db.Stats()
log.Printf("error closing db connection %s", stats)

if err := db.Close(); err != nil {
	log.Printf("error closing db connection %s", err)
} else {
	log.Println("Db connection gracefully closed")
}

I tried close database but I can not close database connection. Why I can not gracefully close database connection?

question

opened by LennonRuangjaroon 29

go-oci8 /usr/bin/ld: cannot find -lclntsh

go get github.com/mattn/go-oci8 returns go-oci8 /usr/bin/ld: cannot find -lclntsh collect2: error: ld returned 1 exit status and my oci8.pc is `prefix=/devel/target/XXXXXXXXXXXXXXXXXXXXXXXXXX exec_prefix=${prefix} libdir=/usr/lib/oracle/12.2/client64/lib includedir=/usr/include/oracle/12.2/client64

glib_genmarshal=glib-genmarshal gobject_query=gobject-query glib_mkenums=glib-mkenums

Name: oci8 Description: oci8 library Libs: -L${libdir} -lclntsh Cflags: -I${includedir} Version: 12.2` and go version is go version go1.6.2 linux/amd64

opened by vk1818 29
Error during install in windows

I am facing below error in windows 7 64bit with TDM-GCC-64 (64bit) and GO 1.5.2 64bit and Oracle server 64 bit.

Error: cc1: sorry, unimplemented: 64-bit mode not compiled in

oci8.pc as below

prefix=/devel/target/1.0 exec_prefix=${prefix}

libdir=C:/app/IBM_ADMIN/product/11.2.0/dbhome_1/OCI/lib/MSVC includedir=C:/app/IBM_ADMIN/product/11.2.0/dbhome_1/OCI/include

gcclib=C:/MyFiles/ProgramFiles/TDM-GCC-64/lib gccinclude=C:/MyFiles/ProgramFiles/TDM-GCC-64/include

glib_genmarshal=glib-genmarshal gobject_query=gobject-query glib_mkenums=glib-mkenums

Name: oci8 Version: 11.2 Description: oci8 library Libs: -L${libdir} -L${gcclib} -loci Libs.private: Cflags: -I${includedir} -I${gccinclude}

Not able to figure out where are things going wrong. Please help

opened by JunedS 28
Oracle Errors
I'm trying to get the actual Oracle error (code/text) back from a failed connection, but that doesn't seem to be happening. Can this be done? Here is my sample code:

db, err := sql.Open("oci8", connectStr) if err != nil { return nil, err } err = db.Ping() if err != nil { db.Close() return nil, err }

In the case of a bad user/password, db.Ping() throws an error of "ping failed", but the actual reason is unknown unless I connect to the database with another client. Is this something that I'm doing incorrectly?
done
opened by kog4096 26

error in runtime on windows x64

Hi, I have installed oracle instant client 12.2 64bit in c:\oracle\instantclient_2_2 installed mingw etc. go-oci8 installed/compiled fine. no erros.

Also go build main.go went fine. no errors. but now when running go run main.go I get the following error:

go run main.go
Exception 0xc0000005 0x0 0xb971a6 0x5adc70
PC=0x5adc70
signal arrived during external code execution

github.com/mattn/go-oci8._Cfunc_WrapOCIEnvCreate(0x1, 0x0, 0x0, 0x0, 0x0)
        github.com/mattn/go-oci8/_obj/_cgo_gotypes.go:797 +0x67
github.com/mattn/go-oci8.(*OCI8Driver).Open(0x5e31d8, 0x5388e1, 0x53, 0x0, 0x0, 0x0, 0x0)
        p:/projects/src/github.com/mattn/go-oci8/oci8.go:664 +0xf8
database/sql.(*DB).conn(0xc04203e1e0, 0x5b2140, 0xc04203a1d0, 0x1, 0xa0, 0x5285a0, 0x0)
        C:/Go/src/database/sql/sql.go:965 +0x14d
database/sql.(*DB).query(0xc04203e1e0, 0x5b2140, 0xc04203a1d0, 0x53365c, 0x16, 0x0, 0x0, 0x0, 0x4b4d01, 0xc042031e70, ...)
        C:/Go/src/database/sql/sql.go:1245 +0x62
database/sql.(*DB).QueryContext(0xc04203e1e0, 0x5b2140, 0xc04203a1d0, 0x53365c, 0x16, 0x0, 0x0, 0x0, 0x429b56, 0x538f20, ...)
        C:/Go/src/database/sql/sql.go:1227 +0xbf
database/sql.(*DB).Query(0xc04203e1e0, 0x53365c, 0x16, 0x0, 0x0, 0x0, 0x0, 0xc042031ee0, 0xc042076088)
        C:/Go/src/database/sql/sql.go:1241 +0x89
main.main()
        P:/projects/src/test/oradbtest/main.go:17 +0xc4

goroutine 17 [syscall, locked to thread]:
runtime.goexit()
        C:/Go/src/runtime/asm_amd64.s:2197 +0x1

goroutine 19 [chan receive]:
database/sql.(*DB).connectionOpener(0xc04203e1e0)
        C:/Go/src/database/sql/sql.go:837 +0x51
created by database/sql.Open
        C:/Go/src/database/sql/sql.go:582 +0x219
rax     0x0
rbx     0xc042031a58
rcx     0x7ffd08
rdi     0x7ffd10
rsi     0x0
rbp     0xc042032000
rsp     0x7ffca8
r8      0x0
r9      0x0
r10     0x11e532b
r11     0x7ffc30
r12     0x1
r13     0x0
r14     0x0
r15     0xf2
rip     0x5adc70
rflags  0x10246
cs      0x33
fs      0x53
gs      0x2b
exit status 2

opened by edwardborst 26

prefetch_rows does not work with clobs?

Looks like when query having a clob in the resultset. Then go-oci8 go back to do fetch for each query.

Gist with some test code

Output

2019/01/20 10:54:59 Query with clob took 2.097061085s 2019/01/20 10:54:59 Query with clob SQLID: 1836z1tr3b785, fetches:1001 , rowsProcessed: 1000

done

opened by dbgeek 24
exit status 0xc0000135, golang with windows
I have one issue, when start golang with windows:

i download cliet: https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html

where pkg-config: C:\ProgramData\chocolatey\bin\pkg-config.exe

path of file oci8.pc C:\ProgramData\chocolatey\bin\oci8.pc

oci8.oc: prefix=D:/app/instantclient-sdk-windows-12.2/instantclient_12_2 exec_prefix=${prefix} libdir=D:/app/instantclient-sdk-windows-12.2/instantclient_12_2/sdk/lib/msvc includedir=D:/app/instantclient-sdk-windows-12.2/instantclient_12_2/sdk/include glib_genmarshal=glib-genmarshal gobject_query=gobject-query glib_mkenums=glib-mkenums Name: oci8 Description: oci8 library Libs: -L${libdir} -loci Cflags: -I${includedir} Version: 12.12

pkg-config --cflags --libs -- oci8: -ID:/app/instantclient-sdk-windows-12.2/instantclient_12_2/sdk/include -LD:/app/instantclient-sdk-windows-12.2/instantclient_12_2/sdk/lib/msvc -loci

go version: go version go1.18.6 windows/amd64

my-code: package main

import ( "database/sql" "fmt"

_ "github.com/mattn/go-oci8"

)

func main() { fmt.Println("func main") connectionString := "oracle://" + "user" + ":" + "pass" + "@" + "0.0.0.0" + ":" + "1521" + "/" + "database" db, err := sql.Open("oci8", connectionString) if err != nil { panic(err) } err = db.Ping() if err != nil { panic(err) } fmt.Println("oracle connect successfully") }

after run in cmd: go run main.go, I see error: exit status 0xc0000135,
opened by ducnpdev 2

Library not loaded: @rpath/libclntshcore.dylib.19.1

My mac os got updated to Monterey and when i try to run my project i am facing following errors. pkg-config is installed. All the exports in bashrc are still there. even the file it saying missing are actually present in there respective folder.

dyld[75143]: Library not loaded: @rpath/libclntshcore.dylib.19.1
  Referenced from: /usr/local/lib/libclntsh.dylib.19.1
  Reason: tried: '/usr/local/lib/libclntshcore.dylib.19.1' (no such file), '/usr/local/lib/libclntshcore.dylib.19.1' (no such file), '/usr/lib/libclntshcore.dylib.19.1' (no such file)

files in my /usr/local/lib are following:

 ls -ltrh
total 210536
-rwxr-xr-x@  1 awannaj  staff   8.0M Aug 31  2020 libnnz19.dylib
-rwxr-xr-x@  1 awannaj  staff    95M Sep  9  2020 libclntsh.dylib.19.1
lrwxr-xr-x   1 awannaj  staff    50B Apr  7 14:47 libevent-2.1.7.dylib -> ../Cellar/libevent/2.1.12/lib/libevent-2.1.7.dylib
lrwxr-xr-x   1 awannaj  staff    40B Apr  7 14:47 libevent.a -> ../Cellar/libevent/2.1.12/lib/libevent.a
lrwxr-xr-x   1 awannaj  staff    44B Apr  7 14:47 libevent.dylib -> ../Cellar/libevent/2.1.12/lib/libevent.dylib
lrwxr-xr-x   1 awannaj  staff    55B Apr  7 14:47 libevent_core-2.1.7.dylib -> ../Cellar/libevent/2.1.12/lib/libevent_core-2.1.7.dylib
lrwxr-xr-x   1 awannaj  staff    45B Apr  7 14:47 libevent_core.a -> ../Cellar/libevent/2.1.12/lib/libevent_core.a
lrwxr-xr-x   1 awannaj  staff    49B Apr  7 14:47 libevent_core.dylib -> ../Cellar/libevent/2.1.12/lib/libevent_core.dylib
lrwxr-xr-x   1 awannaj  staff    56B Apr  7 14:47 libevent_extra-2.1.7.dylib -> ../Cellar/libevent/2.1.12/lib/libevent_extra-2.1.7.dylib
lrwxr-xr-x   1 awannaj  staff    46B Apr  7 14:47 libevent_extra.a -> ../Cellar/libevent/2.1.12/lib/libevent_extra.a
lrwxr-xr-x   1 awannaj  staff    50B Apr  7 14:47 libevent_extra.dylib -> ../Cellar/libevent/2.1.12/lib/libevent_extra.dylib
lrwxr-xr-x   1 awannaj  staff    58B Apr  7 14:47 libevent_openssl-2.1.7.dylib -> ../Cellar/libevent/2.1.12/lib/libevent_openssl-2.1.7.dylib
lrwxr-xr-x   1 awannaj  staff    48B Apr  7 14:47 libevent_openssl.a -> ../Cellar/libevent/2.1.12/lib/libevent_openssl.a
lrwxr-xr-x   1 awannaj  staff    52B Apr  7 14:47 libevent_openssl.dylib -> ../Cellar/libevent/2.1.12/lib/libevent_openssl.dylib
lrwxr-xr-x   1 awannaj  staff    59B Apr  7 14:47 libevent_pthreads-2.1.7.dylib -> ../Cellar/libevent/2.1.12/lib/libevent_pthreads-2.1.7.dylib
lrwxr-xr-x   1 awannaj  staff    49B Apr  7 14:47 libevent_pthreads.a -> ../Cellar/libevent/2.1.12/lib/libevent_pthreads.a
lrwxr-xr-x   1 awannaj  staff    53B Apr  7 14:47 libevent_pthreads.dylib -> ../Cellar/libevent/2.1.12/lib/libevent_pthreads.dylib
lrwxr-xr-x   1 awannaj  staff    48B Apr  7 14:47 libutf8proc.2.dylib -> ../Cellar/utf8proc/2.7.0/lib/libutf8proc.2.dylib
lrwxr-xr-x   1 awannaj  staff    42B Apr  7 14:47 libutf8proc.a -> ../Cellar/utf8proc/2.7.0/lib/libutf8proc.a
lrwxr-xr-x   1 awannaj  staff    46B Apr  7 14:47 libutf8proc.dylib -> ../Cellar/utf8proc/2.7.0/lib/libutf8proc.dylib
lrwxr-xr-x   1 awannaj  staff    34B Apr  7 14:47 gettext -> ../Cellar/gettext/0.21/lib/gettext
lrwxr-xr-x   1 awannaj  staff    46B Apr  7 14:47 libasprintf.0.dylib -> ../Cellar/gettext/0.21/lib/libasprintf.0.dylib
lrwxr-xr-x   1 awannaj  staff    40B Apr  7 14:47 libasprintf.a -> ../Cellar/gettext/0.21/lib/libasprintf.a
lrwxr-xr-x   1 awannaj  staff    44B Apr  7 14:47 libasprintf.dylib -> ../Cellar/gettext/0.21/lib/libasprintf.dylib
lrwxr-xr-x   1 awannaj  staff    51B Apr  7 14:47 libgettextlib-0.21.dylib -> ../Cellar/gettext/0.21/lib/libgettextlib-0.21.dylib
lrwxr-xr-x   1 awannaj  staff    46B Apr  7 14:47 libgettextlib.dylib -> ../Cellar/gettext/0.21/lib/libgettextlib.dylib
lrwxr-xr-x   1 awannaj  staff    47B Apr  7 14:47 libgettextpo.0.dylib -> ../Cellar/gettext/0.21/lib/libgettextpo.0.dylib
lrwxr-xr-x   1 awannaj  staff    41B Apr  7 14:47 libgettextpo.a -> ../Cellar/gettext/0.21/lib/libgettextpo.a
lrwxr-xr-x   1 awannaj  staff    45B Apr  7 14:47 libgettextpo.dylib -> ../Cellar/gettext/0.21/lib/libgettextpo.dylib
lrwxr-xr-x   1 awannaj  staff    51B Apr  7 14:47 libgettextsrc-0.21.dylib -> ../Cellar/gettext/0.21/lib/libgettextsrc-0.21.dylib
lrwxr-xr-x   1 awannaj  staff    46B Apr  7 14:47 libgettextsrc.dylib -> ../Cellar/gettext/0.21/lib/libgettextsrc.dylib
lrwxr-xr-x   1 awannaj  staff    42B Apr  7 14:47 libintl.8.dylib -> ../Cellar/gettext/0.21/lib/libintl.8.dylib
lrwxr-xr-x   1 awannaj  staff    36B Apr  7 14:47 libintl.a -> ../Cellar/gettext/0.21/lib/libintl.a
lrwxr-xr-x   1 awannaj  staff    40B Apr  7 14:47 libintl.dylib -> ../Cellar/gettext/0.21/lib/libintl.dylib
lrwxr-xr-x   1 awannaj  staff    47B Apr  7 14:47 libtextstyle.0.dylib -> ../Cellar/gettext/0.21/lib/libtextstyle.0.dylib
lrwxr-xr-x   1 awannaj  staff    41B Apr  7 14:47 libtextstyle.a -> ../Cellar/gettext/0.21/lib/libtextstyle.a
lrwxr-xr-x   1 awannaj  staff    45B Apr  7 14:47 libtextstyle.dylib -> ../Cellar/gettext/0.21/lib/libtextstyle.dylib
lrwxr-xr-x   1 awannaj  staff    50B Apr  7 14:47 libunibilium.4.dylib -> ../Cellar/unibilium/2.1.1/lib/libunibilium.4.dylib
lrwxr-xr-x   1 awannaj  staff    44B Apr  7 14:47 libunibilium.a -> ../Cellar/unibilium/2.1.1/lib/libunibilium.a
lrwxr-xr-x   1 awannaj  staff    48B Apr  7 14:47 libunibilium.dylib -> ../Cellar/unibilium/2.1.1/lib/libunibilium.dylib
lrwxr-xr-x   1 awannaj  staff    48B Apr  7 14:47 libtermkey.1.dylib -> ../Cellar/libtermkey/0.22/lib/libtermkey.1.dylib
lrwxr-xr-x   1 awannaj  staff    42B Apr  7 14:47 libtermkey.a -> ../Cellar/libtermkey/0.22/lib/libtermkey.a
lrwxr-xr-x   1 awannaj  staff    46B Apr  7 14:47 libtermkey.dylib -> ../Cellar/libtermkey/0.22/lib/libtermkey.dylib
lrwxr-xr-x   1 awannaj  staff    46B Apr  7 14:47 libluv.1.43.0.dylib -> ../Cellar/luv/1.43.0-0/lib/libluv.1.43.0.dylib
lrwxr-xr-x   1 awannaj  staff    41B Apr  7 14:47 libluv.1.dylib -> ../Cellar/luv/1.43.0-0/lib/libluv.1.dylib
lrwxr-xr-x   1 awannaj  staff    39B Apr  7 14:47 libluv.dylib -> ../Cellar/luv/1.43.0-0/lib/libluv.dylib
lrwxr-xr-x   1 awannaj  staff    37B Apr  7 14:47 libluv_a.a -> ../Cellar/luv/1.43.0-0/lib/libluv_a.a
drwxr-xr-x   3 awannaj  staff    96B Apr  7 14:47 lua
lrwxr-xr-x   1 awannaj  staff    51B Apr  7 14:47 libmsgpackc.2.0.0.dylib -> ../Cellar/msgpack/4.0.0/lib/libmsgpackc.2.0.0.dylib
lrwxr-xr-x   1 awannaj  staff    47B Apr  7 14:47 libmsgpackc.2.dylib -> ../Cellar/msgpack/4.0.0/lib/libmsgpackc.2.dylib
lrwxr-xr-x   1 awannaj  staff    41B Apr  7 14:47 libmsgpackc.a -> ../Cellar/msgpack/4.0.0/lib/libmsgpackc.a
lrwxr-xr-x   1 awannaj  staff    45B Apr  7 14:47 libmsgpackc.dylib -> ../Cellar/msgpack/4.0.0/lib/libmsgpackc.dylib
lrwxr-xr-x   1 awannaj  staff    51B Apr  7 15:27 libbrotlicommon-static.a -> ../Cellar/brotli/1.0.9/lib/libbrotlicommon-static.a
lrwxr-xr-x   1 awannaj  staff    54B Apr  7 15:27 libbrotlicommon.1.0.9.dylib -> ../Cellar/brotli/1.0.9/lib/libbrotlicommon.1.0.9.dylib
lrwxr-xr-x   1 awannaj  staff    50B Apr  7 15:27 libbrotlicommon.1.dylib -> ../Cellar/brotli/1.0.9/lib/libbrotlicommon.1.dylib
lrwxr-xr-x   1 awannaj  staff    48B Apr  7 15:27 libbrotlicommon.dylib -> ../Cellar/brotli/1.0.9/lib/libbrotlicommon.dylib
lrwxr-xr-x   1 awannaj  staff    48B Apr  7 15:27 libbrotlidec-static.a -> ../Cellar/brotli/1.0.9/lib/libbrotlidec-static.a
lrwxr-xr-x   1 awannaj  staff    51B Apr  7 15:27 libbrotlidec.1.0.9.dylib -> ../Cellar/brotli/1.0.9/lib/libbrotlidec.1.0.9.dylib
lrwxr-xr-x   1 awannaj  staff    47B Apr  7 15:27 libbrotlidec.1.dylib -> ../Cellar/brotli/1.0.9/lib/libbrotlidec.1.dylib
lrwxr-xr-x   1 awannaj  staff    45B Apr  7 15:27 libbrotlidec.dylib -> ../Cellar/brotli/1.0.9/lib/libbrotlidec.dylib
lrwxr-xr-x   1 awannaj  staff    48B Apr  7 15:27 libbrotlienc-static.a -> ../Cellar/brotli/1.0.9/lib/libbrotlienc-static.a
lrwxr-xr-x   1 awannaj  staff    51B Apr  7 15:27 libbrotlienc.1.0.9.dylib -> ../Cellar/brotli/1.0.9/lib/libbrotlienc.1.0.9.dylib
lrwxr-xr-x   1 awannaj  staff    47B Apr  7 15:27 libbrotlienc.1.dylib -> ../Cellar/brotli/1.0.9/lib/libbrotlienc.1.dylib
lrwxr-xr-x   1 awannaj  staff    45B Apr  7 15:27 libbrotlienc.dylib -> ../Cellar/brotli/1.0.9/lib/libbrotlienc.dylib
lrwxr-xr-x   1 awannaj  staff    50B Apr  7 15:27 libcares.2.5.1.dylib -> ../Cellar/c-ares/1.18.1_1/lib/libcares.2.5.1.dylib
lrwxr-xr-x   1 awannaj  staff    46B Apr  7 15:27 libcares.2.dylib -> ../Cellar/c-ares/1.18.1_1/lib/libcares.2.dylib
lrwxr-xr-x   1 awannaj  staff    44B Apr  7 15:27 libcares.dylib -> ../Cellar/c-ares/1.18.1_1/lib/libcares.dylib
lrwxr-xr-x   1 awannaj  staff    36B Apr  8 09:55 libpng.a -> ../Cellar/libpng/1.6.37/lib/libpng.a
lrwxr-xr-x   1 awannaj  staff    40B Apr  8 09:55 libpng.dylib -> ../Cellar/libpng/1.6.37/lib/libpng.dylib
lrwxr-xr-x   1 awannaj  staff    45B Apr  8 09:55 libpng16.16.dylib -> ../Cellar/libpng/1.6.37/lib/libpng16.16.dylib
lrwxr-xr-x   1 awannaj  staff    38B Apr  8 09:55 libpng16.a -> ../Cellar/libpng/1.6.37/lib/libpng16.a
lrwxr-xr-x   1 awannaj  staff    42B Apr  8 09:55 libpng16.dylib -> ../Cellar/libpng/1.6.37/lib/libpng16.dylib
lrwxr-xr-x   1 awannaj  staff    41B Apr 11 13:08 libgmp.10.dylib -> ../Cellar/gmp/6.2.1_1/lib/libgmp.10.dylib
lrwxr-xr-x   1 awannaj  staff    34B Apr 11 13:08 libgmp.a -> ../Cellar/gmp/6.2.1_1/lib/libgmp.a
lrwxr-xr-x   1 awannaj  staff    38B Apr 11 13:08 libgmp.dylib -> ../Cellar/gmp/6.2.1_1/lib/libgmp.dylib
lrwxr-xr-x   1 awannaj  staff    42B Apr 11 13:08 libgmpxx.4.dylib -> ../Cellar/gmp/6.2.1_1/lib/libgmpxx.4.dylib
lrwxr-xr-x   1 awannaj  staff    36B Apr 11 13:08 libgmpxx.a -> ../Cellar/gmp/6.2.1_1/lib/libgmpxx.a
lrwxr-xr-x   1 awannaj  staff    40B Apr 11 13:08 libgmpxx.dylib -> ../Cellar/gmp/6.2.1_1/lib/libgmpxx.dylib
lrwxr-xr-x   1 awannaj  staff    38B Apr 11 13:08 libisl.23.dylib -> ../Cellar/isl/0.24/lib/libisl.23.dylib
lrwxr-xr-x   1 awannaj  staff    31B Apr 11 13:08 libisl.a -> ../Cellar/isl/0.24/lib/libisl.a
lrwxr-xr-x   1 awannaj  staff    35B Apr 11 13:08 libisl.dylib -> ../Cellar/isl/0.24/lib/libisl.dylib
lrwxr-xr-x   1 awannaj  staff    40B Apr 11 13:09 libmpfr.6.dylib -> ../Cellar/mpfr/4.1.0/lib/libmpfr.6.dylib
lrwxr-xr-x   1 awannaj  staff    34B Apr 11 13:09 libmpfr.a -> ../Cellar/mpfr/4.1.0/lib/libmpfr.a
lrwxr-xr-x   1 awannaj  staff    38B Apr 11 13:09 libmpfr.dylib -> ../Cellar/mpfr/4.1.0/lib/libmpfr.dylib
lrwxr-xr-x   1 awannaj  staff    41B Apr 11 13:09 libmpc.3.dylib -> ../Cellar/libmpc/1.2.1/lib/libmpc.3.dylib
lrwxr-xr-x   1 awannaj  staff    35B Apr 11 13:09 libmpc.a -> ../Cellar/libmpc/1.2.1/lib/libmpc.a
lrwxr-xr-x   1 awannaj  staff    39B Apr 11 13:09 libmpc.dylib -> ../Cellar/libmpc/1.2.1/lib/libmpc.dylib
drwxr-xr-x   5 awannaj  staff   160B Apr 11 13:09 cmake
lrwxr-xr-x   1 awannaj  staff    44B Apr 11 13:09 libzstd.1.5.2.dylib -> ../Cellar/zstd/1.5.2/lib/libzstd.1.5.2.dylib
lrwxr-xr-x   1 awannaj  staff    40B Apr 11 13:09 libzstd.1.dylib -> ../Cellar/zstd/1.5.2/lib/libzstd.1.dylib
lrwxr-xr-x   1 awannaj  staff    34B Apr 11 13:09 libzstd.a -> ../Cellar/zstd/1.5.2/lib/libzstd.a
lrwxr-xr-x   1 awannaj  staff    38B Apr 11 13:09 libzstd.dylib -> ../Cellar/zstd/1.5.2/lib/libzstd.dylib
lrwxr-xr-x   1 awannaj  staff    51B May 13 11:09 libunistring.2.dylib -> ../Cellar/libunistring/1.0/lib/libunistring.2.dylib
lrwxr-xr-x   1 awannaj  staff    45B May 13 11:09 libunistring.a -> ../Cellar/libunistring/1.0/lib/libunistring.a
lrwxr-xr-x   1 awannaj  staff    49B May 13 11:09 libunistring.dylib -> ../Cellar/libunistring/1.0/lib/libunistring.dylib
lrwxr-xr-x   1 awannaj  staff    43B May 13 11:09 libidn2.0.dylib -> ../Cellar/libidn2/2.3.2/lib/libidn2.0.dylib
lrwxr-xr-x   1 awannaj  staff    37B May 13 11:09 libidn2.a -> ../Cellar/libidn2/2.3.2/lib/libidn2.a
lrwxr-xr-x   1 awannaj  staff    41B May 13 11:09 libidn2.dylib -> ../Cellar/libidn2/2.3.2/lib/libidn2.dylib
lrwxr-xr-x   1 awannaj  staff    42B May 13 11:09 libuv.1.dylib -> ../Cellar/libuv/1.44.1_1/lib/libuv.1.dylib
lrwxr-xr-x   1 awannaj  staff    36B May 13 11:09 libuv.a -> ../Cellar/libuv/1.44.1_1/lib/libuv.a
lrwxr-xr-x   1 awannaj  staff    40B May 13 11:09 libuv.dylib -> ../Cellar/libuv/1.44.1_1/lib/libuv.dylib
lrwxr-xr-x   1 awannaj  staff    39B Jul  4 12:13 libpcre.1.dylib -> ../Cellar/pcre/8.45/lib/libpcre.1.dylib
lrwxr-xr-x   1 awannaj  staff    33B Jul  4 12:13 libpcre.a -> ../Cellar/pcre/8.45/lib/libpcre.a
lrwxr-xr-x   1 awannaj  staff    37B Jul  4 12:13 libpcre.dylib -> ../Cellar/pcre/8.45/lib/libpcre.dylib
lrwxr-xr-x   1 awannaj  staff    41B Jul  4 12:13 libpcre16.0.dylib -> ../Cellar/pcre/8.45/lib/libpcre16.0.dylib
lrwxr-xr-x   1 awannaj  staff    35B Jul  4 12:13 libpcre16.a -> ../Cellar/pcre/8.45/lib/libpcre16.a
lrwxr-xr-x   1 awannaj  staff    39B Jul  4 12:13 libpcre16.dylib -> ../Cellar/pcre/8.45/lib/libpcre16.dylib
lrwxr-xr-x   1 awannaj  staff    41B Jul  4 12:13 libpcre32.0.dylib -> ../Cellar/pcre/8.45/lib/libpcre32.0.dylib
lrwxr-xr-x   1 awannaj  staff    35B Jul  4 12:13 libpcre32.a -> ../Cellar/pcre/8.45/lib/libpcre32.a
lrwxr-xr-x   1 awannaj  staff    39B Jul  4 12:13 libpcre32.dylib -> ../Cellar/pcre/8.45/lib/libpcre32.dylib
lrwxr-xr-x   1 awannaj  staff    42B Jul  4 12:13 libpcrecpp.0.dylib -> ../Cellar/pcre/8.45/lib/libpcrecpp.0.dylib
lrwxr-xr-x   1 awannaj  staff    36B Jul  4 12:13 libpcrecpp.a -> ../Cellar/pcre/8.45/lib/libpcrecpp.a
lrwxr-xr-x   1 awannaj  staff    40B Jul  4 12:13 libpcrecpp.dylib -> ../Cellar/pcre/8.45/lib/libpcrecpp.dylib
lrwxr-xr-x   1 awannaj  staff    44B Jul  4 12:13 libpcreposix.0.dylib -> ../Cellar/pcre/8.45/lib/libpcreposix.0.dylib
lrwxr-xr-x   1 awannaj  staff    38B Jul  4 12:13 libpcreposix.a -> ../Cellar/pcre/8.45/lib/libpcreposix.a
lrwxr-xr-x   1 awannaj  staff    42B Jul  4 12:13 libpcreposix.dylib -> ../Cellar/pcre/8.45/lib/libpcreposix.dylib
lrwxr-xr-x   1 awannaj  staff    38B Jul  4 12:13 liblzma.5.dylib -> ../Cellar/xz/5.2.5/lib/liblzma.5.dylib
lrwxr-xr-x   1 awannaj  staff    32B Jul  4 12:13 liblzma.a -> ../Cellar/xz/5.2.5/lib/liblzma.a
lrwxr-xr-x   1 awannaj  staff    36B Jul  4 12:13 liblzma.dylib -> ../Cellar/xz/5.2.5/lib/liblzma.dylib
lrwxr-xr-x   1 awannaj  staff    45B Jul  7 16:31 libpcre2-16.0.dylib -> ../Cellar/pcre2/10.40/lib/libpcre2-16.0.dylib
lrwxr-xr-x   1 awannaj  staff    39B Jul  7 16:31 libpcre2-16.a -> ../Cellar/pcre2/10.40/lib/libpcre2-16.a
lrwxr-xr-x   1 awannaj  staff    43B Jul  7 16:31 libpcre2-16.dylib -> ../Cellar/pcre2/10.40/lib/libpcre2-16.dylib
lrwxr-xr-x   1 awannaj  staff    45B Jul  7 16:31 libpcre2-32.0.dylib -> ../Cellar/pcre2/10.40/lib/libpcre2-32.0.dylib
lrwxr-xr-x   1 awannaj  staff    39B Jul  7 16:31 libpcre2-32.a -> ../Cellar/pcre2/10.40/lib/libpcre2-32.a
lrwxr-xr-x   1 awannaj  staff    43B Jul  7 16:31 libpcre2-32.dylib -> ../Cellar/pcre2/10.40/lib/libpcre2-32.dylib
lrwxr-xr-x   1 awannaj  staff    44B Jul  7 16:31 libpcre2-8.0.dylib -> ../Cellar/pcre2/10.40/lib/libpcre2-8.0.dylib
lrwxr-xr-x   1 awannaj  staff    38B Jul  7 16:31 libpcre2-8.a -> ../Cellar/pcre2/10.40/lib/libpcre2-8.a
lrwxr-xr-x   1 awannaj  staff    42B Jul  7 16:31 libpcre2-8.dylib -> ../Cellar/pcre2/10.40/lib/libpcre2-8.dylib
lrwxr-xr-x   1 awannaj  staff    48B Jul  7 16:31 libpcre2-posix.3.dylib -> ../Cellar/pcre2/10.40/lib/libpcre2-posix.3.dylib
lrwxr-xr-x   1 awannaj  staff    42B Jul  7 16:31 libpcre2-posix.a -> ../Cellar/pcre2/10.40/lib/libpcre2-posix.a
lrwxr-xr-x   1 awannaj  staff    46B Jul  7 16:31 libpcre2-posix.dylib -> ../Cellar/pcre2/10.40/lib/libpcre2-posix.dylib
lrwxr-xr-x   1 awannaj  staff    49B Jul  7 16:32 libfreetype.6.dylib -> ../Cellar/freetype/2.12.1/lib/libfreetype.6.dylib
lrwxr-xr-x   1 awannaj  staff    43B Jul  7 16:32 libfreetype.a -> ../Cellar/freetype/2.12.1/lib/libfreetype.a
lrwxr-xr-x   1 awannaj  staff    47B Jul  7 16:32 libfreetype.dylib -> ../Cellar/freetype/2.12.1/lib/libfreetype.dylib
lrwxr-xr-x   1 awannaj  staff    30B Jul  7 16:32 gcc -> ../Cellar/gcc/11.3.0_2/lib/gcc
lrwxr-xr-x   1 awannaj  staff    51B Jul  7 16:32 libnghttp2.14.dylib -> ../Cellar/libnghttp2/1.48.0/lib/libnghttp2.14.dylib
lrwxr-xr-x   1 awannaj  staff    44B Jul  7 16:32 libnghttp2.a -> ../Cellar/libnghttp2/1.48.0/lib/libnghttp2.a
lrwxr-xr-x   1 awannaj  staff    48B Jul  7 16:32 libnghttp2.dylib -> ../Cellar/libnghttp2/1.48.0/lib/libnghttp2.dylib
drwxr-xr-x   3 awannaj  staff    96B Jul  7 16:32 dtrace
drwxr-xr-x   3 awannaj  staff    96B Jul  7 16:32 node_modules
lrwxr-xr-x   1 awannaj  staff    46B Jul  7 16:33 binding_web -> ../Cellar/tree-sitter/0.20.6_1/lib/binding_web
lrwxr-xr-x   1 awannaj  staff    59B Jul  7 16:33 libtree-sitter.0.0.dylib -> ../Cellar/tree-sitter/0.20.6_1/lib/libtree-sitter.0.0.dylib
lrwxr-xr-x   1 awannaj  staff    57B Jul  7 16:33 libtree-sitter.0.dylib -> ../Cellar/tree-sitter/0.20.6_1/lib/libtree-sitter.0.dylib
lrwxr-xr-x   1 awannaj  staff    51B Jul  7 16:33 libtree-sitter.a -> ../Cellar/tree-sitter/0.20.6_1/lib/libtree-sitter.a
lrwxr-xr-x   1 awannaj  staff    55B Jul  7 16:33 libtree-sitter.dylib -> ../Cellar/tree-sitter/0.20.6_1/lib/libtree-sitter.dylib
drwxr-xr-x  38 awannaj  staff   1.2K Jul  7 16:33 pkgconfig

Hope you can help to solve this issue.

opened by najam-awan-db 0

dyld: Library not loaded: @rpath/libclntsh.dylib.12.1

hi, in my mac , I have an problem

db, err := sql.Open("oci8", openString)` if err != nil { fmt.Printf("Open error is not nil: %v", err) return }

... rows, err := db.QueryContext(ctx, "select REMARK2 from table") if err != nil { fmt.Println("QueryContext error is not nil:", err) return } ... for rows.Next() { fmt.Println(rows.Columns()) }

go build main.go && ./main is ok, but go run main.go then program go wrong like this.

how can i deal with that？

opened by gftao 0