rss
SOATUBE
Oracle
Custom Search SOABYTE here

Thursday, April 24, 2014

Getting JDBC and Connection Pool Data From a WLST or Shell script

Getting JDBC and Connection Pool Data From a WLST or Shell script
 In the script above replace weblogic with your actual username, welcome1 with the actual username's password and localhost:7001 with the actual hostname and password for your WebLogic server.
# monitor.py

attr= {
    "ActiveConnectionsAverageCount": None,
    "ActiveConnectionsCurrentCount": None,
    "ActiveConnectionsHighCount": None,
    "ConnectionDelayTime": None,
    "ConnectionsTotalCount": None,
    "CurrCapacity": None,
    "DeploymentState": None,
    "Enabled": None,
    "FailuresToReconnectCount": None,
    "HighestNumAvailable": None,
    "HighestNumUnavailable": None,
    "LeakedConnectionCount": None,
    "ModuleId": None,
    "Name": None,
    "NumAvailable": None,
    "NumUnavailable": None,
    "Properties": None,
    "State": None,
    "Type": None,
    "VersionJDBCDriver": None,
    "WaitSecondsHighCount": None,
    "WaitingForConnectionCurrentCount": None,
    "WaitingForConnectionHighCount": None
}

connect("weblogic","welcome1","t3://localhost:7001")
pools= adminHome.getMBeansByType( 'JDBCConnectionPoolRuntime' )
for pool in pools:
    for a in attr:
        attr[a]= pool.getAttribute( a )
        # attr has the JDBC and Connection Pool data at this point
    print attr
disconnect()
Using weblogic.Admin Tool
 In the command below replace test_domain with your actual domain name, weblogic with your actual username, welcome1 with the actual username's password, localhost:7001 with the actual hostname and password for your WebLogic server, AdminServer with the server name that your Data Source was targeted to, and JDBCDataSource1 with the actual Data Source name.

$ java weblogic.Admin -adminurl t3://localhost:7001 -username weblogic -password welcome1 GET -pretty -mbean "test_domain:Location=AdminServer,Name=JDBCDataSource1,ServerRuntime=AdminServer,Type=JDBCConnectionPoolRuntime"

1 comments:

w2syw23mi3 said...

One of my favourite suggestions for playing in} slots is assume about|to contemplate} it the 'risk issue' of the sport would possibly be} about to play. We a glance at|have a glance at} over 25 types if slot machines across the best PA online on line casino and NJ online on line casino websites and we found out that the payout share has very little to do with the video games' popularity. Choose the lowest denomination attainable for the slot 카지노 게임 machine you want to play. This will permit you to play the slot machine for longer durations of time and might maximize your gaming experience. If you're going with a price range in thoughts, buy-a-pays and progressive machines aren't your finest bet, literally.

Post a Comment

 
Blogger Profile