Re: still not clear with connection pooling in tomcat

Hi I also struggled for the Tomcat Connection Pooling problem for one week and i got the solution. write the follwing code snippets in respective files: -web.xml-- resource-ref res-ref-namejdbc/TestDB/res-ref-name

Re: still not clear with connection pooling in tomcat

hello Mr. Ajay Kumar, thanks a lot. I am using tomcat 5.0.25 and I have the context file in the conf/Catalina/localhost directory. in that file where should I put the code u provided in server.xml after the tag is over or before the tag is closed? thanks Krishnakant. Send instant messages to your

Re: still not clear with connection pooling in tomcat

thanks a lot doug, if I have any problem I will trouble again. just a couple of questions. there were two parameters in the email you sent the other day. I did not get the meaning of those parameters stating that active connections should be 100 and the other with 30 as the value. what is the

Re: still not clear with connection pooling in tomcat

thanks doug. I got my application right. only one problem remains. where do I initialise the connection. and what should I do in the init method of the servlet. or is it that I wont need to use the init method at all? thanks again Krishnakant. Send instant messages to your online friends

Re: still not clear with connection pooling in tomcat

Since the Conn method is static you do not need to initialize it. The DBUtil class actually handles all that for you. Just send your query string to the method there and get back the instance of the data results class. No init needed. Doug - Original Message - From: Krishnakant Mane

Re: still not clear with connection pooling in tomcat

never mind doug, in fact it seams that your asking questions reflects nothing but professionalism and perfection. that's the way to do it. by the way the relation to databases is one to one with web apps. one web app is going to refer to only one database. so that is the way it is going to be.

Re: still not clear with connection pooling in tomcat

No problem. With a one to one, set up the dataresource in the context element of the app. Place this after your context element. You will need to either declare one in the server.xml, in your app war file or create a file yourapp.xml and place it in the Tomcat dir:

Re: still not clear with connection pooling in tomcat

hello doug, I will be using this tomcat server for many web applications. and yes the mysql instance will be the same. I just run one mysqld instance for my server. there will be different databases and different web applications. thanks Krishnakant. Send instant messages to your online friends

Re: still not clear with connection pooling in tomcat

I hate to keep asking questions, but I want to make sure to give you the correct setup. Other wise you will have to change it later on. Let's say you have three databases: data1 data2 data3 And three apps: app1 app2 app3 If app1 hits data1 and app2 hits data2 and . You are on a one to one

Re: still not clear with connection pooling in tomcat

hello doug, I am sending the following details on the questions you asked. and thanks for your help. I am using mysql as the database back-end and tomcat version 5. I have the mysql jdbc the latest stable version. and the server is right now going to support a single application but I plan to

Re: still not clear with connection pooling in tomcat

Because there are different versions, and the setup is different, I need exact version of Tomcat. What was the file name you downloaded? Was it a 5.0.xx or 5.5.x for they are different? Doug - Original Message - From: Krishnakant Mane [EMAIL PROTECTED] To: Tomcat Users List

Re: still not clear with connection pooling in tomcat

doug, thanks again for ur response. Well it is not 5.5. It is 5.0.xx Thanks Krishnakant. Send instant messages to your online friends http://uk.messenger.yahoo.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: still not clear with connection pooling in tomcat

Will more than one of the apps be using the same database? That is the same tables and data? Even if they are using the same database engine IE MySQL on the server, will it be the same database instance? Doug - Original Message - From: Krishnakant Mane [EMAIL PROTECTED] To: Tomcat

RE: still not clear with connection pooling in tomcat

hello all, Thanks for your help on this issue. however I still can't get my problem solved. 10 different articles give 10 different solutions. however my problem is simple. I have a streight forward question. I want to implement connection pooling in the tomcat 5 web container and I have the

Re: still not clear with connection pooling in tomcat

In the beginning a programmer created ... Seriously it goes like this: To use pooling in Tomcat you can forget a lot of what is in the java api as Tomcat uses this to provide pooling for you. Steps to take: 1.Determine the database you are going to use. 2.Get the JDBC drivers for that

RE: still not clear with connection pooling in tomcat

everything you need is here: http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html -Original Message- From: Krishnakant Mane [mailto:[EMAIL PROTECTED] Sent: Sunday, April 03, 2005 7:05 AM To: tomcat-user@jakarta.apache.org Subject: still not clear with