I got this jsp web site and i am using poolman to divide out the connections..and lately i am testing the stability of the db and web server..and so i tried to bomb my web site with lots of retrieves and insertions to the database.
And sometime after...there seems to be a lock to db. Meaning all requests to access the db from my jsp pages are denied. There is no error message given at all...the page will just stuck there...until time out.
But when this lock happens, i am actually still able to perform all sql commands through other ways other then through web.
Anyone ever encounter this problem and can anyone advise me on this issue?