Hi folks, I have alreadysent a similar request, here I am going to try and explain it better..... First, my system setup Tomcat 5.0.27 JVM 1.4.2_05-b04 from Sun Windows 2000 and Windows 2000 Server MySql 4.1.3b-beta-nt JDBC Mysql-connector-java-3.0.11-stable-bin.jar
I have written an application, that works fine running under CGI (in another Web Server) .... Only problem is, its far too slow in CGI. I installed Tomcat using the Windows Installer version, apeears to have installed fine.... I loaded my application..... the first page of my app, the HTML calling page has 2 options, a Company Login and a User Login.... I go to the company login screen, enter the info, the database opens, updates, and closes all with SQLSTATE = 00000..... I then try to go to my USER Login screen and my database opens with an SQLSTATE = 08002 (connection name in use) and any subsequent attept to access the database reults in an SQLSTATE = 08000.... NOW, if I back out to Tomcat App Manager, stop the application, and restart it, I can go back in and get the onetime connection stated above, then the 08002 scenario repeats..... It appears to me, and god knows Im REAL knew to this world, that Tomcat is somehow holding my database open...... not releasing it on DISCONNECT..... DOES anyone have any idea, I have been at this for a week, day and night, to no avail...... Im desperate for some sound guidance..... Thank you for anyone who can help me, and all those that have patience with me..... Mike
