Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to disable a connection pool

 
SaurabhSri Sri
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Shikhar Madhok
Ranch Hand
Posts: 95
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Anand Bhatt
Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 95
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic