oracle::occi,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);