Hi, is this Jerry???? Could I ask you a question, wondering if you are having the same problem as I am..... Im using Tomcat for windows.... The Installer version...... I added my application, went to the Comapny Logon screen, which opens MySql database, updates it, and closes it..... All successfully..... I then go to the User Login screen, which does the same functions as above, open, update, close and on my Open database, I get a 08002 (connection name in use)..... Any subsequent call gives an 08000.....
By backing out to Tomcat manager, stopping and restarting the application, seems to take care of the 08002, but then it reappears right after you do an initial open/close...... Is there anything at all that you are aware of, that Tomcat keeps a resource open????? On my close, I do a COMMIT followed by DISCONNECT ALL...... Im so sorry for bothering you..... What problem were you experiencing? By the way, Im running Servlets...... Do you have any idea what my problem may be, Im totally new to this type of programming, and extremely frustrated, cause my App works fine in CGI format under a different Web Browser, only problem is, CGI is extremely slow...... I need it to work in Servlets.... Thank You Mike ----- Original Message ----- From: "Nelson, Jerry W, Contractor 146CF, SCB" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Friday, August 27, 2004 11:34 AM Subject: RE: Tomcat will not run JSPs > THANK YOU TO ALL OF YOU THAT HELPED. > > I finally took Jakes sugestion. I abandoned the Tomcat EXE and downloaded > the zip file from Jakarta, unzipped it into the Tomcat directory and setup > the environment as all of you had instructed and it FINALLY works, although > it would be nice if I could run the Tomcat service under windows so that DOS > window is not constantly in my task bar. > > Thank you again! > > //SIGNED// > > Jerry Nelson > > > -----Original Message----- > From: Jacob Kjome [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 26, 2004 9:48 PM > To: Tomcat Users List > Subject: RE: Tomcat will not run JSPs > > > Ok, start over. Uninstall Tomcat. Grab the .zip file distribution and > extract it to a directory *without spaces*. Now, change the value of > CATALINA_HOME to the new location of Tomcat. Reboot. The reboot is > sometimes not necessary, but many times it is in order for your environment > variables to be recognized. Just be safe and reboot. > > Now you are ready to run. The question is, which way are you running > it? I suggest running using the startup.bat file. You can create a > shortcut to this on your desktop (same with shutdown.bat) to make things > easier. Since you seem to be a relative newbie to Tomcat (and possibly to > programming???), I don't suggest trying to set up the windows service, > especially since the service.bat currently doesn't include tools.jar in the > classpath and will cause JSP not to compile. Why this hasn't been changed > by the Tomcat developers is beyond me. I've reported it many a time and it > is simply ignored. Baffling! > > Anyway, you should be set to go. Seriously, Tomcat is one of the simplest > apps out there to set up. If you are having trouble, you might want to > take a class of some sort to get up to speed on some of this rather than > banging your head against the wall for as long as you have been. > > Jake > > At 04:44 AM 8/27/2004 +0100, you wrote: > >That didn't work either and I have been researching this for a week, some > >days as many as 10 hours. I've probably spent an entire work week on this > >problem and I am getting really frustrated. > > > >Here are my current envirnment settings: > > > >L:\>echo %java_home% > >C:\j2sdk1.4.2_05 > > > >L:\>echo %catalina_home% > >D:\Program Files\Apache Software Foundation\Tomcat 5.0\webapps\ROOT > > > >It STILL doesn't work! > > > >//SIGNED// > > > >Jerry Nelson > > > > > >-----Original Message----- > >From: Dennis Dai [mailto:[EMAIL PROTECTED] > >Sent: Thursday, August 26, 2004 6:17 PM > >To: Tomcat Users List > >Subject: Re: Tomcat will not run JSPs > > > > > >You need to set %JAVA_HOME% to the installation directory of JDK, Not > >JRE. The JDK is installed in C:\j2sdk1.4.2_05 by default. > > > >I agree with Fredrik that you need to do some more home work by yourself > >since this is fairly basic stuff. > > > >On 8/26/2004 6:01 PM, Nelson, Jerry W, Contractor 146CF, SCB wrote: > > > > > OK, I got the instructions and the homes are set as follows: > > > > > > L:\>echo %JAVA_HOME% > > > C:\Program Files\Java\j2re1.4.2_05\bin\client > > > > > > L:\>ECHO %CATALINA_HOME% > > > D:\Program Files\Apache Software Foundation\Tomcat 5.0 > > > > > > Tomcat STILL can't find javac!!! What's next???? > > > > > > //SIGNED// > > > > > > Jerry Nelson > > > > > > > > > -----Original Message----- > > > From: Fredrik Liden [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, August 26, 2004 5:41 PM > > > To: Tomcat Users List > > > Subject: RE: Tomcat will not run JSPs > > > > > > > > > Go to google: > > > > > > Search for "setting java_home" click the first link in the result link. > > > Follow step-by-step instructions. > > > > > > Once you get passed the step of setting the paths you'll no doubt > > > encounter tons of problems and questions. Make sure to read the basic > > > tutorials and search the archive for the same questions. If you can't > > > find the answer after looking in those two places please feel free to > > > post your questions. > > > > > > Let's keep this list somewhat relevant shall we. > > > > > > Fredrik > > > > > > >-- > >Dennis Dai > >[EMAIL PROTECTED] > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
