Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> OCCI Connection Pool on Oracle RAC

OCCI Connection Pool on Oracle RAC

From: <jose_luis_fdez_diaz_news_at_yahoo.es>
Date: 27 Sep 2005 04:38:04 -0700
Message-ID: <1127821084.060704.238230@g47g2000cwa.googlegroups.com>

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 Received on Tue Sep 27 2005 - 06:38:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US