Tricky question about "slow" web users and JDBC connections.
843854Nov 12 2001 — edited Nov 15 2001Hi
Well I want to to start web server that works with databases. Now I use Apache->tomcat->jdbc->oracle.
I have JDBC connection pool for every servlet. I wonder what happens if a lot of users connect who have slow internet connections. They will use all the connections from the JDBC connection pool and nobody else will be able to use the server. Do you have any experience dealing with this problem ? If someone will delibertly try to open 1000 connections ? The only solution I see is to make pools capable of holding several hundred connections to mid traffic web server. Can Oracle work with several thousands open connections ?
Andrius