File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "dynamic connection Pool Problem" Watch "dynamic connection Pool Problem" New topic
Author

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,
M.S.Raman
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,
M.S.Raman
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: dynamic connection Pool Problem