下列代码测试了通过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