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 How to disable a connection pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "How to disable a connection pool" Watch "How to disable a connection pool" New topic
Author

How to disable a connection pool

SaurabhSri Sri
Ranch Hand

Joined: May 01, 2008
Posts: 43
Hi,

Can anyone help me to write a program (java or unix shell script) to disable a weblogic connection pool for a specified time?

We have a connection pool named EDt in weblogic on production environment. We have a wide maintenance timeframe which is about 60 minutes from 00:00 through 01:00 AM at Saturday night/Sunday morning. For this time period I have to disable the pool.

I have gone through the weblogic documents and found a command "DISABLE_POOL " but I am not able to use this.

Thanks in advance.


Regards
SaurabhSri (SCJP 1.5)
Shikhar Madhok
Ranch Hand

Joined: Dec 18, 2006
Posts: 95
Hi,

Try this.

Also let us know what are the issues you are facing, to be able to help you further. Mentioing the WLS server version and OS also wouldn't harm.

HTH
Shikhar


He who asks a question is a fool for five minutes; he who does not ask a question remains a fool forever - Chinese proverb
Anand Bhatt
Ranch Hand

Joined: May 30, 2007
Posts: 189
Hi Shikhar my query is from which directory path this below command should be run.

java [ SSL Arguments ] weblogic.Admin [-url URL] [ User Credentials Arguments ] DISABLE_POOL -poolName connection_pool_name [true|false]
SaurabhSri Sri
Ranch Hand

Joined: May 01, 2008
Posts: 43
Hi Shikhar,

Thanks for your reply.
The OS we are having at production is Linux, and the WL version is 9.2. I already walk through the link that you have mentioned.

I just want to describe more my problem here.
We are using a multi datasource with failover algorithm. Two connection pools (primary and secondary) are bind with this multi datasource. Now, business want us to implement a program that would send an alert when the primary connection pool switched to secondary connection pool.
As of now I come up with two solutions.

1. We can make a script which would monitor the server logs, search for a message belongs to this activity and send an alert if found the message. But, we don�t know what would be the exact content of message.

2. We can implement Failover Callback Handler in multi datasource. We can call a java class to send the alert. We are still trying to explore this.

Please give your opinion. Thanks
Shikhar Madhok
Ranch Hand

Joined: Dec 18, 2006
Posts: 95
Hi,

Little confusion here, who asked what.

Anyway
@Anand - Please see my reply in the thread you started.

@SaurabhSri - I'm sorry have not come across any such requirement. Even if I were advicing it would be just a guess. But am sure the first approach is definitely not good. Possibly some other WebLogic Expert may be able to advice.

A word of advice from my side: If you had posted these details earlier you probably would have had an answer by now. So please try to be as descriptive in your first post. It would help us help you better (cliche, eh!)

HTH
Shikhar
[ July 29, 2008: Message edited by: Shikhar Madhok ]
SaurabhSri Sri
Ranch Hand

Joined: May 01, 2008
Posts: 43
Hi Shikhar,

I am sorry for making confusion.

I just want to describe more our problem here -
We are using a multi datasource with failover algorithm. Two connection pools (primary and secondary) are bind with this multi datasource. Now, business want us to implement a program that would send an alert when the primary connection pool switched to secondary connection pool or vise versa.
As of now we come with two solutions.
1. We can make a script which would monitor the server logs, search for a message belongs to this activity and send an alert if found the message. But, we don�t know what would be the exact content of message and probably not good so far.

2. We can implement Failover Callback Handler in multi datasource. We can call a java program to send the alert as whenever a switch between pools occur, weblogic container calls the callback Handler where we can put the alert.

Please suggest.
Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to disable a connection pool