sounds to me like you aren't using connection pooling. Rather, you are opening a connection each time, but not fully closing the connection. Additionally, your database is probably set to only support 1 connection for this particular user at a time. You might want to check into allowing more connections and using connection pooling so that they stay open constantly so it isn't so expensive to use them.
Jake
At 12:00 PM 8/29/2004 -0400, you wrote:
Sorry to bother you again Jacob..... But heres what I have found out, first time into a program, the database opens, updates and closes all with a Status of 0 and 00000....... Enter another program, and the database opens with a Status of SqlCode = -1 and SqlState = 08002 (connection name in Use)..... And then, any other attempt to access database results in -1 and 08000 thereafter..... 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.....
Mike
----- Original Message ----- From: "Jacob Kjome" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Friday, August 27, 2004 12:46 PM Subject: RE: Tomcat will not run JSPs
> Quoting "Nelson, Jerry W, Contractor 146CF, SCB" <[EMAIL PROTECTED]>: > > > In the envorinment settings they are capitalized, it's just the way I typed > > the echo command. > > > > I also tried the %CATALINA_HOME% pointing to where you said, it didn't work > > either. > > > > Cheerfully waiting for more suggestions... > > > > And to Jake, Apache-Tomcat (Jakarta Project) version 5.0.27 (the one I'm > > running) does run under a server service and it has an installer to set > > everything up for you (supposedly) > > > > And what I'm telling you is that: > > 1. Don't bother with the installer. I've never seen anything but trouble with it. > > 2. The installer doesn't do much more than what you can do more simply with the > zip file. Just a couple extra manual steps that everyone should do anyway > (setting up the system vars) > > 3. The service that gets installed doesn't have tools.jar in the classpath (at > least with service.bat). You'll have to add that before JSP's will be compiled > properly. Please do what I recommended. Start up Tomcat with the startup.bat > and see if it works. If it does, then the problem is the service. If you > refuse to try this, then you won't be able to narrow down your issue. > > Sorry, but that's all the help I can provide. If you ignore the advice I've > given you so far, you are on your own. > > Jake > > > > //SIGNED// > > > > Jerry Nelson > > > > > > -----Original Message----- > > From: Dennis Dai [mailto:[EMAIL PROTECTED] > > Sent: Thursday, August 26, 2004 10:10 PM > > To: Tomcat Users List > > Subject: Re: Tomcat will not run JSPs > > > > > > Of course it will not work! > > > > First, I believe the environment variables need to be CAPITALIZED, as in > > %JAVA_HOME% and %CATALINA_HOME%. > > > > Second, your %CATALINA_HOME% is pointing to the wrong place. It should > > be the root of tomcat installation (ie., "D:\Program Files\Apache > > Software Foundation\Tomcat 5.0"), not webapps\ROOT. > > > > On 8/26/2004 8:44 PM, Nelson, Jerry W, Contractor 146CF, SCB 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]
