达梦数据库开发接口配置

phul

267人浏览 · 2026-04-02 11:40:30

phul · 2026-04-02 11:40:30 发布

学习目标

jdbc、odbc、dpi、php、python完成开发运行环境的部署

JDBC

-- 获取java版本

java -version

-- 将driver18放在lib目录下

mkdir -p /home/dmdba/jdbc_project/lib

sudo mv /tmp/VMwareDnD/F6wg6R/DmJdbcDriver18.jar /home/dmdba/jdbc_project/lib/

ls -l /home/dmdba/jdbc_project/lib/

-- 编写测试代码

vim /home/dmdba/jdbc_project/TestConn.java



import java.sql.*;



public class TestConn {

    public static void main(String[] args) {

        String url = "jdbc:dm://localhost:5236";

        String user = "SYSDBA";

        String pwd = "Dameng@123";



        try {

            Class.forName("dm.jdbc.driver.DmDriver");

            System.out.println(">>> 驱动加载成功 (DmJdbcDriver18)");



            Connection conn = DriverManager.getConnection(url, user, pwd);

            System.out.println(">>> 数据库连接成功！");

            

            DatabaseMetaData meta = conn.getMetaData();

            System.out.println(">>> 数据库产品: " + meta.getDatabaseProductName());

            System.out.println(">>> 数据库版本: " + meta.getDatabaseProductVersion());



            Statement stmt = conn.createStatement();

            ResultSet rs = stmt.executeQuery("SELECT 1 AS RESULT FROM DUAL");

            

            if(rs.next()) {

                System.out.println(">>> 测试查询结果: " + rs.getInt("RESULT"));

            }



            rs.close();

            stmt.close();

            conn.close();

            

        } catch (Exception e) {

            System.err.println(">>> 发生错误:");

            e.printStackTrace();

        }

    }

}

安装javac

-- 备份现有yum配置

mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup

-- 下载阿里云 CentOS 7 归档源后安装javac

curl -o /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo



sed -i 's/mirror.cloud.aliyuncs.com/mirrors.aliyun.com/g' /etc/yum.repos.d/CentOS-Base.repo

sed -i 's/centos\/7/centos-vault\/7/g' /etc/yum.repos.d/CentOS-Base.repo



yum clean all

yum makecache

yum install -y java-1.8.0-openjdk-devel



su - dmdba

cd /home/dmdba/jdbc_project

javac -cp ".:lib/DmJdbcDriver18.jar" TestConn.java

java -cp ".:lib/DmJdbcDriver18.jar" TestConn

ODBC

-- 安装GCC编译工具链

yum install -y gcc gcc-c++ make automake autoconf libtool

-- 安装odbc驱动

sudo mv /tmp/VMwareDnD/F6wg6R/unixoDBc-2.3.0.tar.gz /opt/

cd /opt

tar -zxvf unixODBC-2.3.0.tar.gz

cd unixODBC-2.3.0

./configure --prefix=/usr/local

make

make install

-- 查看配置文件路径并配置

odbcinst -j



vi /usr/local/etc/odbcinst.ini

[DM ODBC DRIVER]

Description = ODBC DRIVER FOR DM

Driver = /home/dmdba/dmdbms/drivers/odbc/libdodbc.so

vi /usr/local/etc/odbc.ini

[DM]

Description = DM ODBC DSN

Driver = DM ODBC DRIVER

SERVER = localhost

UID = SYSDBA

PWD = Dameng@123

TCP_PORT = 5236

-- 连接测试

isql dm -v

DPI

-- 检查文件

gcc --version

ls -l /home/dmdba/dmdbms/include/DPI.h

ls -l /home/dmdba/dmdbms/bin/libdmdpi.so

PHP

-- 安装php

sudo yum install -y php php-cli php-pdo php-odbc

--确认安装成功

php -m | grep -i odbc

-- 确认odbc配置

cat /usr/local/etc/odbc.ini

dmPython

-- 安装python3

sudo yum install -y python3 python3-pip python3-devel gcc

-- 在root用户下配置环境变量

export DM_HOME=/home/dmdba/dmdbms

export LD_LIBRARY_PATH=$DM_HOME/bin:$LD_LIBRARY_PATH

export PATH=$DM_HOME/bin:$PATH

-- 确认路径

which python3

-- 进入目录

cd /home/dmdba/dmdbms/drivers/python/dmPython

-- 清理旧构建

rm -rf build *.egg-info

-- 使用绝对路径安装

/bin/python3 setup.py install

完整环境变量

# .bash_profile
# 达梦数据库 (Dameng DB) 通用开发环境变量配置
# 适用用户: dmdba

# 获取别名和函数 (标准配置)
if [ -f ~/.bashrc ]; then
    . ~/.bashrc
fi

# ==========================================
# 1. 核心基础环境
# ==========================================

# 设置达梦安装根目录
export DM_HOME="/home/dmdba/dmdbms"

# 设置字符集
export LANG=zh_CN.UTF-8
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

# ==========================================
# 2. 系统路径与动态库
# ==========================================

# 构建动态库路径 (LD_LIBRARY_PATH)
# 包含：核心_bin + ODBC驱动 + DPI库
# 逻辑：优先使用达梦库，保留原有系统库
DM_LIB_DIRS="$DM_HOME/bin:$DM_HOME/drivers/odbc"
export LD_LIBRARY_PATH="$DM_LIB_DIRS:${LD_LIBRARY_PATH:-}"

# 构建可执行文件路径 (PATH)
# 包含：bin (数据库命令) + tool (管理工具)
# 逻辑：将达梦命令置于系统命令之前，方便直接调用 disql, dminit 等
export PATH="$DM_HOME/bin:$DM_HOME/tool:$PATH"

# ==========================================
# 3. ODBC 专用配置
# ==========================================
# 指定 ODBC 配置文件目录
export ODBCSYSINI="/usr/local/etc"
export ODBCINI="/usr/local/etc/odbc.ini"

# ==========================================
# 4. 其他开发辅助
# ==========================================
# 如果安装了 Python local 包或 Java 本地脚本，保留此路径
export PATH="$PATH:$HOME/.local/bin:$HOME/bin"

# 导出关键变量
# 通常 bash 登录时会自动导出 export 过的变量，此处显式列出以示强调
export DM_HOME LANG NLS_LANG ODBCSYSINI ODBCINI

# 打印欢迎信息
# echo "Dameng Environment Loaded: $DM_HOME"

https://eco.dameng.com