Tomcat Connection Pooling - Future of?

[Pete Steijn]

Greetings,

I am a student at the University of Delaware looking to do research on 
connection pooling.

Currently I am analyzing the feasability of optimizing connection pooling. 
My hypothesis is that using a statistical analysis of the usage history to 
create a prediction of usage levels in the future, and adjusting the 
connection pool's settings based on usage level predictions will increase 
the throughput and decrease system requirements for websites with trends in 
user levels.

does anyone know of any research that has been done / currently being done 
on this topic?

Sincerely,
Peter K. Steijn

Tomcat Connection Pooling

[Cumbers]

Hey
I have within my server.xml the following:


  
factory
org.apache.commons.dbcp.BasicDataSourceFactory
  
  
driverClassName
org.postgresql.Driver
  
  
url
jdbc:postgresql://penguin.kent.ac.uk:5432/rms_dev
  
  
username
rms_dev
  
  
password
isi5gi
  
  
maxActive
20
  
  
maxIdle
10
  
  
maxWait
-1
  

And I also have the relevant ResourceLink information to get this 
working. And it does work within my web application.

However I want to ensure that this is actually a connection pool. I want 
to test to see how many connections are in the pool, is there a way? Or 
can someone tell me for sure if I have set connection pooling up?

Thanks
Rich
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[OFF-TOPIC]Yoav --> RE: Some pretty basic Tomcat Connection Pooling Questions????

[Luke (Terry) Vanderfluit]

Hi Yoav and all,
> - Hold the connection for as little a time as possible.  That is, get it
> from the pool, use it, and return it to the pool as soon as possible.
> - That means you don't get the connection in a servlet init() method and
> return it in a destroy() method.  That's too long a time to hold
> connections usually.
> - Always return connections to the pool.  Typically, this is done in the
> finally clause of a try/catch block to ensure it is executed even if the
> JDBC operation fails.
> - You create your pool once, preferably when the app starts up, and you
> close the pool itself once, preferably when the app shuts down.  A
> ServletContextListener is good for this purpose.  Make sure you close
> the pool.
> - Servlets and other classes use the pool as needed.  You don't have to
> use a one connection per servlet design (in fact those usually don't
> work in the real world).

I've been using connection pooling via an init() method.
Above you say that one should avoid that.
So now I have put the connection code inside the method that actually
does the database work and dispensed with the init() method.

Before I made this change I didn't have a conn.close() statement or a
finally clause anywhere either (I DID have resultset.close and
statement.close()).
Now I have added a conn.close() statement after each database
interaction has been completed. 

Both versions of the code work. 
Would you say the it is optimised after having gotten rid of the init()
method?

