go-ora
go-ora copied to clipboard
sijms
Pure go oracle client
time="2022-09-10 01:39:35.632733" level=debug msg="the run sqlID: 1568293051590250496 [SELECT DISTINCT PRIVILEGE FROM ( SELECT PRIVILEGE FROM USER_SYS_PRIVS UNION ALL SELECT GRANTED_ROLE FROM USER_ROLE_PRIVS UNION ALL SELECT PRIVILEGE FROM ROLE_SYS_PRIVS a,USER_ROLE_PRIVS b...
oracle version：Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production Golang ： go 1.18 database/sql go-ora 2.5.3 use native *sql.DB. ```go conn, err := sql.Open("oracle", c.Oracle.Source) if err !=...
If the go program connect to more than one database/schema and using `go_ora.AddSessionParam` the last call to `AddSessionParam` overwrites other values. for example: - `db1 := db.Open("db1.example.com"`) - `go_ora.AddSessionParam(db1, "CURRENT_SCHEMA",...
It looks like some recent changes have introduced a thread-safety problem when using a pooled cache of prepared statements created against a `*sql.DB` and then subsequently bound to a `*sql.TX`....
Can we allow for the use of `SSL_SERVER_CERT_DN` and `SSL_SERVER_DN_MATCH` as it is in a Net Description string? As far as I know, current SSL only works when setting `SSL...
I have the following data in the db (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0) ```sql create TABLE TEST_TABLE ( ID INTEGER NOT NULL PRIMARY KEY, NAME VARCHAR(50) ); insert...
I'm currently facing an issue when trying to connect using `BuildJDC` function with the a orclNetDescString similar to the following: `DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=host.com)(PORT=port))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=service))(SECURITY=(SSL_SERVER_CERT_DN="CN=cname,O=org,L=location")))` Using the following code ```go package main import (...
I'm trying to connect to Oracle DB with SSL without using wallet and I'm getting "tls: handshake failure" Below is my code. Can anyone try to help me on this...
Hello everyone, Can you please let me know if go-ora supports OCI IAM Token based authentication for oracle ADB ? I am trying to add the configuration for OCI_TOKEN in...
# error  # code ```golang //connection options := map[string]string{ "TIMEOUT": "300", } if val := viper.GetString("database.oracle.sid"); val != "" { options["SID"] = val } dsn := go_ora.BuildUrl(viper.GetString("database.oracle.host"), viper.GetInt("database.oracle.port"), viper.GetString("database.oracle.service"),...
