oracle occi 連線池

主要解決的問題包括:

1.單連線導致程式卡死的問題

2.雙查詢,導致程式慢的問題

示例:

連線

===============================================

env = Environment::createEnvironment (Environment::DEFAULT);
//conn = env->createConnection (user, passwd, db);

scp =
env->createStatelessConnectionPool(
user, passwd, db, 10, 1, 1,
StatelessConnectionPool::HOMOGENEOUS );

[@more@]

使用

=========================================

conn = scp->getConnection();
stmt = conn->createStatement (sqlStmt);
ResultSet *rset = stmt->executeQuery ();

..............

stmt->closeResultSet (rset);
conn->terminateStatement (stmt);
scp->releaseConnection(conn);