Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!
Learn how Concerto can help you.
Solved
connection ooling with tomcat
Posted on 2004-08-19
Hi, I understand that to get connection pooling to work with tomcat I need to modify some configuration files.
I have docs on how to do that , so thats fine.
My question is to do with whether the methods used to call the getConnection object should be synchronized or not.
Currently the getConnection method is called using synchronized methods. so that only one method can be dealing with it at one time.
Am i correct in htinking, once connection pooling is enabled, the methods which call cetConnection need not be synchronized?
The second part iof my question is what will happen if say, I have configured 15 connections to be in the pool and there comes a time when 16 are needed? will the last method to request a connection just have to wait its turn?
If so, how will i be able to test if it is working?
I have docs on how to do that , so thats fine.
My question is to do with whether the methods used to call the getConnection object should be synchronized or not.
Currently the getConnection method is called using synchronized methods. so that only one method can be dealing with it at one time.
Am i correct in htinking, once connection pooling is enabled, the methods which call cetConnection need not be synchronized?
The second part iof my question is what will happen if say, I have configured 15 connections to be in the pool and there comes a time when 16 are needed? will the last method to request a connection just have to wait its turn?
If so, how will i be able to test if it is working?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5-
2
7 Comments
Hi rosshind,
> Am i correct in htinking, once connection pooling is enabled, the
> methods which call cetConnection need not be synchronized?
>
I would keep the getConnection method synchronized.
> The second part iof my question is what will happen if say, I have
> configured 15 connections to be in the pool and there comes a time when
> 16 are needed? will the last method to request a connection just have
> to wait its turn?
It depends on the algorithm used with the conneciton pool. Many servers woudl just wait for a connection to be available before proceeding, others would just create a new connection after the limit is reached.
Regards
> Am i correct in htinking, once connection pooling is enabled, the
> methods which call cetConnection need not be synchronized?
>
I would keep the getConnection method synchronized.
> The second part iof my question is what will happen if say, I have
> configured 15 connections to be in the pool and there comes a time when
> 16 are needed? will the last method to request a connection just have
> to wait its turn?
It depends on the algorithm used with the conneciton pool. Many servers woudl just wait for a connection to be available before proceeding, others would just create a new connection after the limit is reached.
Regards
> > Am i correct in htinking, once connection pooling is enabled, the
> > methods which call cetConnection need not be synchronized?
> >
>
> I would keep the getConnection method synchronized.
I mean, if you call getConnection this should not be synchronized, but the implementation getConnection() of the pool is probably synchronized.
> > methods which call cetConnection need not be synchronized?
> >
>
> I would keep the getConnection method synchronized.
I mean, if you call getConnection this should not be synchronized, but the implementation getConnection() of the pool is probably synchronized.
> If so, how will i be able to test if it is working?
Just have a for loop that creates 16 connections, perform some long data processing and see the time it takes for each one.
Just have a for loop that creates 16 connections, perform some long data processing and see the time it takes for each one.
I have a load of DAO methods which currently are synchronized,
what I'll do is remove synchronization form them, and make the static method which wraps the getConnection method synchronized.
Is that what you would suggest?
what I'll do is remove synchronization form them, and make the static method which wraps the getConnection method synchronized.
Is that what you would suggest?
I think you could avoid synchronizing the call to getConnection since the container's implementation of the connection pool should be already synchronized. Maybe you want to take a look here to see how a conneciton pool is implemented: http://www.webdevelopersjournal.com/columns/connection_pool.html
Featured Post
Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed.
------------------------- Start
The idea here is to target your cell phones with
the correct…
Introduction
Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
The viewer will learn how to implement Singleton Design Pattern in Java.
Suggested Courses
Course of the Month9 days, 11 hours left to enroll
610 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.