wendal / go-oci8 Goto Github PK

View Code? Open in Web Editor NEW

This project forked from mattn/go-oci8

71.0 10.0 35.0 848 KB

oracle driver for go that using database/sql 请使用原版 https://github.com/mattn/go-oci8

Home Page: http://mattn.kaoriya.net/

Go 100.00%

go-oci8's Introduction

go-oci8

DESCRIPTION 简介

oracle driver for go that using database/sql
实现了database/sql的Oracle数据库驱动,使用了OCI

LICENSE

MIT: http://mattn.mit-license.org/2011

在Windows下安装

安装最新版的git,并设置可以从命令行直接调用git命令
下载OCI最新版,存放于D:\GoOracleEnv\instantclient_19_3
下载OCI SDK最新版,存放于D:\GoOracleEnv\instantclient_19_3\sdk
下载MinGW最新版,安装在C:\mingw
下载pkg-config.exe和oci8.pc (已经存放在windows文件夹下)
将pkg-config.exe复制到C:\mingw\bin\下
将oci8.pc复制到C:\mingw\lib\pkg-config\下
修改系统环境变量,添加
- PATH=原有PATH;D:\GoOracleEnv\instantclient_19_3;C:\mingw\bin;
- PKG_CONFIG_PATH=C:\mingw\lib\pkg-config
执行 go get github.com/Kylelkh/go-oci8

在mac下安装

步骤1，2，3同上 oci和oci sdk 下载地址：http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html (下载instantclient-basic和instantclient-sdk) 下载完成后，输入如下命令

   cd <instanclient path>
   mv libclntsh.dylib.* libclntsh.dylib
    
   ln <instanclient path>/libclntsh.dylib /usr/lib/libclntsh.dylib
   ln <instanclient path>/libocci.dylib.* /usr/lib/libocci.dylib.*
   ln <instanclient path>/libociei.dylib /usr/lib/libociei.dylib
   ln <instanclient path>/libnnz11.dylib /usr/lib/libnnz11.dylib

修改oci8.pc文件

   prefix=D:\GoOracleEnv\instantclient_19_3
   exec_prefix=D:\GoOracleEnv\instantclient_19_3
   libdir=${prefix}
   includedir=${prefix}/sdk/include/
   
   Name: OCI
   Description: Oracle database engine
   Version: 11.2
   Libs: -L${libdir} -lclntsh
   Libs.private: 
   Cflags: -I${includedir}

由于osx 上默认是没有pkg-config工具的需要手动安装一下

sudo brew install pkg-config 
export PKG_COFNIG_PATH="/usr/lib/pkgconfig"

以上完成后 go get github.com/Kylelkh/go-oci8 就可以了

在Linux下安装

待写

go-oci8's People

Contributors

Stargazers

Watchers

go-oci8's Issues

issue about fetching date column

Dear wendal,
I use go-oci8 to access oracle to fetch data, it works well normally . But once the column is date format, the program will throw a panic error "panic: ORA-01406: fetched column value was truncated".
could you kindly help to resolve it or give a hint how to resolve it ? thanks .

fatal error: oci.h: No such file or directory

按照文档说明做了如下配置，但是在import的时候报错，不知道哪里有问题，请大神指点

GetAffectRow和GetLastInsertID获取数据不准确

感谢作者将mattn重新封装，但美中不足的是GetAffectRow和GetLastInsertID两个方法是有问题的，获取到的数皆为0

编译有误

go get error

under go 1.6, it will raise a error:
C:\Go\src\github.com\wendal\go-oci8\oci8.go:116: cannot convert (**C.struct_OCIServer)(unsafe.Pointer(&conn.svc)) (type **C.struct_OCIServer) to type **C.struct_OCISvcCtx

Is there any solution for this problem?

无法使用连接池来调用数据库连接

该版本驱动貌似无法使用连接池，每进行完插入、删除、更新操作，要想其在数据库真实生效，需要调用db.Close()方法才能提交，设计不太合理

MAC 下编译linux平台怎么操作？

GOOS=linux GOARCH=amd64 go build  main.go
# github.com/mattn/go-oci8
../../github.com/mattn/go-oci8/oci8_go18.go:12: undefined: OCI8Conn
../../github.com/mattn/go-oci8/oci8_go18.go:17: undefined: OCI8Conn
../../github.com/mattn/go-oci8/oci8_go18.go:18: undefined: namedValue
../../github.com/mattn/go-oci8/oci8_go18.go:20: undefined: namedValue
../../github.com/mattn/go-oci8/oci8_go18.go:26: undefined: OCI8Conn
../../github.com/mattn/go-oci8/oci8_go18.go:27: undefined: namedValue
../../github.com/mattn/go-oci8/oci8_go18.go:35: undefined: OCI8Conn
../../github.com/mattn/go-oci8/oci8_go18.go:40: undefined: OCI8Conn
../../github.com/mattn/go-oci8/oci8_go18.go:45: undefined: OCI8Stmt
../../github.com/mattn/go-oci8/oci8_go18.go:54: undefined: OCI8Stmt
../../github.com/mattn/go-oci8/oci8_go18.go:27: too many errors

CreateProcess: No such file or directory

go get github.com/wendal/go-oci8

C:\Windows\system32>go get github.com/wendal/go-oci8
go: finding github.com/wendal/go-oci8 latest
# github.com/wendal/go-oci8
gcc: error: CreateProcess: No such file or directory

my instantclient_12_2 is 32bit, MinGW is "x86_64-4.8.2-release-posix-seh-rt_v3-rev4"

gooci

c:\go\pkg\tool\windows_amd64\link.exe: running gcc failed: exit status 1
C:/MinGW/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/4.8.2/../../../../x86_64-w64-mingw32/bin/ld.exe: skipping incompatible C:\instantclient_12_2\sdk\lib\msvc/oci.lib when searching for -loci
C:/MinGW/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/4.8.2/../../../../x86_64-w64-mingw32/bin/ld.exe: skipping incompatible C:/instantclient_12_2/oci.dll when searching for -loci
C:/MinGW/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/4.8.2/../../../../x86_64-w64-mingw32/bin/ld.exe: skipping incompatible C:\instantclient_12_2\sdk\lib\msvc/oci.lib when searching for -loci
C:/MinGW/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/4.8.2/../../../../x86_64-w64-mingw32/bin/ld.exe: skipping incompatible C:\instantclient_12_2\sdk\lib\msvc\oci.lib when searching for -loci
C:/MinGW/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/4.8.2/../../../../x86_64-w64-mingw32/bin/ld.exe: skipping incompatible C:/instantclient_12_2/oci.dll when searching for -loci
C:/MinGW/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/4.8.2/../../../../x86_64-w64-mingw32/bin/ld.exe: cannot find -loci
C:/MinGW/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/4.8.2/../../../../x86_64-w64-mingw32/bin/ld.exe: skipping incompatible C:\instantclient_12_2\sdk\lib\msvc/oci.lib when searching for -loci
C:/MinGW/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/4.8.2/../../../../x86_64-w64-mingw32/bin/ld.exe: skipping incompatible C:/instantclient_12_2/oci.dll when searching for -loci
C:/MinGW/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/4.8.2/../../../../x86_64-w64-mingw32/bin/ld.exe: skipping incompatible C:\instantclient_12_2\sdk\lib\msvc/oci.lib when searching for -loci
C:/MinGW/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/4.8.2/../../../../x86_64-w64-mingw32/bin/ld.exe: skipping incompatible C:\instantclient_12_2\sdk\lib\msvc\oci.lib when searching for -loci
C:/MinGW/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/4.8.2/../../../../x86_64-w64-mingw32/bin/ld.exe: skipping incompatible C:/instantclient_12_2/oci.dll when searching for -loci
C:/MinGW/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/4.8.2/../../../../x86_64-w64-mingw32/bin/ld.exe: cannot find -loci
collect2.exe: error: ld returned 1 exit status