Home » Developer & Programmer » Precompilers, OCI & OCCI » how to handle a lot of connections
how to handle a lot of connections [message #221272] Mon, 26 February 2007 01:31 Go to next message
Messages: 2
Registered: November 2006
Junior Member

I like to know how I can handle about 2000 database connections with oracle and OCCI or better with OTL. if we have more than 100 connections we get an error too many connections. I read about ConnectionPooling and OCCI but stil having problems if there are too many connections. is there a url where I can find more information about this,

What is the best way to handle a lot of connections. Each connections needs its own commit / rollback.

thanks a lot

Re: how to handle a lot of connections [message #221331 is a reply to message #221272] Mon, 26 February 2007 06:04 Go to previous message
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

About connection pooling -> link

Where you can set a number of attributes to control the connections.

Good Luck
Previous Topic: Visual Basic 6 DLL + OCI
Next Topic: Retrive muiltpile colums
Goto Forum:

Current Time: Thu Aug 18 12:03:38 CDT 2022