com.aspc.commander.sql

Class StatsPartCommand

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.commander.sql.StatsPartCommand

All Implemented Interfaces:

CommandBuildResultsAttPlugin, CommandBuildResultsPlugin

public class StatsPartCommand
extends SQLCommand
implements CommandBuildResultsAttPlugin

Syntax

  STATSPART [BUILD] |
            [MEMORY] |
            [JAVA] |
            [TASK] |
            [DBCLASS] |
            [LINK] |
            [SOAP] |
            [THREADPOOL] |
            [JMS]|
            [JOB] |
            [THREAD] |
            [MEMORYHANDLER] |
            [DBCONNECTION]|
            [CLEAR]
  

Usage

  STATSPART BUILD
  

THREAD MODE: SINGLE THREADED command

Since:

3 December 2003

Author:

Nigel Leck

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	COL_BLOCKED Column Blocked
static java.lang.String	COL_COMMAND Column Command - Specifies what command is being executed at this time
static java.lang.String	COL_DATABASE_NAME Column database name - Virtual database name
static java.lang.String	COL_HOST_NAME Column host name - Hostname from which the connection been established
static java.lang.String	COL_IP_ADDRESS Column IP Address - From which IP this connection has been established
static java.lang.String	COL_LOGIN_NAME Colum Login name -require to establish a connection
static java.lang.String	COL_PORT Column Port
static java.lang.String	COL_PROGRAM_NAME Column program name - Program that is running this connection
static java.lang.String	COL_SPID Column SPID
static java.lang.String	COL_STATUS Column Status - Status of the connection
static java.lang.String	COMMAND_SP_WHO_SYBASE Command sp
protected java.lang.String	resultClearStats clear stats

Fields inherited from class com.aspc.commander.sql.SQLCommand

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
StatsPartCommand(Connection connection, Pattern pattern) std.

Method Summary

Modifier and Type	Method and Description
protected void	execute(Parser p) execute the command.
java.lang.String[]	getAttributeNames(int row) Returns the attribute for the specified row and col
java.lang.String[]	getAttributeNames(int row, int col) Returns the attribute for the specified row and col
java.lang.String	getAttributeValue(java.lang.String attribute, int row) Returns the attribute for the specified row and col Example "color:red "
java.lang.String	getAttributeValue(java.lang.String attribute, int row, int col) Returns the attribute for the specified row and col Example "color:red "
java.lang.String	getColumnName(int col) the column name
java.lang.String	getColumnType(int col) Gets the column type for the given column index, starting at one
java.lang.String	getRecordID(int row) the record ID
java.lang.Object	getValue(int row, int col) the value for this row, column
void	makeBuild() Set the result set of stats build section
void	makeDBClass(MutableDataSource mds) set the result set for stats Database class section
void	makeDBConnection(MutableDataSource mds) set the resultset for stats DataBaseConnection section
void	makeJava() set the resultset for stats java section
void	makeJob(MutableDataSource mds) set the resultset for stats Job section
void	makeLink() set the result set for stats Link section
void	makeMemory() set the resultset for stats memory section
void	makeMemoryHandler() set the resultset for stats memory handler section
void	makeTask(MutableDataSource mds) set the resultset for stats Task section
void	makeThread() set the result set for stats Thread section
void	makeThreadPool() set the resultset for stats ThreadPool section

Methods inherited from class com.aspc.commander.sql.SQLCommand

appendResult, appendResult, getCursorName, getRecordKey, isExecuteOnly

Methods inherited from class com.aspc.commander.Command

execute, extMakeThreadName, getConnection, getPattern, getRawTitle, getTitle, makeThreadName, recordCall, setTitle

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.aspc.commander.sql.results.CommandBuildResultsPlugin

getRawTitle

Field Detail

COL_LOGIN_NAME

public static final java.lang.String COL_LOGIN_NAME

Colum Login name -require to establish a connection

See Also:

Constant Field Values

COL_IP_ADDRESS

public static final java.lang.String COL_IP_ADDRESS

Column IP Address - From which IP this connection has been established

See Also:

Constant Field Values

COL_HOST_NAME

public static final java.lang.String COL_HOST_NAME

Column host name - Hostname from which the connection been established

See Also:

Constant Field Values

COL_PROGRAM_NAME

public static final java.lang.String COL_PROGRAM_NAME

Column program name - Program that is running this connection

See Also:

Constant Field Values

COL_DATABASE_NAME

public static final java.lang.String COL_DATABASE_NAME

Column database name - Virtual database name

See Also:

Constant Field Values

COL_STATUS

public static final java.lang.String COL_STATUS

Column Status - Status of the connection

See Also:

Constant Field Values

COL_COMMAND

public static final java.lang.String COL_COMMAND

Column Command - Specifies what command is being executed at this time

