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

Report message to a moderator

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

Report message to a moderator

Previous Topic: OCCI terminateStatement !!!!!!!!!!!!!!!!!
Next Topic: setMaxIterations API of OCCI not setting the max number of iterations
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 20:51:48 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.