linuxC++_OCCI访问oracle

下列代码测试了通过linux occi方式连接数据库。

#include <iostream>
#include <occi.h>

using namespace std;
#define LINUXOCCI //避免函数重定义错误
using namespace oracle::occi;

int main()
{
    Environment *env=Environment::createEnvironment(Environment::DEFAULT);
    cout<<"success"<<endl;

    const string name = "system";
    const string pass = "Orcl666";

#if 0
    const string srvName = "192.168.20.140:1521/jesse";
#else
    const string srvName = "JESSEDB";
#endif
    try
    {
        Connection *conn = env->createConnection(name, pass,srvName);
        cout<<"conn success"<<endl;
        env->terminateConnection(conn);
    }
    catch(SQLException e)
    {
        cout<<e.what()<<endl;
        return -1;
    }
    Environment::terminateEnvironment(env);
    cout<<"end!"<<endl;
    return 0;
}

02 - makefile

Demo:A01_testSQL.cpp
        g++ A01_testSQL.cpp -o Demo -I/u01/app/oracle/product/19.3.0/db_1/rdbms/public -L/u01/app/oracle/product/19.3.0/db_1/lib -locci -lclntsh