See Also:

Constant Field Values

COL_BLOCKED

public static final java.lang.String COL_BLOCKED

Column Blocked

See Also:

Constant Field Values

COL_SPID

public static final java.lang.String COL_SPID

Column SPID

See Also:

Constant Field Values

COL_PORT

public static final java.lang.String COL_PORT

Column Port

See Also:

Constant Field Values

COMMAND_SP_WHO_SYBASE

public static final java.lang.String COMMAND_SP_WHO_SYBASE

Command sp

See Also:

Constant Field Values

resultClearStats

protected java.lang.String resultClearStats

clear stats

Constructor Detail

StatsPartCommand

public StatsPartCommand(Connection connection,
                        Pattern pattern)

std. Command.

Parameters:

connection - the connection

pattern - the pattern

Method Detail

execute

protected void execute(Parser p)
                throws java.lang.Exception

execute the command.

Specified by:

execute in class Command

Parameters:

p - The parser

Throws:

java.lang.Exception - A serious problem

getColumnName

public java.lang.String getColumnName(int col)

the column name

Specified by:

getColumnName in interface CommandBuildResultsPlugin

Parameters:

col - the column

Returns:

the name

getColumnType

public java.lang.String getColumnType(int col)

Gets the column type for the given column index, starting at one

Specified by:

getColumnType in interface CommandBuildResultsPlugin

Parameters:

col - the column index

Returns:

String the column type

getRecordID

public java.lang.String getRecordID(int row)

the record ID

Specified by:

getRecordID in interface CommandBuildResultsPlugin

Parameters:

row - the row index

Returns:

the record ID

getValue

public java.lang.Object getValue(int row,
                                 int col)

the value for this row, column

Specified by:

getValue in interface CommandBuildResultsPlugin

Parameters:

row - the row index

col - the column

Returns:

Object the value for the given row and column

getAttributeNames

public java.lang.String[] getAttributeNames(int row,
                                            int col)
                                     throws java.lang.Exception

Returns the attribute for the specified row and col

Specified by:

getAttributeNames in interface CommandBuildResultsAttPlugin

Parameters:

row - the row

col - the column

Returns:

The value

Throws:

java.lang.Exception - A serious problem

getAttributeNames

public java.lang.String[] getAttributeNames(int row)
                                     throws java.lang.Exception

Returns the attribute for the specified row and col

Specified by:

getAttributeNames in interface CommandBuildResultsAttPlugin

Parameters:

row - the row

Returns:

The value

Throws:

java.lang.Exception - A serious problem

getAttributeValue

public java.lang.String getAttributeValue(java.lang.String attribute,
                                          int row)
                                   throws java.lang.Exception

Returns the attribute for the specified row and col Example "color:red "

Specified by:

getAttributeValue in interface CommandBuildResultsAttPlugin

Parameters:

attribute - the attribute

row - the row

Returns:

The value

Throws:

java.lang.Exception - A serious problem

getAttributeValue

public java.lang.String getAttributeValue(java.lang.String attribute,
                                          int row,
                                          int col)
                                   throws java.lang.Exception

Returns the attribute for the specified row and col Example "color:red "

Specified by:

getAttributeValue in interface CommandBuildResultsAttPlugin

Parameters:

attribute - the attribute

row - the row

col - the column

Returns:

The value

Throws:

java.lang.Exception - A serious problem

makeBuild

public void makeBuild()

Set the result set of stats build section

makeMemory

public void makeMemory()

set the resultset for stats memory section

makeJava

public void makeJava()

set the resultset for stats java section

makeTask

public void makeTask(MutableDataSource mds)
              throws java.lang.Exception

set the resultset for stats Task section

Parameters:

mds - Mutual DataSource

Throws:

java.lang.Exception - Exception is major problem

makeDBClass

public void makeDBClass(MutableDataSource mds)

set the result set for stats Database class section

Parameters:

mds - Mutual DataSource

makeLink

public void makeLink()
              throws java.lang.Exception

set the result set for stats Link section

Throws:

java.lang.Exception - Exception is major problem

makeThread

public void makeThread()

set the result set for stats Thread section

makeThreadPool

public void makeThreadPool()

set the resultset for stats ThreadPool section

makeJob

public void makeJob(MutableDataSource mds)

set the resultset for stats Job section

Parameters:

mds - Mutual DataSource

makeMemoryHandler

public void makeMemoryHandler()
                       throws java.lang.InterruptedException

set the resultset for stats memory handler section

Throws:

java.lang.InterruptedException

makeDBConnection

public void makeDBConnection(MutableDataSource mds)
                      throws java.lang.Exception

set the resultset for stats DataBaseConnection section

Parameters:

mds - Mutual DataSource

Throws:

java.lang.Exception - a