Mike, You may want to post some code and let us take a look. May be the simplest solution to get you going. There is a chance that you are not closing the connection properly and it is being held open. There can also be database issues as well (I think someone mentioned this).
Doug www.parsonstechnical.com ----- Original Message ----- From: "Michael McQuade" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Tuesday, August 31, 2004 9:23 AM Subject: Re: Tomcat Holding Database Open?????? > Please forgive me, I dont even understand a lot of these responses, Im a > mainframe Cobol coder here, not a Java person, but Im using a Converter > that converts Cobol to Java.... Anyways, I am pretty sure it has to be > Tomcat doing this, because my Application ran just fine, using MySQL, > and JDBC driver in a Web Server called OmniCron in CGI format..... > The only thing different now is, Im trying to run SERVLETS using > Apache/Tomcat..... At the Start of each Servlet I do a connect to > database > CONNECT TO 'jdbc:mysql://127.0.0.1:3306/Imagescan' > > DRIVER 'com.mysql.jdbc.Driver' > > Then do my processing and then do a DISCONNECT ALL...... > > It just does not make sense I can connect ONE TIME only when running a > Servlet and have to back out of app, STOP, START, and go back in, to > get another one time connection..... the 08002, connection name in use, > to me, points to Tomcat ...... > > But as I said, Im just a baby in diapers to this world...... I believe its > something in one of the .xml files, but I have no idea..... > > As for Connection Pooling, is that for a system taking large numbers of > hits on it????? Right now, Im just one guy trying to make one connection > work..... > > Thank you for being patient..... > > Mike > > > > > > " <[EMAIL PROTECTED]> > > To: "Tomcat Users List" <[EMAIL PROTECTED]> > Sent: Tuesday, August 31, 2004 8:55 AM > Subject: Re: Tomcat Holding Database Open?????? > > > > On Tue, Aug 31, 2004 at 08:43:00AM -0400, Michael McQuade wrote: > > : 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..... > > > > A couple of questions: > > are you explicitly closing those DB connections? > > are you pooling your connections? > > > > -QM > > > > -- > > > > software -- http://www.brandxdev.net > > tech news -- http://www.RoarNetworX.com > > > > > > --------------------------------------------------------------------- > > 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]