Home » Developer & Programmer » Precompilers, OCI & OCCI » OCCI Connection Pool on Oracle RAC
OCCI Connection Pool on Oracle RAC [message #139313] Tue, 27 September 2005 07:09 Go to next message
jose_luis_fdez
Messages: 1
Registered: September 2005
Junior Member
Hi,

In a OCCI program I use a connection pool to connect to a Oracle RAC
with two instances:

. . .
if ( env_general == NULL )
{
//env_general =
Environment::createEnvironment(Environment::OBJECT);
env_general =
Environment::createEnvironment(Environment::THREADED_MUTEXED);
}
if (connPool_general == NULL)
connPool_general = env_general->createConnectionPool(poolUserName,
poolPassword,
connectString, minConn, maxConn, incrConn);
. . .

I connect with:

conn = connPool_general->createConnection (user, passwd);

When there is a instance change I loss the connection. Is it a Oracle
configuration problem or must I resume the connection calling
"terminateConnectionPool" and "createConnectionPool" again ?

Thanks in advance,
Jose Luis
Re: OCCI Connection Pool on Oracle RAC [message #150004 is a reply to message #139313] Mon, 05 December 2005 23:48 Go to previous message
kmohan
Messages: 28
Registered: July 2005
Junior Member
what is an instance change? Are you bringing down one instance? You can terminate the connection (and not the pool) if it is found to be bad. That way all bad connections go off the pool gradually and the pool gets into a good shape.
You can try configuring TAF (Transparent Application Failover) if you are using OCCI 10.2.
http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14294/performance.htm#CHDJEAFF
Previous Topic: OCCI terminateStatement !!!!!!!!!!!!!!!!!
Next Topic: setMaxIterations API of OCCI not setting the max number of iterations
Goto Forum:
  


Current Time: Sat Oct 31 15:01:53 CDT 2020