this is the code in it's latter version:
~~~
  try {   //establish the connection
 Context ctx = new InitialContext();
 if(ctx == null) {
throw new Exception("No Context");
}
 DataSource ds =
(DataSource)ctx.lookup("java:comp/env/jdbc/mb");
 if(ds != null) {
conn = ds.getConnection(); //conn is a global variable
if(conn != null) {
   message = "Got Connection to DB " + conn.toString();
   }
}
 } // end try block
  catch(Exception e) {
 e.printStackTrace();
 }
  try {  //carry out the database query
 Statement stmt = conn.createStatement();
 ResultSet rst = stmt.executeQuery("select * from category where
categoryname not like '%Timetable%';");
 while(rst.next()) {
Category c  = new Category();
c.setCategoryName(rst.getString("categoryname"));
clBean.addCategory(c);
} // end while block
 rst.close();
 stmt.close();
 conn.close();
 } // end try block
  catch(Exception e) {
 }
~~

Appreciate your help,
kind regards,
Luke

-- 

Luke (Terry) Vanderfluit 
Mobile: 0421 276 282 



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: OFF TOPIC: Some pretty basic Tomcat Connection Pooling Questions????

[Shapira, Yoav]

Hi,
Your application is not started when you log into it.  It's started when
the server is started.  That's when a connection pool should be created.

You don't hold the connection as long as the user is logged in.  You
just use the connection to authenticate the user and then release the
connection back to the pool.

Most books in this area are user-friendly, as they are target at novice
programmers.  You don't even have to buy a book, either.  Take a look at
something like
http://www.javaperformancetuning.com/tips/jdbcconnpool.shtml, which has
many of these principles explained.

Yoav Shapira
Millennium Research Informatics


>-Original Message-
>From: Michael McQuade [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, September 08, 2004 9:42 AM
>To: Tomcat Users List
>Subject: Re:OFF TOPIC: Some pretty basic Tomcat Connection Pooling
>Questions
>
>Ok Yoav,  so as I understand it,   I open up my application say in the
>morning,  by logging in my company..  I do not close the connection
to
>my database  Now any number of users can log into it,  as they
login
>(servlet) I do not need to open and close my database to update
it??
>this user may sit all day logged in, you say the connection needs
to be
>returned to the pool? Throughout the day, that user may access the
>database at anytime.
>Im really sorry,   this is all new to me and Im trying to get a handle
on
>it
>in plain English from people who are experienced,  not all the
technical
>terms you get from a manual. Im desperate for help and fast running
out
>of time to get it.. I have put Connection Pooling into Tomcat thru
the
>Server.xml and Web.xml,   per the examples from Tomcat documentation,
but
>HOW  do I know it is really turned on and working
>Currently my application does a Connect and Disconnect each time a
>Program/servlet is executed..  But this isnt working,  I get an
08002
>(connection name in use) SqlState the second time I try to connect.
>When I remove the Connect/Disconnect from all my other servlets,   I
get an
>SqlState 08000 (connection exception) the first time I try to access
the
>database
>
>Please forgive me for being so stupid, Im just looking for someone that
can
>give me some guidance here.. If anyone from the User group would be
>willing to talk in private,  so as not to disturb others in the group
with
>my asking for help, I would welcome that also
>
>Mike
>[EMAIL PROTECTED]
>905-985-3438
>
>
>- Original Message -
>From: "Shapira, Yoav" <[EMAIL PROTECTED]>
>To: "Tomcat Users List" <[EMAIL PROTECTED]>
>Sent: Wednesday, September 08, 2004 8:44 AM
>Subject: RE: Some pretty basic Tomcat Connection Pooling Questions
>
>
>
>Hi,
>You might want to get a book on good Java design practices.  The basic
>ideas are there:
>- Hold the connection for as little a time as possible.  That is, get
it
>from the pool, use it, and return it to the pool as soon as possible.
>- That means you don't get the connection in a servlet init() method
and
>return it in a destroy() method.  That's too long a time to hold
>connections usually.
>- Always return connections to the pool.  Typically, this is done in
the
>finally clause of a try/catch block to ensure it is executed even if
the
>JDBC operation fails.
>- You create your pool once, preferably when the app starts up, and you
>close the pool itself once, preferably when the app shuts down.  A
>ServletContextListener is good for this purpose.  Make sure you close
>the pool.
>- Servlets and other classes use the pool as needed.  You don't have to
>use a one connection per servlet design (in fact those usually don't
>work in the real world).
>
>In the future, please mark non-Tomcat questions with [OFF-TOPIC] in the
>subject line.  And again, consider getting a Java design practices
book:
>practically all of them have a chapter on JDBC connection pooling with
>the above suggestions.
>
>Yoav Shapira
>Millennium Research Informatics
>
>
>>-Original Message-
>>From: Michael McQuade [mailto:[EMAIL PROTECTED]
>>Sent: Tuesday, September 07, 2004 9:06 PM
>>To: Tomcat Users List
>>Subject: Some pretty basic Tomcat Connection Pooling Questions
>>
>>Sorry folks,   this is a REAL Newbie to Tomcat/Java.  Im trying to
>>understand Connection Pooling as it seems I will need this in my
>webapp
>>Please dont laugh too hard at me ok
>>
>>When doing connection Pooling,do you do an Open and close of your
>>database for every Java class (servlet) you execute?
>>
>>Or
>>
>>Do you do a one time Open of your database at the first login?
&g

Re:OFF TOPIC: Some pretty basic Tomcat Connection Pooling Questions????

[Michael McQuade]

Ok Yoav,  so as I understand it,   I open up my application say in the
morning,  by logging in my company..  I do not close the connection to
my database  Now any number of users can log into it,  as they login
(servlet) I do not need to open and close my database to update it??
this user may sit all day logged in, you say the connection needs to be
returned to the pool? Throughout the day, that user may access the
database at anytime.
Im really sorry,   this is all new to me and Im trying to get a handle on it
in plain English from people who are experienced,  not all the technical
terms you get from a manual. Im desperate for help and fast running out
of time to get it.. I have put Connection Pooling into Tomcat thru the
Server.xml and Web.xml,   per the examples from Tomcat documentation,  but
HOW  do I know it is really turned on and working
Currently my application does a Connect and Disconnect each time a
Program/servlet is executed..  But this isnt working,  I get an 08002
(connection name in use) SqlState the second time I try to connect.
When I remove the Connect/Disconnect from all my other servlets,   I get an
SqlState 08000 (connection exception) the first time I try to access the
database

Please forgive me for being so stupid, Im just looking for someone that can
give me some guidance here.. If anyone from the User group would be
willing to talk in private,  so as not to disturb others in the group with
my asking for help, I would welcome that also

Mike
[EMAIL PROTECTED]
905-985-3438


- Original Message - 
From: "Shapira, Yoav" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Wednesday, September 08, 2004 8:44 AM
Subject: RE: Some pretty basic Tomcat Connection Pooling Questions



Hi,
You might want to get a book on good Java design practices.  The basic
ideas are there:
- Hold the connection for as little a time as possible.  That is, get it
from the pool, use it, and return it to the pool as soon as possible.
- That means you don't get the connection in a servlet init() method and
return it in a destroy() method.  That's too long a time to hold
connections usually.
- Always return connections to the pool.  Typically, this is done in the
finally clause of a try/catch block to ensure it is executed even if the
JDBC operation fails.
- You create your pool once, preferably when the app starts up, and you
close the pool itself once, preferably when the app shuts down.  A
ServletContextListener is good for this purpose.  Make sure you close
the pool.
- Servlets and other classes use the pool as needed.  You don't have to
use a one connection per servlet design (in fact those usually don't
work in the real world).

In the future, please mark non-Tomcat questions with [OFF-TOPIC] in the
subject line.  And again, consider getting a Java design practices book:
practically all of them have a chapter on JDBC connection pooling with
the above suggestions.

Yoav Shapira
Millennium Research Informatics


>-Original Message-
>From: Michael McQuade [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, September 07, 2004 9:06 PM
>To: Tomcat Users List
>Subject: Some pretty basic Tomcat Connection Pooling Questions
>
>Sorry folks,   this is a REAL Newbie to Tomcat/Java.  Im trying to
>understand Connection Pooling as it seems I will need this in my
webapp
>Please dont laugh too hard at me ok
>
>When doing connection Pooling,do you do an Open and close of your
>database for every Java class (servlet) you execute?
>
>Or
>
>Do you do a one time Open of your database at the first login?
>
>Or
>
>Do you just do an Open Database and NOT a CLOSE database for each Java
>Class (servlet)?
>
>I know this sounds stupid,   but Im currently NOT using Connection
Pooling,
>and when I  go into my first Java class (servlet),  I can OPEN/UPDATE
all
>successfully,   but when I do a Disconnect I get an SQLSTATE = 08003
>(connection does not exist)
>I then try and go into my next Java Class  (servlet) and right away,
on
>my OPEN, I get SQLSTATE = 08002 (connection name in use)
>
>It will never allow to access my database again, I have to go back to
>Application Manager,  Stop and then Start the application,   go back
into
>it,  and I get my one connection again,  but just the one.
>
>Thanks Mike



This e-mail, including any attachments, is a confidential business
communication, and may contain information that is confidential, proprietary
and/or privileged.  This e-mail is intended only for the individual(s) to
whom it is addressed, and may not be saved, copied, printed, disclosed or
used by anyone else.  If you are not the(an) intended recipient, please
immediately delete this e-mail from your computer system and notify the
sender.  Thank you.


---

RE: Some pretty basic Tomcat Connection Pooling Questions????

[Shapira, Yoav]

Hi,
You might want to get a book on good Java design practices.  The basic
ideas are there:
- Hold the connection for as little a time as possible.  That is, get it
from the pool, use it, and return it to the pool as soon as possible.
- That means you don't get the connection in a servlet init() method and
return it in a destroy() method.  That's too long a time to hold
connections usually.
- Always return connections to the pool.  Typically, this is done in the
finally clause of a try/catch block to ensure it is executed even if the
JDBC operation fails.
- You create your pool once, preferably when the app starts up, and you
close the pool itself once, preferably when the app shuts down.  A
ServletContextListener is good for this purpose.  Make sure you close
the pool.
- Servlets and other classes use the pool as needed.  You don't have to
use a one connection per servlet design (in fact those usually don't
work in the real world).

In the future, please mark non-Tomcat questions with [OFF-TOPIC] in the
subject line.  And again, consider getting a Java design practices book:
practically all of them have a chapter on JDBC connection pooling with
the above suggestions.

Yoav Shapira
Millennium Research Informatics


>-Original Message-
>From: Michael McQuade [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, September 07, 2004 9:06 PM
>To: Tomcat Users List
>Subject: Some pretty basic Tomcat Connection Pooling Questions
>
>Sorry folks,   this is a REAL Newbie to Tomcat/Java.  Im trying to
>understand Connection Pooling as it seems I will need this in my
webapp
>Please dont laugh too hard at me ok
>
>When doing connection Pooling,do you do an Open and close of your
>database for every Java class (servlet) you execute?
>
>Or
>
>Do you do a one time Open of your database at the first login?
>
>Or
>
>Do you just do an Open Database and NOT a CLOSE database for each Java
>Class (servlet)?
>
>I know this sounds stupid,   but Im currently NOT using Connection
Pooling,
>and when I  go into my first Java class (servlet),  I can OPEN/UPDATE
all
>successfully,   but when I do a Disconnect I get an SQLSTATE = 08003
>(connection does not exist)
>I then try and go into my next Java Class  (servlet) and right away,
on
>my OPEN, I get SQLSTATE = 08002 (connection name in use)
>
>It will never allow to access my database again, I have to go back to
>Application Manager,  Stop and then Start the application,   go back
into
>it,  and I get my one connection again,  but just the one.
>
>Thanks Mike



This e-mail, including any attachments, is a confidential business communication, and 
may contain information that is confidential, proprietary and/or privileged.  This 
e-mail is intended only for the individual(s) to whom it is addressed, and may not be 
saved, copied, printed, disclosed or used by anyone else.  If you are not the(an) 
intended recipient, please immediately delete this e-mail from your computer system 
and notify the sender.  Thank you.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Some pretty basic Tomcat Connection Pooling Questions????

[Michael McQuade]

Sorry folks,   this is a REAL Newbie to Tomcat/Java.  Im trying to understand 
Connection Pooling as it seems I will need this in my webapp  Please dont laugh 
too hard at me ok

When doing connection Pooling,do you do an Open and close of your database for 
every Java class (servlet) you execute?

Or

Do you do a one time Open of your database at the first login?

Or

Do you just do an Open Database and NOT a CLOSE database for each Java Class (servlet)?

I know this sounds stupid,   but Im currently NOT using Connection Pooling,  and when 
I  go into my first Java class (servlet),  I can OPEN/UPDATE all successfully,   but 
when I do a Disconnect I get an SQLSTATE = 08003 (connection does not exist)
I then try and go into my next Java Class  (servlet) and right away,   on my OPEN, I 
get SQLSTATE = 08002 (connection name in use)

It will never allow to access my database again, I have to go back to Application 
Manager,  Stop and then Start the application,   go back into it,  and I get my one 
connection again,  but just the one.

Thanks Mike

tomcat connection pooling

[Ponnam Janiki]

Hi Guys,

I don’t know is it the right place to ask this question. If not plz forgive
me and direct me to the right place.

 

I have been struggling for the past two weeks to create a connection pool in
Tomcat 4.x/Tomcat 5.x.

Actually my environment is, Windows XP professional,  j2sdk1.4.2_04, Tomcat
5.0.19 and Oracle 8.1.7. I configured 

server.xml and web.xml as per the documentation you provided in Apache.org.
But I’m getting the 

following error…

SQLException Occured org.apache.commons.dbcp.SQLNestedException: Cannot
create J

DBC driver of class '' for connect URL 'null', cause: null.

NO Suitable driver. I tried all the drivers that are available at Oracle
site and I dropped the jar file in 

common\lib directory but of no use. And I tried many ways that are found by
google search.

Please help me out in solving this problem.

Here are the related files….

Server.xml





 



 



 

 

  

  

  

  

 

  

  

 





 









  

factory

org.apache.catalina.users.MemoryUserDatabaseFactory

  

  

pathname

conf/tomcat-users.xml

  



 

  

 

  

 

  

  

 



 











 





 





 







 



 

 

 





 

  

  

 

  

  

 

  

 

  

  

 

  

   

 

  

 

  

 

 

  

 

  

  

 

 







 

 

 





 





 





 

  

  

  



  



  

  

  

user

  

pricing2_admin

  

  

  

  

  

password

  

pricing2_admin

  

  

  

  

  

driverClassName

  

oracle.jdbc.driver.OracleDriver

  

  

  

  

  

url

  

jdbc:oracle:thin:@sunburst:1521:prcdev

  

  

  



   

 



 

  

 



Web.xml



http://java.sun.com/dtd/web-app_2_3.dtd";>



  Empty web.xml file for Web Application

  

Controller

bean.Controller

  

  

Controller

/Controller

  

  

35

  

  

html

text/html

  

  

txt

text/plain

  

  

index.jsp

index.html

  



 

  

 

Resource reference to a factory for java.sql.Connection

 

instances that may be used for talking to a particular

 

database that is configured in the server.xml file.

 

  

 

  

 

jdbc/EmployeeDB

 

  

 

  

 

javax.sql.DataSource

 

  

 

  

 

Container

 

  

 





Code that I use to get the connection

InitialContext jndiCntx = new InitialContext();  

Context ctx=(Context)jndiCntx.lookup("java:comp/env");

System.out.println("Looking up jdbc/EmployeeDB");

 DataSource ds =
(javax.sql.DataSource)ctx.lookup("jdbc/EmployeeDB");

 

//System.out.println("Got the DataSource..."+ds);

Connection conn =ds.getConnection();

Its getting executed till displaying the ‘DataSource’

Getting the above error at line 

Connection  conn =ds.getConnection();

Please let me know the solution.

 

 

Thanks

Ram


-Original Message-
From: Filip Hanik - Dev [mailto:[EMAIL PROTECTED] 
Sent: Monday, May 10, 2004 8:43 AM
To: Tomcat Users List
Subject: Re: tomcat clustering

Caused by: java.io.NotSerializableException:


- Original Message -
From: "keita elhadji" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 10, 2004 4:52 AM
Subject: tomcat clustering


Hi,

i have a problem with mod_jk2 .
I have two PC  with tomcat5.019
1st PC name is : www.avisdunet.biz
2nd PC name is : www1.avisdunet.biz

mod_jk2 and apache2 in the first when i start tomcat
my clustering didn't work and i don't know why and in
my logs catalina.out :

10 mai 2004 11:30:15
org.apache.coyote.http11.Http11Protocol init
INFO: Initialisation de Coyote HTTP/1.1 sur le port
8080
10 mai 2004 11:30:17
org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 48211 ms
10 mai 2004 11:30:22
org.apache.catalina.core.StandardService start
INFO: Démarrage du service Catalina
10 mai 2004 11:30:22
org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.0.19
10 mai 2004 11:30:23
org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
10 mai 2004 11:30:23
org.apache.catalina.cluster.tcp.SimpleTcpCluster start
INFO: Cluster is about to start
10 mai 2004 11:30:24
org.apache.catalina.cluster.mcast.McastService start
INFO: Sleeping for 2000 secs to establish cluster
membership
10 mai 2004 11:30:26
org.apache.catalina.core.StandardHost getDeployer
INFO: Create Host deployer for direct deployment (
non-jmx )
10 mai 2004 11:30:27
org.apache.catalina.co

Re: Tomcat Connection Pooling Question

[p200002]

try -1
- Original Message -
From: "Nicholas Orr" <[EMAIL PROTECTED]>
To: "Tomcat Mailing List" <[EMAIL PROTECTED]>
Sent: Sunday, October 27, 2002 7:39 PM
Subject: Tomcat Connection Pooling Question


> Hi,
>
> Is there a way to make the maxWait to just wait till there is an available
> connection??
>
> Thanks
>
> Nicholas Orr
>
>
> **
> The information contained in this e-mail is confidential and is
> intended only for the use of the addressee(s).
> If you receive this e-mail in error, any use, distribution or
> copying of this e-mail is not permitted. You are requested to
> forward unwanted e-mail and address any problems to the
> MIM Holdings Limited Support Centre.
>
> For general enquires: ++61 7 3833 8000
> Support Centre e-mail: [EMAIL PROTECTED]
> Support Centre phone:  Australia 1800500646
> International ++61 7 38338042
> **
>
>
> --
> To unsubscribe, e-mail:
<mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
> For additional commands, e-mail:
<mailto:tomcat-user-help@;jakarta.apache.org>
>

--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>

Tomcat Connection Pooling Question

[Nicholas Orr]

Hi,

Is there a way to make the maxWait to just wait till there is an available
connection??

Thanks 

Nicholas Orr 


**
The information contained in this e-mail is confidential and is
intended only for the use of the addressee(s).
If you receive this e-mail in error, any use, distribution or
copying of this e-mail is not permitted. You are requested to
forward unwanted e-mail and address any problems to the
MIM Holdings Limited Support Centre.

For general enquires:   ++61 7 3833 8000
Support Centre e-mail:  [EMAIL PROTECTED]
Support Centre phone:   Australia 1800500646
International ++61 7 38338042
**


--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

RE: Tomcat Connection Pooling

[garrett smith]

It's on the tomcat page under documentation. click on tomcat 4.0

here:
http://jakarta.apache.org/tomcat/tomcat-4.0-doc/index.html

It's basically the same, but you have to download all the jars, so more work to
set up.

--- Lior Shliechkorn <[EMAIL PROTECTED]> wrote:
> 
> Is this feature is not available for tomcat 4.0.5?
>  "Steltner, Jorn HTC/DE/ESS" <[EMAIL PROTECTED]> wrote:Have a look
> at
> http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how
> to.html
> 
> -Original Message-
> From: Lior Shliechkorn [mailto:liorshliech@;yahoo.com]
> Sent: Dienstag, 22. Oktober 2002 16:55
> To: Tomcat
> Subject: Tomcat Connection Pooling
> 
> 
> 
> Can someone please send me a link for reading information about Tomcat
> connection pooling?
> 
> Thanks,
> 
> lior
> 
> 
> 
> -
> Do you Yahoo!?
> Y! Web Hosting - Let the expert host your web site
> 
> --
> To unsubscribe, e-mail: 
> For additional commands, e-mail: 
> 
> 
> 
> -
> Do you Yahoo!?
> Y! Web Hosting - Let the expert host your web site


=
Garrett Needs A Job

__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/

--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>

Re: Tomcat Connection Pooling

[Kwok Peng Tuck]

It is available.

Lior Shliechkorn wrote:


Is this feature is not available for tomcat 4.0.5?
"Steltner, Jorn HTC/DE/ESS" <[EMAIL PROTECTED]> wrote:Have a look at
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how
to.html

-Original Message-
From: Lior Shliechkorn [mailto:liorshliech@;yahoo.com]
Sent: Dienstag, 22. Oktober 2002 16:55
To: Tomcat
Subject: Tomcat Connection Pooling



Can someone please send me a link for reading information about Tomcat
connection pooling?

Thanks,

lior



-
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site

--
To unsubscribe, e-mail: 
For additional commands, e-mail: 



-
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
 




--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>

RE: Tomcat Connection Pooling

[Lior Shliechkorn]

Is this feature is not available for tomcat 4.0.5?
 "Steltner, Jorn HTC/DE/ESS" <[EMAIL PROTECTED]> wrote:Have a look at
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how
to.html

-Original Message-
From: Lior Shliechkorn [mailto:liorshliech@;yahoo.com]
Sent: Dienstag, 22. Oktober 2002 16:55
To: Tomcat
Subject: Tomcat Connection Pooling



Can someone please send me a link for reading information about Tomcat
connection pooling?

Thanks,

lior



-
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site

--
To unsubscribe, e-mail: 
For additional commands, e-mail: 



-
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site

RE: Tomcat Connection Pooling

[Steltner, Jorn HTC/DE/ESS]

Have a look at
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how
to.html

-Original Message-
From: Lior Shliechkorn [mailto:liorshliech@;yahoo.com]
Sent: Dienstag, 22. Oktober 2002 16:55
To: Tomcat
Subject: Tomcat Connection Pooling



Can someone please send me a link for reading information about Tomcat
connection pooling?

Thanks,

lior



-
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site

--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>

Tomcat Connection Pooling

[Lior Shliechkorn]

Can someone please send me a link for reading information about Tomcat connection 
pooling?

Thanks,

lior



-
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site

Re: Tomcat Connection Pooling

[echambe1]

Mark:

I came across the same problem, of sort. If you are using connection
pooling,
you cannot change the user and database you are connected to at
run time.

This just defeats the purpose of database connection pooling. You want to
setup
a predifined number of open connections to your database that your
application
will utilize. So, when Tomcat starts up, your database connections are
already
established and opened, hence you cannot specify a new user or database
to connect to.

If you are needing to specify the above mentioned items, then I would
suggest
database connection pooling is not for you.

Hope this helps,
Ej




"Mark Lenz" <[EMAIL PROTECTED]> on 10/18/2002 12:46:23 PM

Please respond to "Tomcat Users List" <[EMAIL PROTECTED]>

To:<[EMAIL PROTECTED]>
cc:

Subject:Re: Tomcat Connection Pooling




When I try that, I get a java.lang.UnsupportedOperationException
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:125)


at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:329)


...
It's thrown during the getConnection(username, password) function.  I tried
including the username and password parameters in the server.xml file
without a value like this:


username



And also completely excluding the username and password parameters.

Mark Lenz
(920) 832-3523
[EMAIL PROTECTED]


  Leo Przybylski
  <[EMAIL PROTECTED]>   To:Tomcat Users List
<[EMAIL PROTECTED]>
cc:
  10/17/2002 05:31 PM   Subject:    Re: Tomcat
  Please respond to "Tomcat Connection Pooling
  Users List"






If you are using multiple databases, I believe you have to set up
multiple "Resources" (one for each database). However, you do not have
to specify a username/password. When you retrieve your DataSource from
the "java:comp/env" namespace, you can use getConnection( username,
password). If you don't use multiple users for the database, then this
may seem impractical.

You do need a different "Resource" definition for each database though.

-Leo
http://www.foopan.ath.cx


On Thu, 2002-10-17 at 14:19, Mark Lenz wrote:
> I'm trying to set up DB Connection Pooling with Tomcat 4.1.12 and MySQL
> 4.0.4.  Looking at the sample xml configs I noticed that you have to
> specify the database, username and password.  Is there a way that I can
> change the username and database from within my JSP's?  Or do I just have

> to create different DB contexts in the server.xml file for each database
I
> want to use and which user I want to connect with?
>
> Mark Lenz
> (920) 832-3523
> [EMAIL PROTECTED]
>
> The information contained in this electronic mail message is confidential
information and intended only for the use of the individual or entity named
above, and may be privileged.  If the reader of this messages is not the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited.  If
you have received this transmission in error, please  contact the sender
immediately, delete this material from your computer and destroy all
related paper media.  Please note that the documents transmitted are not
intended to be binding until a hard copy has been manually signed by all
parties.
> Thank you.


--
To unsubscribe, e-mail:   <
mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <
mailto:tomcat-user-help@;jakarta.apache.org>




The information contained in this electronic mail message is confidential
information and intended only for the use of the individual or entity named
above, and may be privileged. If the reader of this messages is not the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If
you have received this transmission in error, please contact the sender
immediately, delete this material from your computer and destroy all
related paper media. Please note that the documents transmitted are not
intended to be binding until a hard copy has been manually signed by all
parties.
Thank you.



--
To unsubscribe, e-mail:   <
mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <
mailto:tomcat-user-help@;jakarta.apache.org>









**
Confidentiality Notice: This email message, including any attachments, 
contains or may contain confidential information intended only for the 
addressee. If you are not an intended recipient of this message, be 
advised that any reading, dissemination, forwarding, printing, copying
or other use of this message or its

Re: Tomcat Connection Pooling

[Mark Lenz]

When I try that, I get a java.lang.UnsupportedOperationException
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:125)

at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:329)

...
It's thrown during the getConnection(username, password) function.  I tried
including the username and password parameters in the server.xml file
without a value like this:


username



And also completely excluding the username and password parameters.

Mark Lenz
(920) 832-3523
[EMAIL PROTECTED]

 
  Leo Przybylski 
  <[EMAIL PROTECTED]>   To:Tomcat Users List 
<[EMAIL PROTECTED]> 
cc:  
  10/17/2002 05:31 PM   Subject:Re: Tomcat   
  Please respond to "Tomcat Connection Pooling   
  Users List"
 





If you are using multiple databases, I believe you have to set up
multiple "Resources" (one for each database). However, you do not have
to specify a username/password. When you retrieve your DataSource from
the "java:comp/env" namespace, you can use getConnection( username,
password). If you don't use multiple users for the database, then this
may seem impractical.

You do need a different "Resource" definition for each database though.

-Leo
http://www.foopan.ath.cx


On Thu, 2002-10-17 at 14:19, Mark Lenz wrote:
> I'm trying to set up DB Connection Pooling with Tomcat 4.1.12 and MySQL
> 4.0.4.  Looking at the sample xml configs I noticed that you have to
> specify the database, username and password.  Is there a way that I can
> change the username and database from within my JSP's?  Or do I just have

> to create different DB contexts in the server.xml file for each database
I
> want to use and which user I want to connect with?
>
> Mark Lenz
> (920) 832-3523
> [EMAIL PROTECTED]
>
> The information contained in this electronic mail message is confidential
information and intended only for the use of the individual or entity named
above, and may be privileged.  If the reader of this messages is not the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited.  If
you have received this transmission in error, please  contact the sender
immediately, delete this material from your computer and destroy all
related paper media.  Please note that the documents transmitted are not
intended to be binding until a hard copy has been manually signed by all
parties.
> Thank you.


--
To unsubscribe, e-mail:   <
mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <
mailto:tomcat-user-help@;jakarta.apache.org>




The information contained in this electronic mail message is confidential
information and intended only for the use of the individual or entity named
above, and may be privileged. If the reader of this messages is not the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited. If
you have received this transmission in error, please contact the sender
immediately, delete this material from your computer and destroy all
related paper media. Please note that the documents transmitted are not
intended to be binding until a hard copy has been manually signed by all
parties.
Thank you.



--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>

Re: Tomcat Connection Pooling

[Leo Przybylski]

If you are using multiple databases, I believe you have to set up
multiple "Resources" (one for each database). However, you do not have
to specify a username/password. When you retrieve your DataSource from
the "java:comp/env" namespace, you can use getConnection( username,
password). If you don't use multiple users for the database, then this
may seem impractical. 

You do need a different "Resource" definition for each database though.

-Leo
http://www.foopan.ath.cx


On Thu, 2002-10-17 at 14:19, Mark Lenz wrote:
> I'm trying to set up DB Connection Pooling with Tomcat 4.1.12 and MySQL 
> 4.0.4.  Looking at the sample xml configs I noticed that you have to 
> specify the database, username and password.  Is there a way that I can 
> change the username and database from within my JSP's?  Or do I just have 
> to create different DB contexts in the server.xml file for each database I 
> want to use and which user I want to connect with?
> 
> Mark Lenz
> (920) 832-3523
> [EMAIL PROTECTED]
> 
> The information contained in this electronic mail message is confidential 
>information and intended only for the use of the individual or entity named above, 
>and may be privileged.  If the reader of this messages is not the intended recipient, 
>you are hereby notified that any dissemination, distribution or copying of this 
>communication is strictly prohibited.  If you have received this transmission in 
>error, please  contact the sender immediately, delete this material from your 
>computer and destroy all related paper media.  Please note that the documents 
>transmitted are not intended to be binding until a hard copy has been manually signed 
>by all parties.
> Thank you.


--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

Tomcat Connection Pooling

[Mark Lenz]

I'm trying to set up DB Connection Pooling with Tomcat 4.1.12 and MySQL
4.0.4.  Looking at the sample xml configs I noticed that you have to
specify the database, username and password.  Is there a way that I can
change the username and database from within my JSP's?  Or do I just have
to create different DB contexts in the server.xml file for each database I
want to use and which user I want to connect with?

Mark Lenz
(920) 832-3523
[EMAIL PROTECTED]

The information contained in this electronic mail message is confidential information 
and intended only for the use of the individual or entity named above, and may be 
privileged.  If the reader of this messages is not the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this communication 
is strictly prohibited.  If you have received this transmission in error, please  
contact the sender immediately, delete this material from your computer and destroy 
all related paper media.  Please note that the documents transmitted are not intended 
to be binding until a hard copy has been manually signed by all parties.
Thank you.

Re: Tomcat Connection Pooling

[achana]

Hi.
I am a bit puzzled.
I have been writing JAVA codes to set sup a pool of physical Oracle
connections which can be recycled, so conceivably, 20+ users can share
10 connections.
Now I keep reading messages that one can set up pooling in Tomcat.
How efficient is this in terms of recycling physical db connections for
the next user ?
Isn't is a bit "iffy" to have to embed the username and password ?

--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

RE: Tomcat Connection pooling

[Barney Hamish]

No I'm afraid I don't. I don't use datasources at the moment just the old
vanilla way of creating database connections.

> -Original Message-
> From: Amitabh Dubey [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 23, 2002 4:51 PM
> To: Tomcat Users List
> Subject: RE: Tomcat Connection pooling
> 
> 
> If DBCP is a problem, then do you have a working example of 
> how i can use it
> with PoolMan?
> 
> Amitabh
> 
> -Original Message-
> From: Barney Hamish [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 23, 2002 9:50 AM
> To: 'Tomcat Users List'
> Subject: RE: Tomcat Connection pooling
> 
> 
> Be careful if you decide to use DBCP with SQL Server. I found 
> SQL Server
> drops open connections every 10 minutes or so, even while 
> you're in the
> middle of retrieving query results!!! (so the verify connection thing
> doesn't work) DBCP needs some way of automatically dropping 
> and recreating
> connections (like poolman does) if it's to be used with SQL Server. I
> haven't got around to submitting a patch to the DBCP Commons 
> team to fix
> this.
> 
> Hamish
> 
> > -Original Message-
> > From: Turner, John [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 23, 2002 4:43 PM
> > To: 'Tomcat Users List'
> > Subject: RE: Tomcat Connection pooling
> >
> >
> >
> > I guess some advice is better than none.
> >
> > Have you checked out the Jakarta Commons DBCP pooling 
> solution like I
> > recommended?  Here's a link to how it was done with MySQL:
> >
> > http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2
> >
> > Have you checked out third-party SQL Server drivers?  The 
> drivers I am
> > familiar with have fully-functional trial periods and they
> > not only support
> > pooling but also JDBC 3.0.
> >
> > Have you checked out open source pooling solutions besides 
> DBCP, like
> > poolman?
> >
> > John
> >
> >
> > > -Original Message-
> > > From: Amitabh Dubey [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, September 23, 2002 10:39 AM
> > > To: Tomcat Users List
> > > Subject: RE: Tomcat Connection pooling
> > >
> > >
> > > John, you are the only one who replied, and hence i took your
> > > advice and
> > > changed my subject and am reposting it. hopefully someone
> > > with an actual
> > > example of pooling with sql server can help me.
> > >
> > > Amitabh
> > >
> > > -Original Message-
> > > From: Turner, John [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, September 23, 2002 9:37 AM
> > > To: 'Tomcat Users List'
> > > Subject: RE: Tomcat Connection pooling
> > >
> > >
> > >
> > > Check your message list threads.  I already replied to this
> > post this
> > > morning!  Perhaps others have as well.
> > >
> > > John
> > >
> > >
> > > > -Original Message-
> > > > From: Amitabh Dubey [mailto:[EMAIL PROTECTED]]
> > > > Sent: Monday, September 23, 2002 10:33 AM
> > > > To: Tomcat
> > > > Subject: Tomcat Connection pooling
> > > >
> > > >
> > > > Hello Guys,
> > > >I have been working on this problem for 3 days now and
> > > > have not been able
> > > > to make Tomcat create a connection pool for me. This is my setup
> > > >
> > > > Database - SQL Server 2000
> > > > Driver   - JDBC Driver by microsoft
> > > > Tomcat   - 4.1.2 (Packaged as part of JWSDK from SUN)
> > > >
> > > > I was able to successfully create and use connections using a
> > > > DataSource.
> > > > However, I want to use connection pooling and have no idea of
> > > > how I can do
> > > > so. If there is anyone who has been successful in creating a
> > > > DataSource
> > > > using a Connection pool with SQL Server, please could you
> > > > either send me a
> > > > snippet of your server.xml or tell me how i can go about
> > > > achieving pooling.
> > > >
> > > > Also, do i need Tyrex if i want to use connection pooling. I
> > > > have downloaded
> > > > it from their website anyways and placed in my
> > > > tomcat\common\lib directory.
> > > > How do i go about using this pool manager if this i w

RE: Tomcat Connection pooling

[Turner, John]

I suggest the list archives.  Connection pooling with Oracle has been
covered quite a bit in the last 3-4 months.

John

> -Original Message-
> From: Amitabh Dubey [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 23, 2002 10:47 AM
> To: Tomcat Users List
> Subject: RE: Tomcat Connection pooling
> 
> 
> I am trying to make it work with Oracle first. If that goes 
> thru, then i
> know for sure that some configuration problems exist with sql 
> server. i did
> take a look at the examples and am following them, but i 
> still have not been
> able to make it work.
> 
> thank you for all your help though.
> 
> Amitabh
> 

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

RE: Tomcat Connection pooling

[Amitabh Dubey]

If DBCP is a problem, then do you have a working example of how i can use it
with PoolMan?

Amitabh

-Original Message-
From: Barney Hamish [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 9:50 AM
To: 'Tomcat Users List'
Subject: RE: Tomcat Connection pooling


Be careful if you decide to use DBCP with SQL Server. I found SQL Server
drops open connections every 10 minutes or so, even while you're in the
middle of retrieving query results!!! (so the verify connection thing
doesn't work) DBCP needs some way of automatically dropping and recreating
connections (like poolman does) if it's to be used with SQL Server. I
haven't got around to submitting a patch to the DBCP Commons team to fix
this.

Hamish

> -Original Message-
> From: Turner, John [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 23, 2002 4:43 PM
> To: 'Tomcat Users List'
> Subject: RE: Tomcat Connection pooling
>
>
>
> I guess some advice is better than none.
>
> Have you checked out the Jakarta Commons DBCP pooling solution like I
> recommended?  Here's a link to how it was done with MySQL:
>
> http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2
>
> Have you checked out third-party SQL Server drivers?  The drivers I am
> familiar with have fully-functional trial periods and they
> not only support
> pooling but also JDBC 3.0.
>
> Have you checked out open source pooling solutions besides DBCP, like
> poolman?
>
> John
>
>
> > -Original Message-
> > From: Amitabh Dubey [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 23, 2002 10:39 AM
> > To: Tomcat Users List
> > Subject: RE: Tomcat Connection pooling
> >
> >
> > John, you are the only one who replied, and hence i took your
> > advice and
> > changed my subject and am reposting it. hopefully someone
> > with an actual
> > example of pooling with sql server can help me.
> >
> > Amitabh
> >
> > -Original Message-
> > From: Turner, John [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 23, 2002 9:37 AM
> > To: 'Tomcat Users List'
> > Subject: RE: Tomcat Connection pooling
> >
> >
> >
> > Check your message list threads.  I already replied to this
> post this
> > morning!  Perhaps others have as well.
> >
> > John
> >
> >
> > > -Original Message-
> > > From: Amitabh Dubey [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, September 23, 2002 10:33 AM
> > > To: Tomcat
> > > Subject: Tomcat Connection pooling
> > >
> > >
> > > Hello Guys,
> > >I have been working on this problem for 3 days now and
> > > have not been able
> > > to make Tomcat create a connection pool for me. This is my setup
> > >
> > > Database - SQL Server 2000
> > > Driver   - JDBC Driver by microsoft
> > > Tomcat   - 4.1.2 (Packaged as part of JWSDK from SUN)
> > >
> > > I was able to successfully create and use connections using a
> > > DataSource.
> > > However, I want to use connection pooling and have no idea of
> > > how I can do
> > > so. If there is anyone who has been successful in creating a
> > > DataSource
> > > using a Connection pool with SQL Server, please could you
> > > either send me a
> > > snippet of your server.xml or tell me how i can go about
> > > achieving pooling.
> > >
> > > Also, do i need Tyrex if i want to use connection pooling. I
> > > have downloaded
> > > it from their website anyways and placed in my
> > > tomcat\common\lib directory.
> > > How do i go about using this pool manager if this i what i
> > > have to use with
> > > tomcat to achieve pooling.
> > >
> > > Please HELP!!
> > >
> > > Thank you
> > > Amitabh Dubey
> > >
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> > <mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail:
> > <mailto:[EMAIL PROTECTED]>
> >
> > --
> > To unsubscribe, e-mail:
> > <mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail:
> > <mailto:[EMAIL PROTECTED]>
> >
> >
> >
> > --
> > To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>

--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

RE: Tomcat Connection pooling

[Barney Hamish]

Be careful if you decide to use DBCP with SQL Server. I found SQL Server
drops open connections every 10 minutes or so, even while you're in the
middle of retrieving query results!!! (so the verify connection thing
doesn't work) DBCP needs some way of automatically dropping and recreating
connections (like poolman does) if it's to be used with SQL Server. I
haven't got around to submitting a patch to the DBCP Commons team to fix
this.

Hamish

> -Original Message-
> From: Turner, John [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 23, 2002 4:43 PM
> To: 'Tomcat Users List'
> Subject: RE: Tomcat Connection pooling
> 
> 
> 
> I guess some advice is better than none.
> 
> Have you checked out the Jakarta Commons DBCP pooling solution like I
> recommended?  Here's a link to how it was done with MySQL:
> 
> http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2
> 
> Have you checked out third-party SQL Server drivers?  The drivers I am
> familiar with have fully-functional trial periods and they 
> not only support
> pooling but also JDBC 3.0.
> 
> Have you checked out open source pooling solutions besides DBCP, like
> poolman?
> 
> John
> 
> 
> > -Original Message-
> > From: Amitabh Dubey [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 23, 2002 10:39 AM
> > To: Tomcat Users List
> > Subject: RE: Tomcat Connection pooling
> > 
> > 
> > John, you are the only one who replied, and hence i took your 
> > advice and
> > changed my subject and am reposting it. hopefully someone 
> > with an actual
> > example of pooling with sql server can help me.
> > 
> > Amitabh
> > 
> > -Original Message-
> > From: Turner, John [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 23, 2002 9:37 AM
> > To: 'Tomcat Users List'
> > Subject: RE: Tomcat Connection pooling
> > 
> > 
> > 
> > Check your message list threads.  I already replied to this 
> post this
> > morning!  Perhaps others have as well.
> > 
> > John
> > 
> > 
> > > -Original Message-
> > > From: Amitabh Dubey [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, September 23, 2002 10:33 AM
> > > To: Tomcat
> > > Subject: Tomcat Connection pooling
> > >
> > >
> > > Hello Guys,
> > >I have been working on this problem for 3 days now and
> > > have not been able
> > > to make Tomcat create a connection pool for me. This is my setup
> > >
> > > Database - SQL Server 2000
> > > Driver   - JDBC Driver by microsoft
> > > Tomcat   - 4.1.2 (Packaged as part of JWSDK from SUN)
> > >
> > > I was able to successfully create and use connections using a
> > > DataSource.
> > > However, I want to use connection pooling and have no idea of
> > > how I can do
> > > so. If there is anyone who has been successful in creating a
> > > DataSource
> > > using a Connection pool with SQL Server, please could you
> > > either send me a
> > > snippet of your server.xml or tell me how i can go about
> > > achieving pooling.
> > >
> > > Also, do i need Tyrex if i want to use connection pooling. I
> > > have downloaded
> > > it from their website anyways and placed in my
> > > tomcat\common\lib directory.
> > > How do i go about using this pool manager if this i what i
> > > have to use with
> > > tomcat to achieve pooling.
> > >
> > > Please HELP!!
> > >
> > > Thank you
> > > Amitabh Dubey
> > >
> > >
> > >
> > > --
> > > To unsubscribe, e-mail:
> > <mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail:
> > <mailto:[EMAIL PROTECTED]>
> > 
> > --
> > To unsubscribe, e-mail:
> > <mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail:
> > <mailto:[EMAIL PROTECTED]>
> > 
> > 
> > 
> > --
> > To unsubscribe, e-mail:   
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
> 
> --
> To unsubscribe, e-mail:   
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: 
> <mailto:[EMAIL PROTECTED]>
> 

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

RE: Tomcat Connection pooling

[Amitabh Dubey]

I am trying to make it work with Oracle first. If that goes thru, then i
know for sure that some configuration problems exist with sql server. i did
take a look at the examples and am following them, but i still have not been
able to make it work.

thank you for all your help though.

Amitabh

-Original Message-
From: Turner, John [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 9:43 AM
To: 'Tomcat Users List'
Subject: RE: Tomcat Connection pooling



I guess some advice is better than none.

Have you checked out the Jakarta Commons DBCP pooling solution like I
recommended?  Here's a link to how it was done with MySQL:

http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2

Have you checked out third-party SQL Server drivers?  The drivers I am
familiar with have fully-functional trial periods and they not only support
pooling but also JDBC 3.0.

Have you checked out open source pooling solutions besides DBCP, like
poolman?

John


> -Original Message-
> From: Amitabh Dubey [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 23, 2002 10:39 AM
> To: Tomcat Users List
> Subject: RE: Tomcat Connection pooling
>
>
> John, you are the only one who replied, and hence i took your
> advice and
> changed my subject and am reposting it. hopefully someone
> with an actual
> example of pooling with sql server can help me.
>
> Amitabh
>
> -Original Message-
> From: Turner, John [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 23, 2002 9:37 AM
> To: 'Tomcat Users List'
> Subject: RE: Tomcat Connection pooling
>
>
>
> Check your message list threads.  I already replied to this post this
> morning!  Perhaps others have as well.
>
> John
>
>
> > -Original Message-
> > From: Amitabh Dubey [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 23, 2002 10:33 AM
> > To: Tomcat
> > Subject: Tomcat Connection pooling
> >
> >
> > Hello Guys,
> >I have been working on this problem for 3 days now and
> > have not been able
> > to make Tomcat create a connection pool for me. This is my setup
> >
> > Database - SQL Server 2000
> > Driver   - JDBC Driver by microsoft
> > Tomcat   - 4.1.2 (Packaged as part of JWSDK from SUN)
> >
> > I was able to successfully create and use connections using a
> > DataSource.
> > However, I want to use connection pooling and have no idea of
> > how I can do
> > so. If there is anyone who has been successful in creating a
> > DataSource
> > using a Connection pool with SQL Server, please could you
> > either send me a
> > snippet of your server.xml or tell me how i can go about
> > achieving pooling.
> >
> > Also, do i need Tyrex if i want to use connection pooling. I
> > have downloaded
> > it from their website anyways and placed in my
> > tomcat\common\lib directory.
> > How do i go about using this pool manager if this i what i
> > have to use with
> > tomcat to achieve pooling.
> >
> > Please HELP!!
> >
> > Thank you
> > Amitabh Dubey
> >
> >
> >
> > --
> > To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
>
>
> --
> To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>

--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

RE: Tomcat Connection pooling

[Turner, John]

I guess some advice is better than none.

Have you checked out the Jakarta Commons DBCP pooling solution like I
recommended?  Here's a link to how it was done with MySQL:

http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2

Have you checked out third-party SQL Server drivers?  The drivers I am
familiar with have fully-functional trial periods and they not only support
pooling but also JDBC 3.0.

Have you checked out open source pooling solutions besides DBCP, like
poolman?

John


> -Original Message-
> From: Amitabh Dubey [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 23, 2002 10:39 AM
> To: Tomcat Users List
> Subject: RE: Tomcat Connection pooling
> 
> 
> John, you are the only one who replied, and hence i took your 
> advice and
> changed my subject and am reposting it. hopefully someone 
> with an actual
> example of pooling with sql server can help me.
> 
> Amitabh
> 
> -Original Message-
> From: Turner, John [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 23, 2002 9:37 AM
> To: 'Tomcat Users List'
> Subject: RE: Tomcat Connection pooling
> 
> 
> 
> Check your message list threads.  I already replied to this post this
> morning!  Perhaps others have as well.
> 
> John
> 
> 
> > -Original Message-
> > From: Amitabh Dubey [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 23, 2002 10:33 AM
> > To: Tomcat
> > Subject: Tomcat Connection pooling
> >
> >
> > Hello Guys,
> >I have been working on this problem for 3 days now and
> > have not been able
> > to make Tomcat create a connection pool for me. This is my setup
> >
> > Database - SQL Server 2000
> > Driver   - JDBC Driver by microsoft
> > Tomcat   - 4.1.2 (Packaged as part of JWSDK from SUN)
> >
> > I was able to successfully create and use connections using a
> > DataSource.
> > However, I want to use connection pooling and have no idea of
> > how I can do
> > so. If there is anyone who has been successful in creating a
> > DataSource
> > using a Connection pool with SQL Server, please could you
> > either send me a
> > snippet of your server.xml or tell me how i can go about
> > achieving pooling.
> >
> > Also, do i need Tyrex if i want to use connection pooling. I
> > have downloaded
> > it from their website anyways and placed in my
> > tomcat\common\lib directory.
> > How do i go about using this pool manager if this i what i
> > have to use with
> > tomcat to achieve pooling.
> >
> > Please HELP!!
> >
> > Thank you
> > Amitabh Dubey
> >
> >
> >
> > --
> > To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
> 
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
> 
> 
> 
> --
> To unsubscribe, e-mail:   
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

RE: Tomcat Connection pooling

[Amitabh Dubey]

John, you are the only one who replied, and hence i took your advice and
changed my subject and am reposting it. hopefully someone with an actual
example of pooling with sql server can help me.

Amitabh

-Original Message-
From: Turner, John [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 9:37 AM
To: 'Tomcat Users List'
Subject: RE: Tomcat Connection pooling



Check your message list threads.  I already replied to this post this
morning!  Perhaps others have as well.

John


> -Original Message-
> From: Amitabh Dubey [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 23, 2002 10:33 AM
> To: Tomcat
> Subject: Tomcat Connection pooling
>
>
> Hello Guys,
>I have been working on this problem for 3 days now and
> have not been able
> to make Tomcat create a connection pool for me. This is my setup
>
> Database - SQL Server 2000
> Driver   - JDBC Driver by microsoft
> Tomcat   - 4.1.2 (Packaged as part of JWSDK from SUN)
>
> I was able to successfully create and use connections using a
> DataSource.
> However, I want to use connection pooling and have no idea of
> how I can do
> so. If there is anyone who has been successful in creating a
> DataSource
> using a Connection pool with SQL Server, please could you
> either send me a
> snippet of your server.xml or tell me how i can go about
> achieving pooling.
>
> Also, do i need Tyrex if i want to use connection pooling. I
> have downloaded
> it from their website anyways and placed in my
> tomcat\common\lib directory.
> How do i go about using this pool manager if this i what i
> have to use with
> tomcat to achieve pooling.
>
> Please HELP!!
>
> Thank you
> Amitabh Dubey
>
>
>
> --
> To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>

--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

RE: Tomcat Connection pooling

[Turner, John]

Check your message list threads.  I already replied to this post this
morning!  Perhaps others have as well.

John


> -Original Message-
> From: Amitabh Dubey [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 23, 2002 10:33 AM
> To: Tomcat
> Subject: Tomcat Connection pooling
> 
> 
> Hello Guys,
>I have been working on this problem for 3 days now and 
> have not been able
> to make Tomcat create a connection pool for me. This is my setup
> 
> Database - SQL Server 2000
> Driver   - JDBC Driver by microsoft
> Tomcat   - 4.1.2 (Packaged as part of JWSDK from SUN)
> 
> I was able to successfully create and use connections using a 
> DataSource.
> However, I want to use connection pooling and have no idea of 
> how I can do
> so. If there is anyone who has been successful in creating a 
> DataSource
> using a Connection pool with SQL Server, please could you 
> either send me a
> snippet of your server.xml or tell me how i can go about 
> achieving pooling.
> 
> Also, do i need Tyrex if i want to use connection pooling. I 
> have downloaded
> it from their website anyways and placed in my 
> tomcat\common\lib directory.
> How do i go about using this pool manager if this i what i 
> have to use with
> tomcat to achieve pooling.
> 
> Please HELP!!
> 
> Thank you
> Amitabh Dubey
> 
> 
> 
> --
> To unsubscribe, e-mail:   
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Tomcat Connection pooling

[Amitabh Dubey]

Hello Guys,
   I have been working on this problem for 3 days now and have not been able
to make Tomcat create a connection pool for me. This is my setup

Database - SQL Server 2000
Driver   - JDBC Driver by microsoft
Tomcat   - 4.1.2 (Packaged as part of JWSDK from SUN)

I was able to successfully create and use connections using a DataSource.
However, I want to use connection pooling and have no idea of how I can do
so. If there is anyone who has been successful in creating a DataSource
using a Connection pool with SQL Server, please could you either send me a
snippet of your server.xml or tell me how i can go about achieving pooling.

Also, do i need Tyrex if i want to use connection pooling. I have downloaded
it from their website anyways and placed in my tomcat\common\lib directory.
How do i go about using this pool manager if this i what i have to use with
tomcat to achieve pooling.

Please HELP!!

Thank you
Amitabh Dubey



--
To unsubscribe, e-mail:   
For additional commands, e-mail: