Linux平台下OCCI环境搭建

Linux平台下OCCI环境搭建

相关文件:oracle_client_11gR2.tar.gz

1解压文件:

tar -xzvf oracle_client_11gR2.tar.gz
//将解压之后的文件 剪切到opt目录中
mv instantclient_11_2 /opt/

设置环境变量

vim ~/.bash_profile
文件最后添加

# 请把已经环境变量设置到对应的文件中
# 可以是当前用户的 ~/.bashrc文件, 也可以是系统的 /etc/profile文件
​
# OCCI_HOME 该环境变量的路径需要做对应修改
export OCCI_HOME=/opt/instantclient_11_2 
export OCCI_INCLUDE_DIR=$OCCI_HOME/sdk/include
export OCCI_LIBRARY_PATH=$OCCI_HOME 
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$OCCI_LIBRARY_PATH
# 程序编译是搜索的库目录
export LIBRARY_PATH=$LIBRARY_PATH:$OCCI_LIBRARY_PATH
# 程序编译时搜索的头文件目录
export CPLUS_INCLUDE_PATH=$CPLUS_INCLUDE_PATH:$OCCI_INCLUDE_DIR
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

使修改生效

source ~/.bash_profile

测试程序

#include 
#include 
using namespace std;
using namespace oracle::occi;
​
int main()
{
    const string userName = "SCOTT";
    const string password = "11";
    const string connString = "192.168.1.159:1521/orcl";
    try
    {
        Environment *env = Environment::createEnvironment(Environment::DEFAULT);
        Connection *con = env->createConnection(userName, password, connString);
        cout << "Success to connect!" << endl;
        Statement *stmt = con->createStatement();
        stmt->setSQL("select * from dept");
        ResultSet *rs = stmt->executeQuery();
        while (rs->next())
        {
            cout << "ID:" << rs->getInt(1) << endl;
        }
        con->terminateStatement(stmt);
        env->terminateConnection(con);
        Environment::terminateEnvironment(env);
    }
    catch (SQLException &ex)
    {
        cout << ex.what() << endl;
    }
​
    return 0;
}

g++ -std=c++11 -lnnz11 -lclntsh -locci test.cpp