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)
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:
  


Current Time: Thu Sep 29 20:58:18 CDT 2016

Total time taken to generate the page: 0.17338 seconds