Sorry folks, this is a REAL Newbie to Tomcat/Java..... Im trying to understand Connection Pooling as it seems I will need this in my webapp.... Please dont laugh too hard at me ok....
When doing connection Pooling, do you do an Open and close of your database for every Java class (servlet) you execute? Or Do you do a one time Open of your database at the first login? Or Do you just do an Open Database and NOT a CLOSE database for each Java Class (servlet)? I know this sounds stupid, but Im currently NOT using Connection Pooling, and when I go into my first Java class (servlet), I can OPEN/UPDATE all successfully, but when I do a Disconnect I get an SQLSTATE = 08003 (connection does not exist) I then try and go into my next Java Class (servlet) and right away, on my OPEN, I get SQLSTATE = 08002 (connection name in use) It will never allow to access my database again, I have to go back to Application Manager, Stop and then Start the application, go back into it, and I get my one connection again, but just the one..... Thanks Mike
