sijms/go-ora 是纯golang 编写的oracle 驱动（目前不太稳定）但是已经很不错了，以下是参考试用
参考代码
package main
import (
"database/sql"
"flag"
"fmt"
_ "github.com/sijms/go-ora"
"log"
)
var (
username = flag.String("uname", "scott", "oracle username")
password = flag.String("password", "tiger", "oracle password")
oraclehost = flag.String("oraclehost", "dbhost", "oracle database host")
oracleport = flag.Int("oracleport", 1521, "oracle database port")
dbname = flag.String("dbname", "orclpdb1", "oracle database name")
)
func main() {
flag.Parse()
osqlInfo := fmt.Sprintf("oracle://%s:%s@%s:%d/%s", *username, *password, *oraclehost, *oracleport, *dbname)
db, err := sql.Open("oracle", osqlInfo)
if err != nil {
log.Fatalf("connect oracle db error: %s:", err.Error())
}
rows, err := db.Query("select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') AS name from dual")
if err != nil {
fmt.Println("exec query error:", err.Error())
}
for rows.Next() {
var name string
rows.Scan(&name)
fmt.Println("fetch item:")
fmt.Println(name)
}
}
运行说明
go run main.go -uname <username> -password <password> -oraclehost <ip> -dbname <db>
容器集成
这个就很简单了，直接用最小镜像处理
FROM golang:1.15-alpine AS build-env
WORKDIR /go/src/app
RUN /bin/sed -i 's,http://dl-cdn.alpinelinux.org,https://mirrors.aliyun.com,g' /etc/apk/repositories
ENV GO111MODULE=on
ENV GOPROXY=https://goproxy.cn
COPY . .
RUN apk update && apk add git
&& go build
FROM alpine:latest
WORKDIR /app
RUN /bin/sed -i 's,http://dl-cdn.alpinelinux.org,https://mirrors.aliyun.com,g' /etc/apk/repositories
RUN apk update && apk add ca-certificates && rm -rf /var/cache/apk/*
COPY --from=build-env /go/src/app/mygolang-oracle /app/mygolang-oracle
ENTRYPOINT [ "/app/mygolang-oracle" ]
说明
目前sijms/go-ora不是很稳定，但是至少很不错了，是一个值得试用的纯golang oracle驱动
参考资料
https://github.com/sijms/go-ora
https://github.com/rongfengliang/godror-golang-learning/tree/v2