隨著國產化的推進，越來越多的企業選擇國產數據庫替代mysql或者Oracle。
本篇主要介紹golang如何適配國產數據庫
主流的國產數據庫有達夢，金倉，神通，優炫，南大通用數據庫等
前提環境
unixODBC安裝
yum -y install unixODBC unixODBC-devel
配置 gbase8s-odbc-driver
wget https://gbasedbt.com/dl/odbc/GBase8s_3.0.0_1-Linux64-ODBC-Driver.tar.gz --no-check-certificate
tar -zxf GBase8s_3.0.0_1-Linux64-ODBC-Driver.tar.gz
配置 sqlhosts
gbase01 onsoctcp ip 9088 g=db_group
cm_update group - - i=2,c=0
w1 onsoctcp ip 18888 g=cm_update
cm_read group - - i=3,c=0
r1 onsoctcp ip 19999 g=cm_read
配置環境變量 (使用 root) vim /etc/profile
export GBASEDBTDIR=/home/gbase8s-odbc-driver
export GBASEDBTSERVER=gbase01
export PATH=$GBASEDBTDIR/bin:$PATH
export GBASEDBTSQLHOSTS=$GBASEDBTDIR/etc/sqlhosts
export LD_LIBRARY_PATH=$GBASEDBTDIR/lib:$GBASEDBTDIR/lib/esql:$GBASEDBTDIR/lib/cli:$LD_LIBRARY_PATH
export ODBCINI=/home/gbase8s-odbc-driver/odbc.ini
配置 驅動 (使用 root) vim /etc/odbcinst.ini
[com.gbasedbt.jdbc.Driver]
Driver=/home/gbase8s-odbc-driver/lib/cli/iclit09b.so
Setup=/home/gbase8s-odbc-driver/lib/cli/iclit09b.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=03.51
FileUsage=0
SQLLevel=1
smProcessPerConnect=Y
配置 odbc.ini vim /home/linkdood/gbase8s-odbc-driver/odbc.ini
[ODBC]
UNICODE=UCS-2
測試驅動連接
isql -v -k "DRIVER={com.gbasedbt.jdbc.Driver};DB=testdataserver;UID=gbasedbt;pwd=GBase123;Server=gbase01;CLIENT_LOCALE=zh_CN.57372;DB_LOCALE=zh_CN.57372;"
golang通過odbc連接國產數據庫
func init() {
file, err := os.Open(“config.xml”)
if err != nil {
Log.Info(“error:%v”, err)
return
}
defer file.Close()
config, err := ioutil.ReadAll(file)
if err != nil {
Log.Info(“error:%v”, err)
return
}
configValue := SConfig{}
err = xml.Unmarshal(config, &configValue)
if err != nil {
Log.Error(“error:%v”, err)
return
}
strKey := configValue.Server.Aid + configValue.Server.Elogo
var strPassword string
var strUsername string
strPassword = configValue.DataBase.Password
strUsername = configValue.DataBase.User
fmt.Printf(“strPassword:%v\n”, strPassword)
fmt.Printf(“strUsername:%v\n”, strUsername)
ServerPort = configValue.Server.Port
var dbDSN = “” //dataSourceName
var driverName = “” //驅動名
var DbServer = configValue.DataBase.Host + “:” + configValue.DataBase.Port
if configValue.DataBase.DbType == “mysql” {
fmt.Printf(“mysql database\n”)
driverName = “mysql”
dbDSN = fmt.Sprintf(“%s:%s@tcp(%s:%s)/%s?charset=%s”, strUsername, strPassword, configValue.DataBase.Host, configValue.DataBase.Port, configValue.DataBase.DBName, configValue.DataBase.Charset)
} else if configValue.DataBase.DbType == “shentong” {
fmt.Printf(“shentongsql database\n”)
/driverName = “odbc”
dbDSN = fmt.Sprintf(“driver={%s};server=%s;port=%s;database=%s;uid=%s;pwd=%s;charset=%s”, configValue.DataBase.Driver, configValue.DataBase.Host, configValue.DataBase.Port, configValue.DataBase.DBName, strUsername, strPassword, configValue.DataBase.Charset)/
driverName = “aci”
dbDSN = fmt.Sprintf(“%s/%s@%s:%s/%s”, strUsername, strPassword, configValue.DataBase.Host, configValue.DataBase.Port, configValue.DataBase.DBName)
} else if configValue.DataBase.DbType == “dameng” {
strPassword = CheckAndModifyString(strPassword)
fmt.Printf(“dmsql database\n”)
driverName = “dm”
//dbDSN = fmt.Sprintf(“driver={%s};server=%s;database=%s;uid=%s;pwd=%s;charset=%s”, configValue.DataBase.Driver, DbServer, configValue.DataBase.DBName, strUsername, strPassword, configValue.DataBase.Charset)
dbDSN = fmt.Sprintf(“%s://%s:%s@%s?schema=%s”, driverName, strUsername, strPassword, DbServer, configValue.DataBase.DBName)
} else if configValue.DataBase.DbType == “kingbase” {
fmt.Printf(“kingbase database\n”)
driverName = “odbc”
dbDSN = fmt.Sprintf(“driver={%s};server=%s;port=%s;database=%s;uid=%s;pwd=%s;charset=%s”, configValue.DataBase.Driver, configValue.DataBase.Host, configValue.DataBase.Port, configValue.DataBase.DBName, strUsername, strPassword, configValue.DataBase.Charset)
} else if configValue.DataBase.DbType == “GBase8s” {
fmt.Printf(“GBase8s database\n”)
driverName = “odbc”
dbDSN = fmt.Sprintf(“driver={%s};server=%s;port=%s;database=%s;uid=%s;pwd=%s;charset=%s”, configValue.DataBase.Driver, configValue.DataBase.Host, configValue.DataBase.Port, configValue.DataBase.DBName, strUsername, strPassword, configValue.DataBase.Charset)
}
dbType = configValue.DataBase.DbType
// 打開連接失敗
MysqlDb, MysqlDbErr = sql.Open(driverName, dbDSN)
//defer MysqlDb.Close();
if MysqlDbErr != nil {
panic("數據源配置不正確: " + MysqlDbErr.Error())
}
// 最大連接數
MysqlDb.SetMaxOpenConns(100)
// 閑置連接數
MysqlDb.SetMaxIdleConns(20)
// 最大連接周期
MysqlDb.SetConnMaxLifetime(100 * time.Second)
if MysqlDbErr = MysqlDb.Ping(); nil != MysqlDbErr {
panic("數據庫鏈接失敗: " + MysqlDbErr.Error())
}
}
)
