OCCI环境
#########################################
# for Oracle
#########################################
export ORACLE_HOME=/data/aifront/cpl/ora/10.2.0
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$LD_LIBRARY_PATH
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
<<helloOCCI.cpp>>
#include <occi.h>
#include <string>
using namespace std;
using namespace oracle::occi ;
int main()
{
try
{
string username = "ora";
string password = "ora*123";
/*
$ORACLE_HOME/network/admin/tnsnames.ora 中
oracle =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = oradb)
)
)
*/
string connstr = "oracle";
Environment* env = Environment::createEnvironment(Environment::OBJECT);;
Connection* conn = env->createConnection( username.c_str() , password.c_str() , connstr.c_str() );
cout << "连接成功!"<< endl;
Statement* stmt = conn->createStatement();
stmt->setSQL("select sysdate as p from dual");
ResultSet* rs = stmt->executeQuery();
while( rs->next() == true )
{
cout << rs->getString(1) << endl;
}
stmt->closeResultSet(rs);
conn->terminateStatement(stmt);
env->terminateConnection(conn);
Environment::terminateEnvironment(env);
cout << "关闭成功!"<< endl;
}
catch(exception& ex)
{
cout << ex.what() << endl;
}
}
<<makefile>
main:step_3
CC -L/data/aifront/cpl/ora/10.2.0/lib32 -locci -lclntsh ./tmp/helloOCCI.o -o ./bin
step_3:step_2
CC -c ./tmp/helloOCCI.s -o ./tmp/helloOCCI.o
step_2:step_1
CC -S ./tmp/helloOCCI.i -o ./tmp/helloOCCI.s
step_1:
CC -I/data/aifront/cpl/ora/10.2.0/rdbms/public -P ./src/helloOCCI.cpp -o ./tmp/helloOCCI.i
clean:
rm -f ./tmp/* ./bin ./core
运行调试
[/data/aifront/cpl/others/demo03]make
CC -I/data/aifront/cpl/ora/10.2.0/rdbms/public -P ./src/helloOCCI.cpp -o ./tmp/helloOCCI.i
CC -S ./tmp/helloOCCI.i -o ./tmp/helloOCCI.s
CC -c ./tmp/helloOCCI.s -o ./tmp/helloOCCI.o
CC -L/data/aifront/cpl/ora/10.2.0/lib32 -locci -lclntsh ./tmp/helloOCCI.o -o ./bin
[/data/aifront/cpl/others/demo03]bin
连接成功!
21-NOV-13
关闭成功!
[/data/aifront/cpl/others/demo03]