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
jjdenboer
Messages: 2
Registered: November 2006
Junior Member
Hi,

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

John

Report message to a moderator

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
tahpush
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 02 16:35:26 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.