• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

connection pooling

 
Ranch Hand
Posts: 261
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is the difference between, "maxIdle", "maxWait" and "maxActive"?
I have read through the comments given from the Tomcat website, but i
still don't quite understand what it mean.

For example:
I placed my "maxActive" to 130
I placed my "maxWait" to 1000
and my "maxIdle" to 30000
how will the connection be like?

Database used racle 9i
Tomcat server version 5.5
JDBC Driver : Jdbc odbc type 1 driver

Also tell me how to set these values?
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
maxActive - defines the maximum number of active connections the pool can contain. This is basically the absolute limit of the number of connections your pool is allowed to make to the database.

maxIdle - defines the maximum number of idle connections that can exist in the pool.

maxWait - how long a client can wait for a connection to become available before throwing an exception.

How you set these value depends on the load on yuor application. The best thing to do is make a guess, run some performance tests and tune accordingly.


JDBC Driver : Jdbc odbc type 1 driver


Why are you using this with Oracle? Typically you would only use the JDBC-ODBC bridge where no alternative exists.
 
Abhishek Reddy
Ranch Hand
Posts: 261
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
thanks for the reply....

maxIdle - defines the maximum number of idle connections that can exist in the pool.

It means maxActive value should be less than maxActive value..

here in the application i have given both maxActive and maxIdle value to 140 and maxWait to 10,000.

when performance testing is done, the folowing error has occurred..

java.sql.SQLException: [Oracle][ODBC][Ora]ORA-00020: maximum number of processes (150) exceeded.

How do i solve this problem?
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by Abhishek Reddy Chepyala:
thanks for the reply....

maxIdle - defines the maximum number of idle connections that can exist in the pool.

It means maxActive value should be less than maxActive value..

here in the application i have given both maxActive and maxIdle value to 140 and maxWait to 10,000.

when performance testing is done, the folowing error has occurred..

java.sql.SQLException: [Oracle][ODBC][Ora]ORA-00020: maximum number of processes (150) exceeded.

How do i solve this problem?



SORRY I DONT KNOW ......
 
Abhishek Reddy
Ranch Hand
Posts: 261
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
thanks for the reply....

maxIdle - defines the maximum number of idle connections that can exist in the pool.

It means maxIdle value should be less than maxActive value..

here in the application i have given both maxActive and maxIdle value to 140 and maxWait to 10,000.

when performance testing is done, the folowing error has occurred..

java.sql.SQLException: [Oracle][ODBC][Ora]ORA-00020: maximum number of processes (150) exceeded.

How do i solve this problem?
 
Ranch Hand
Posts: 1683
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This is not a new problem, you reported this in another post.

Are you failing to close a Connection after usage?
 
Abhishek Reddy
Ranch Hand
Posts: 261
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
i have checked 4 to 5 times, there is no connection leakage problem.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic