• 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 with firewall

 
Ranch Hand
Posts: 196
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,
I have a firewall which closes all the connections which are idle for 30 mins.So i have included the following connection pooling parameters inside my context file.
timeBetweenEvictionRunsMillis=300000
numTestsPerEvictionRun=20
minEvictableIdleTimeMillis= 180000
I also have maxActive=50
maxIdle=100
maxWait=-1
But still its not working.Can anybody have any suggestion in this regard.

regards,
Ajse
 
author
Posts: 4335
39
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What server software are you using to manage the connection?
 
ajse ruku
Ranch Hand
Posts: 196
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I am using Tomcat 5.x and dbcp connection pooling.
regards,
Ajse
 
Ranch Hand
Posts: 472
Objective C Ubuntu Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I think for most of connection pools you can setup lifetime of connection. So set it shorter than firewall setting and you should be safe. I use this approach with success.
 
ajse ruku
Ranch Hand
Posts: 196
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
Can you pls specify how can i set the life time of the connection i.e which parameter we need in this case?
regards,
ajse
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I'm curious: Is the firewall between the servers and the outside world, or is it between segments of the internal network? The former would imply that there's JDBC traffic coming in over the Internet - I'd be interested to hear what lead to that architectural choice. If the latter, where does the need for a firewall between internal systems come from?
 
ajse ruku
Ranch Hand
Posts: 196
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,

I dont have any control on these issues(firewall between internal servers).Probably this kind of settings can save the data in case of any hack.
But the problem is still there and not been fixed yet.
regards,
Ajse
 
D Rog
Ranch Hand
Posts: 472
Objective C Ubuntu Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Product companies always have problem like that. You can't dictate to customers how to configure firewall, otherwise they will get a product of your competitor which can manage such problems. I do not see lifetime for connection in your pool parameters. We used own pool and actually added this feature because met such requirements.
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic