DM8 常见应用程序开发配置

c/c开发编译安装unixodbc#解压源码包tar-xvunixODBC-2.3.12.tar.gz# 配置安装选项./configure --enable-guino#编译安装makemakeinstall编辑 odbcinst.ini文件[DM8 ODBC DRIVER]DescriptionODBC DRIVER FOR DM8 Driver/home/dmdba/dmdbms/bin/libdodbc.so编辑 odbc.ini文件[dm8]Description DM ODBC DSNDriver DM8 ODBC DRIVERSERVER localhostUID SYSDBAPWD Dameng123TCP_PORT 5236测试连接python开发前提Linux环境需要gcc编译工具编译安装python3#下载开发工具及依赖项yuminstallgcc openssl-devel bzip2-devel libffi-devel zlib-devel-y#下载源码wgethttps://www.python.org/ftp/python/3.8.9/Python-3.8.9.tgz# 解压源码包tar-xfPython-3.8.9.tgz# 配置安装选项cdPython-3.8.9##--enable-optimizations 在gcc8.1.0以下版本会导致编译失败./configure--prefix/usr/local/python3# 编译并安装make-j$(nproc)makeinstall编译安装 dmPythonpython3 setup.pyinstall设置 LD_LIBRARY_PATH 环境变量vi/root/.bash_profileexportLD_LIBRARY_PATH$LD_LIBRARY_PATH:/home/dmdba/dmdbms/drivers/dpi/source/root/.bash_profile测试连接importdmPython conndmPython.connect(userSYSDBA,passwordDameng123,server192.168.43.131,port5236)cursorconn.cursor()cursor.execute(select username from dba_users)valuescursor.fetchall()print(values)cursor.close()conn.close()Java开发创建maven工程导入DM驱动测试连接publicclassjdbc_conn{// 定义连接staticConnectionconnull;// 定义 DM JDBC 驱动串staticStringcnamedm.jdbc.driver.DmDriver;// 定义 DM URL 连接串staticStringurljdbc:dm://192.168.43.131:5236;// 定义连接用户名staticStringuseridSYSDBA;// 定义连接用户口令staticStringpwdDameng123;publicstaticvoidmain(String[]args){try{Class.forName(cname);conDriverManager.getConnection(url,userid,pwd);con.setAutoCommit(true);System.out.println([SUCCESS]conn database);}catch(Exceptione){System.out.println([FAIL]conn databasee.getMessage());}}publicvoiddisConn(Connectioncon)throwsSQLException{if(con!null){con.close();}}}Go开发下载并安装go#解压源码包tar-C/usr/local-xzfgo1.22.0.linux-amd64.tar.gz#配置环境变量exportPATH$PATH:/usr/local/go/binexportGOPATH$HOME/goexportPATH$PATH:$GOPATH/binsource~/.bashrc#检查版本信息go version下载并安装gityuminstallgityuminstallgit-svn git-email gitk解压并安装go驱动unzipdm-go-driver.zipcp-rdm/ /usr/local/go/src/测试连接vigodm.go go mod init godm goenv-wGOPROXYhttps://goproxy.cn,direct go mod tidypackagemain// 引入相关包import(database/sqlfmt_dm)vardb*sql.DBvarerrerrorfuncmain(){driverName:dmdataSourceName:dm://SYSDBA:Dameng123localhost:5236fmt.Println(1)ifdb,errconnect(driverName,dataSourceName);err!nil{fmt.Println(err)return}iferrdisconnect();err!nil{fmt.Println(err)return}}/* 创建数据库连接 */funcconnect(driverNamestring,dataSourceNamestring)(*sql.DB,error){vardb*sql.DBvarerrerrorifdb,errsql.Open(driverName,dataSourceName);err!nil{returnnil,err}iferrdb.Ping();err!nil{returnnil,err}fmt.Printf(connect to \%s\ succeed.\n,dataSourceName)returndb,nil}funcdisconnect()error{iferr:db.Close();err!nil{fmt.Printf(db close failed: %s.\n,err)returnerr}fmt.Println(disconnect succeed)returnnil}