Wednesday, March 7, 2012

Cocurrency

In a web application I am receiving following error message while trying to do the same database query from multiple sessions simultaneouslly. "The Connection is already open (state = connecting)." This only happens for simultaneous hits. Is it a common scenario of cocurrency or I am getting something unusual here? If its a common issue what should be the workaround?

TIA

Hemangyou should NEVER be trying to share an established connection.

each user/request should create its own connection object for accessing the db.|||Hi,

I already took care of not sharring the connection.

Anyways I found where the error was. It was just a programming error somewhere along the lines, it was nothing related to concurrency but i found it while testing it and so i missunderstood that. I fixed that up. Thanks for your interest and prompt reply.

Hemang

No comments:

Post a Comment