• 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
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

Reconnection with Oracle

 
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
My application is using JBoss 3.2.5. as Application Server and Oracle as Database. If there is any connectivity problem between the two or the Oracle server is down, JBoss starts throwing exception but when the connectivity is restored or Oracle is restarted, JBoss starts to work well after few minutes (around 7-8 min). I wud like to know, how Jboss maintains connection with Oracle? Is there any setting so I can reduce the time taken by JBoss to work well after reconnecting with Oracle?
Thanks and Regards,
Kapil
 
kapil Gupta
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Any body having an idea?
 
Ranch Hand
Posts: 293
Mac OS X Netbeans IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I think you want to have a look at the <idle-timeout-minutes> setting in your datasource configuration.

Have a look at this.
[ September 16, 2005: Message edited by: Dave Salter ]
 
kapil Gupta
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Dave,
Sorry for replying late. I tried ur as u suggested but am still facing the same problem.
Regards,
Kapil
 
kapil Gupta
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Finally am able to solve the problem

Add the following line in your -ds.xml file

<check-valid-connection-sql>any simple query</check-valid-connection-sql>

It will check if a valid connection is available, if not it will create a new connection pool

Regards,
Kapil
 
Dave Salter
Ranch Hand
Posts: 293
Mac OS X Netbeans IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
That sounds like a good one to remember! I imagine that will be very useful.

Cheers,

Dave.
 
kapil Gupta
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes, now there is no delay in reconnection to Oracle but it may degrade the performance a bit
 
First, you drop a couch from the plane, THEN you surf it. Here, take this tiny ad with you:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic