我正在尝试从Windows连接到Oracle DB(64位Go,32位客户端)。
我已经参考了这个问题,但因为我对Go完全不熟悉,所以对他建议的配置一窍不通。
我已经安装了多个客户端,比如:
1. `code.google.com\p\odbc`
2. `github.com\mattn\go-oci8`
我试图创建oci8.pc
文件,但似乎出现了错误。
prefix=/devel/target/1.0
exec_prefix=${prefix}
libdir=C:/oracle/instantclient_12_1/sdk/lib/msvc
includedir=C:/oracle/instantclient_12_1/sdk/include
oralib=C:/oracle/instantclient_12_1/sdk/lib/msvc
orainclude=C:/oracle/instantclient_12_1/sdk/include
gcclib=C:/TDM-GCC-64/lib
gccinclude=C:/TDM-GCC-64/include
glib_genmarshal=glib-genmarshal
gobject_query=gobject-query
glib_mkenums=glib-mkenums
Name: oci8
Version: 12.1
Description: oci8 library
Libs: -L${oralib} -L${gcclib} -loci
Libs.private:
Cflags: -I${orainclude} -I${gccinclude}
当我运行以下代码时,出现错误:
// TestDB
package main
import (
"github.com/odbc"
)
func main() {
conn, _ := odbc.Connect("DSN=lnxcepd1db01.XXXXXX.com:51521*CBPDEV;UID=XXXXX;PWD=XXXXX")
defer conn.Close()
stmt, _ := conn.Prepare("select * from XXXXX where XXXX = ?")
defer stmt.Close()
stmt.Execute("100044")
rows, _ := stmt.FetchAll()
for i, row := range rows {
println(i, row)
}
}
错误:
panic: runtime error: invalid memory address or nil pointer dereference
panic: runtime error: invalid memory address or nil pointer dereference
[signal 0xc0000005 code=0x0 addr=0x8 pc=0x43c3a6]
goroutine 1 [running]:
github.com/odbc.(*Connection).Close(0x0, 0x45)
C:/Go/UDL/src/github.com/odbc/odbc.go:263 +0x26
github.com/odbc.(*Connection).newStmt(0x0, 0x36, 0xc0820120e0)
C:/Go/UDL/src/github.com/odbc/odbc.go:152 +0x50
github.com/odbc.(*Connection).Prepare(0x0, 0x51cf70, 0x36, 0x0, 0x0, 0x0, 0xc082005e90, 0x9d6eb0)
C:/Go/UDL/src/github.com/odbc/odbc.go:162 +0x51
main.main()
C:/Go/My Codes/new/TestDB.go:12 +0xc4
goroutine 17 [syscall, locked to thread]:
runtime.goexit()
c:/go/src/runtime/asm_amd64.s:2232 +0x1
我有什么遗漏吗?如果有人能指导我正确的方向,我将非常感激。
提前感谢。
编辑:
浏览了更多内容后,我将自己的代码更改如下:
// TestDB
package main
import (
_ "code.google.com/p/odbc"
"database/sql"
"fmt"
)
func main() {
fmt.Println(sql.Drivers())
db, err := sql.Open("odbc","DSN=lnxcepd1db01.xxxx.com:51521*CBPDEV;UID=XXXX;PWD=XXXX")
if err != nil {
panic(err)
}
rows, err := db.Query("select TABLE_NAME from tabs")
var TABLE_NAME string
defer rows.Close()
for rows.Next() {
fmt.Println(rows.Columns())
rows.Scan(&TABLE_NAME)
fmt.Println(TABLE_NAME)
}
err = rows.Err()
if err != nil {
panic(err)
}
defer db.Close()
}
输出 + 错误堆栈:
[odbc]
panic: runtime error: invalid memory address or nil pointer dereference
panic: runtime error: invalid memory address or nil pointer dereference
[signal 0xc0000005 code=0x0 addr=0x20 pc=0x453408]
goroutine 1 [running]:
database/sql.(*Rows).Close(0x0, 0x0, 0x0)
c:/go/src/database/sql/sql.go:1659 +0x38
database/sql.(*Rows).Next(0x0, 0xc082002400)
c:/go/src/database/sql/sql.go:1586 +0x2c
main.main()
C:/Go/My Codes/new/TestDB.go:23 +0x263
goroutine 2 [runnable]:
runtime.forcegchelper()
c:/go/src/runtime/proc.go:90
runtime.goexit()
c:/go/src/runtime/asm_amd64.s:2232 +0x1
goroutine 3 [runnable]:
runtime.bgsweep()
c:/go/src/runtime/mgc0.go:82
runtime.goexit()
c:/go/src/runtime/asm_amd64.s:2232 +0x1
goroutine 4 [runnable]:
runtime.runfinq()
c:/go/src/runtime/malloc.go:712
runtime.goexit()
c:/go/src/runtime/asm_amd64.s:2232 +0x1
goroutine 5 [runnable]:
database/sql.(*DB).connectionOpener(0xc08205a000)
c:/go/src/database/sql/sql.go:588
created by database/sql.Open
c:/go/src/database/sql/sql.go:452 +0x323
如您所见,当我打印可用驱动程序时,我得到了odbc
,但我不确定我错过了什么。
我正在使用这个odbc驱动程序。
https://code.google.com/p/odbc/wiki/GettingStartedOnWindows
我注意到一件事:
当我使用
db, err := sql.Open("odbc", "DSN=lnxcepd1db01.XXXXX.com:51521;USERID=XXXX;PASSWORD=XXXX;DATABASE=CBPDEV")
我遇到了错误,错误信息如下:
%v SQLDriverConnect: {IM002} [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
当我尝试时,
db, err := sql.Open("odbc", "DSN=lnxcepd1db01.XXXXXX.com:51521*CBPDEV;UID=XXXX;PWD=XXXXX")
我遇到了错误:
SQLDriverConnect: {IM010} [Microsoft][ODBC Driver Manager] Data source name too long
And this one as well:
db, err := sql.Open("odbc","DSN=lnxcepd1db01.XXXXX.com:51521*cbpdev;UID=XXX;PWD=XXXX")
错误:
SQLDriverConnect: {IM010} [Microsoft][ODBC Driver Manager] Data source name too long
我完全迷失了,因为我无法将这个问题与驱动程序问题、代码问题或连接字符串中缺少某些参数联系起来。
我有以下几个问题:
我的连接字符串有什么问题? 是否有人有一个工作正常的设置或从API构建开始执行的说明(很抱歉,我尝试过一些但没有成功)? 哪个API更好或更容易使用?
open()
方法抛出了错误。我已经编辑了帖子。 - Aditya Peshave