my dog learned polymorphism*
The moose likes BEA/Weblogic and the fly likes dynamic connection Pool Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "dynamic connection Pool Problem" Watch "dynamic connection Pool Problem" New topic

dynamic connection Pool Problem

Malli Raman
Ranch Hand

Joined: Nov 07, 2001
Posts: 312
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,
Satish Gopalakrishnan
Ranch Hand

Joined: Feb 13, 2001
Posts: 52
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

Joined: Nov 07, 2001
Posts: 312
Thanks Satish. But I am not clearly understand your point. Can you please elaborate it.
Thanks & Regards,
Sai Prasad
Ranch Hand

Joined: Feb 25, 2002
Posts: 560
- 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.
Consider Paul's rocket mass heater.
subject: dynamic connection Pool Problem
Similar Threads
Connection Pool and Tomcat
Websphere Connection Pool Problem
Websphere Connection Pool problem
Connection Issue
Need assistance with WAS 4.0 and SQL 7