OraFAQ Forum: Precompilers, OCI & OCCI » Proper use of ConnectionPool in OCCI

Home » Developer & Programmer » Precompilers, OCI & OCCI » Proper use of ConnectionPool in OCCI (Windows server 2003 x64, Oracle 11.1.0.6.0 client connecting to oracle 10.1.0.2.0 database, Visual studio 2008, visual c++ 9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Proper use of ConnectionPool in OCCI [message #423557]

Fri, 25 September 2009 05:28

dk.gawande
Messages: 1
Registered: September 2009

Junior Member

Hi,

I am developing a client server application using Windows server 2003 x64, Oracle 11.1.0.6.0 client connecting to oracle 10.1.0.2.0 database, Visual studio 2008, visual c++ 9.

The scenario is something like this,
upon receiving the client request, the server executes a stored procedure as per the request. I have a number of classes thru which the stored procedure gets called. Currently, in every method of these classes, I am creating new connection to the database as follows..

Environment *env = Environment::createEnvironment(Environment::OBJECT);
Connection *conn = env->createConnection( USERID, PASSWORD, ORACLESID );

But now I want to use a ConnectionPool to improve performance of my application.

My question is, where do I create the ConnectionPool object so that it is accessible from all the methods of the classes?

[Updated on: Fri, 25 September 2009 05:30]

Report message to a moderator

Previous Topic:	libocci.so.10.1 is empty
Next Topic:	using object types in pro*c/c++

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 06:39:25 CDT 2025