golang通过oci访问oracle数据库

golang通过oci访问oracle数据库

1. 首先需要下载 oracle driver for go that using database/sql

$ go get github.com/mattn/go-oci8

2. 然后下载Oracle Instant Client

https://www.oracle.com/database/technologies/instant-client/downloads.html
因为github.com/mattn/go-oci8也是需要用到的。

解开后得到文件夹,例如:instantclient_19_3

3. golang访问程序

package main
import (
 "fmt"
 "log"
 "database/sql"
 _ "github.com/mattn/go-oci8"
)
const (
 username = "scott"
 password = "tiger"
 connstring = "//xxx.xxx.xxx.xxx:1521/orcl"
)
func main() {
 db, err := sql.Open("oci8", fmt.Sprintf("%s/%s@%s", username, password, connstring))
 if err != nil {
 log.Printf("ERROR: Cannot open [%s/XXXX@%s], err=[%v]\n", username, connstring, err)
 return
 }
 log.Printf("Open [%s/XXXX@%s]\n", username, connstring)
 defer db.Close()
 if err := db.Ping(); err != nil {
 log.Printf("ERROR: Cannot ping database, err=[%v]\n", err)
 return
 }
 var version string
 if err := db.QueryRow("SELECT VERSION FROM PRODUCT_COMPONENT_VERSION WHERE PRODUCT LIKE 'Oracle Database%'").Scan(&version); err != nil {
 log.Printf("ERROR: Cannot get database version, err=[%v]\n", err)
 return
 }
 log.Printf("Database version [%s]\n", version)
}

4. Makefile文件

$ cat Makefile 
# Oracle Instant Client: https://www.oracle.com/database/technologies/instant-client.html
# go get github.com/mattn/go-oci8
all: testoci
testoci: main.go
 LIBRARY_PATH=$(abspath instantclient_19_3) \
 LD_LIBRARY_PATH=$(abspath instantclient_19_3) \
 LD_RUN_PATH=$(abspath instantclient_19_3) \
 C_INCLUDE_PATH=$(abspath instantclient_19_3/include) \
 PKG_CONFIG_PATH=$(abspath src/github.com/mattn/go-oci8) \
 GOPATH=$(abspath .) \
 go build -x
.PHONY: clean
clean:
 rm -f testoci

整个目录结构包括

-rw-r--r-- 1 <user> <group> 485 Jun 6 03:58 Makefile
drwxr-xr-x 3 <user> <group> 4096 Jun 6 03:25 instantclient_19_3
-rw-r--r-- 1 <user> <group> 981 Jun 6 03:55 main.go
drwxr-xr-x 3 <user> <group> 4096 Jun 6 03:57 pkg
drwxr-xr-x 3 <user> <group> 4096 Jun 6 03:57 src

5. 编译运行

$ make && ./testoci
...
2019年06月06日 04:08:18 Open [scott/XXXX@//xxx.xxx.xxx.xxx:1521/orcl]
2019年06月06日 04:08:18 Database version [12.1.0.2.0]

有疑问加站长微信联系(非本文作者)

• 请尽量让自己的回复能够对别人有帮助
• 支持 Markdown 格式, **粗体**、~~删除线~~、`单行代码`
• 支持 @ 本站用户;支持表情(输入 : 提示),见 Emoji cheat sheet
• 图片支持拖拽、截图粘贴等方式上传