• 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

dynamic connection Pool Problem

 
Ranch Hand
Posts: 312
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,
I am using dynamic connection pool mechanism in my application with Oracle Database server as back end. The initial number of connection is 15. But when the oracle Database server goes down, logically we cannot use those objects, so the application gives error message. But what will happen if the database sever is restarted and the appserver is not restarted and it is running. Whether can those 15 connections can be automatically created or available for any database queries.
What i have observed in my application is that the database connection are lost and to recreate it, we have to restart the application server. Why is it so?
I got the feeling that something is wrong in the dynamic connection pool mechanism. Because in this case, appserver layer is depended on the database layer which is not advisable.
Please let me know your views.
Thanks & Regards,
M.S.Raman
 
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There is a "refresh period "attribute which is associated with a connection pool. Use this in conjunction with a test table .Connections that do not pass the test will be closed and reopened in an attempt to reestablish a valid physical database connection .
 
Malli Raman
Ranch Hand
Posts: 312
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Satish. But I am not clearly understand your point. Can you please elaborate it.
Thanks & Regards,
M.S.Raman
 
Ranch Hand
Posts: 560
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
- Go to Administrative console
- Select Services -> JDBC -> Connection Pools -> Your pool on the left side of the frame. On your right side, you will see the details of your pool.
- Select the tab "Connections" and change the refresh period to say 1 min. Now weblogic will try to refresh the pool every 1 min.
- Select the "Testing" tab and enter the test table name "some table in your database"
Now the pool will be refreshed when the database comes up after it goes down.
 
Whatever you say buddy! And I believe this tiny ad too:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic