File Doc Category Size Date Package
TableInfo.java API Doc Glassfish v2 API 28790 Fri May 04 22:24:18 BST 2007 com.sun.enterprise.admin.monitor.callflow

TableInfo

public interface TableInfo

author: Harpreet Singh

Fields Summary
public static final String
REQUEST_ID
Columns common across Tables
public static final String
REQUEST_ID_TYPE
public static final String
TIME_STAMP
public static final String
TIME_STAMP_TYPE
public static final String
CREATE_TABLE
SQL Statements keywords
public static final String
NOT_NULL
public static final String
COMMA
public static final String
PRIMARY_KEY
public static final String
DROP_TABLE
public static final String
UPDATE
public static final String
INSERT_INTO
public static final String
VALUES
public static final String
DOT
public static final String
EQUALS
public static final String
HAVING
public static final String
GROUP_BY
public static final String
WHERE
public static final String
AND
public static final String
MIN
public static final String
MAX
public static final String
SELECT
public static final String
FROM
public static final String
AS
public static final String
UNION
public static final String
ORDER_BY
public static final String
SUM
public static final String
DELETE
public static final String
REQUEST_START_TABLE_NAME
RequestStart Table Information
public static final String
REQUEST_TYPE
public static final String
REQUEST_TYPE_TYPE
public static final String
TIME_STAMP_MILLIS
public static final String
TIME_STAMP_MILLIS_TYPE
public static final String
IP_ADDRESS
public static final String
IP_ADDRESS_TYPE
public static final String
CREATE_TABLE_REQUEST_START_SQL
public static final String
DROP_TABLE_REQUEST_START_SQL
Drop table Request Start SQL
public static final String
INSERT_INTO_TABLE_REQUEST_START_SQL
Update table Request Start SQL
public static final String
DELETE_FROM_TABLE_REQUEST_START_SQL
delete row from request start SQL
public static final String
REQUEST_END_TABLE_NAME
RequestEnd Table Information
public static final String
CREATE_TABLE_REQUEST_END_SQL
public static final String
DROP_TABLE_REQUEST_END_SQL
Drop table Request End SQL
public static final String
INSERT_INTO_TABLE_REQUEST_END_SQL
Update table Request End SQL
public static final String
DELETE_FROM_TABLE_REQUEST_END_SQL
public static final String
METHOD_START_TABLE_NAME
Method Start Table Information
public static final String
COMPONENT_TYPE
Column Names unique to Method Start Table
public static final String
COMPONENT_TYPE_TYPE
public static final String
COMPONENT_NAME
public static final String
COMPONENT_NAME_TYPE
public static final String
APP_NAME
public static final String
APP_NAME_TYPE
public static final String
METHOD_NAME
public static final String
METHOD_NAME_TYPE
public static final String
MODULE_NAME
public static final String
MODULE_NAME_TYPE
public static final String
THREAD_ID
public static final String
THREAD_ID_TYPE
public static final String
TRANSACTION_ID
public static final String
TRANSACTION_ID_TYPE
public static final String
SECURITY_ID
public static final String
SECURITY_ID_TYPE
public static final String
MINUS
public static final String
CREATE_TABLE_METHOD_START_SQL
Create Statement for Method Start Table create table MethodStart ( REQUEST_ID VARCHAR(255) NOT_NULL, TIME_STAMP BIGINT NOT_NULL, COMPONENT_TYPE VARCHAR(20), COMPONENT_NAME VARCHAR(255), APP_NAME VARCHAR(255), METHOD_NAME VARCHAR(255), MODULE_NAME VARCHAR (255), THREAD_ID VARCHAR(255), TRANSACTION_ID VARCHAR (255), SECURITY_ID VARCHAR(255), primary key (REQUEST_ID, TIME_STAMP))
public static final String
DROP_TABLE_METHOD_START_SQL
public static final String
INSERT_INTO_TABLE_METHOD_START_SQL
Update table Method Start SQL
public static final String
DELETE_FROM_TABLE_METHOD_START_SQL
public static final String
METHOD_END_TABLE_NAME
Method End Table Information
public static final String
EXCEPTION_NAME
Column Names unique to Method End Table
public static final String
EXCEPTION_NAME_TYPE
public static final String
CREATE_TABLE_METHOD_END_SQL
public static final String
DROP_TABLE_METHOD_END_SQL
Drop table Request End SQL
public static final String
INSERT_INTO_TABLE_METHOD_END_SQL
Update table Method End SQL
public static final String
DELETE_FROM_TABLE_METHOD_END_SQL
public static final String
START_TIME_TABLE_NAME
Start Time Table Information
public static final String
CONTAINER_TYPE
Column Names unique to Start Time Table
public static final String
CONTAINER_TYPE_TYPE
public static final String
CREATE_TABLE_START_TIME_SQL
public static final String
DROP_TABLE_START_TIME_SQL
Drop table start time SQL
public static final String
INSERT_INTO_TABLE_START_TIME_SQL
Update table Start Time SQL
public static final String
DELETE_FROM_TABLE_START_TIME_SQL
public static final String
END_TIME_TABLE_NAME
End Time Table Information
public static final String
CREATE_TABLE_END_TIME_SQL
public static final String
DROP_TABLE_END_TIME_SQL
Drop table Request End SQL
public static final String
INSERT_INTO_TABLE_END_TIME_SQL
Update table Start Time SQL
public static final String
DELETE_FROM_TABLE_END_TIME_SQL
public static final String
COLUMN_NAMES_FOR_GET_REQUEST_INFORMATION
select REQUEST_START_TBL.REQUEST_ID, REQUEST_START_TBL.TIME_STAMP, REQUEST_START_TBL.TIME_STAMP_MILLIS, REQUEST_START_TBL.REQUEST_TYPE, REQUEST_START_TBL.IP_ADDRESS, METHOD_START_TBL.METHOD_NAME, METHOD_START_TBL.APP_NAME, METHOD_START_TBL.SECURITY_ID, METHOD_END_TBL.EXCEPTION_NAME, REQUEST_END_TBL.TIME_STAMP - REQUEST_START_TBL.TIME_STAMP from "APP"."REQUEST_START_TBL", "APP"."REQUEST_END_TBL", "APP"."METHOD_START_TBL", "APP"."METHOD_END_TBL" WHERE REQUEST_START_TBL.REQUEST_ID=REQUEST_END_TBL.REQUEST_ID AND REQUEST_START_TBL.REQUEST_ID=METHOD_START_TBL.REQUEST_ID AND REQUEST_START_TBL.REQUEST_ID=METHOD_END_TBL.REQUEST_ID GROUP BY REQUEST_START_TBL.REQUEST_ID, REQUEST_START_TBL.TIME_STAMP, REQUEST_START_TBL.REQUEST_TYPE, METHOD_START_TBL.TIME_STAMP, REQUEST_START_TBL.TIME_STAMP_MILLIS, REQUEST_START_TBL.IP_ADDRESS, METHOD_START_TBL.METHOD_NAME, METHOD_START_TBL.APP_NAME, METHOD_START_TBL.SECURITY_ID, METHOD_END_TBL.EXCEPTION_NAME, REQUEST_END_TBL.TIME_STAMP, METHOD_END_TBL.TIME_STAMP HAVING METHOD_START_TBL.TIME_STAMP = ( SELECT MIN (METHOD_START_TBL.TIME_STAMP) FROM METHOD_START_TBL WHERE METHOD_START_TBL.REQUEST_ID = REQUEST_START_TBL.REQUEST_ID) AND METHOD_END_TBL.TIME_STAMP = ( SELECT MAX (METHOD_END_TBL.TIME_STAMP) FROM METHOD_END_TBL WHERE METHOD_END_TBL.REQUEST_ID = REQUEST_START_TBL.REQUEST_ID)
public static final String
COLUMNS_FOR_GROUP_BY_FOR_GET_REQUEST_INFORMATION
public static final String
TIME_DIFF_RS_RE
public static final String
GET_REQUEST_INFORMATION_SQL
public static final String
TIMESTAMP_FOR_CALLSTACK_QUERY
select 'RequestStart', REQUEST_START_TBL.REQUEST_ID, REQUEST_START_TBL.TIME_STAMP AS TIMESTAMP, REQUEST_START_TBL.TIME_STAMP_MILLIS, REQUEST_START_TBL.REQUEST_TYPE , '' , '', '', '', '', '', '' , '', '' from "APP"."REQUEST_START_TBL" WHERE REQUEST_START_TBL.REQUEST_ID='?' UNION (select 'MethodStart', METHOD_START_TBL.REQUEST_ID, METHOD_START_TBL.TIME_STAMP AS TIMESTAMP, '', '', '', METHOD_START_TBL.COMPONENT_TYPE, METHOD_START_TBL.COMPONENT_NAME, METHOD_START_TBL.APP_NAME, METHOD_START_TBL.METHOD_NAME, METHOD_START_TBL.MODULE_NAME, METHOD_START_TBL.THREAD_ID, METHOD_START_TBL.TRANSACTION_ID, METHOD_START_TBL.SECURITY_ID from METHOD_START_TBL WHERE METHOD_START_TBL.REQUEST_ID='?') UNION (select 'MethodEnd', METHOD_END_TBL.REQUEST_ID, METHOD_END_TBL.TIME_STAMP AS TIMESTAMP, '', '', METHOD_END_TBL.EXCEPTION_NAME, '', '', '', '', '', '' , '', '' from METHOD_END_TBL WHERE METHOD_END_TBL.REQUEST_ID='?') UNION (select 'RequestEnd', REQUEST_END_TBL.REQUEST_ID, REQUEST_END_TBL.TIME_STAMP AS TIMESTAMP, '', '', '', '', '', '', '', '', '' , '', '' from "APP"."REQUEST_END_TBL" WHERE REQUEST_END_TBL.REQUEST_ID='?') ORDER BY TIMESTAMP
public static final String
REQUEST_START_COLUMNS_FOR_GET_CALLSTACK_INFORMATION_QUERY
public static final String
CALLSTACK_REQUEST_START_TBL_SQL
public static final String
METHOD_START_COLUMNS_FOR_GET_CALLSTACK_INFORMATION_QUERY
public static final String
CALLSTACK_METHOD_START_TBL_SQL
public static final String
METHOD_END_COLUMNS_FOR_GET_CALLSTACK_INFORMATION_QUERY
public static final String
CALLSTACK_METHOD_END_TBL_SQL
public static final String
REQUEST_END_COLUMNS_FOR_GET_CALLSTACK_INFORMATION_QUERY
public static final String
CALLSTACK_REQUEST_END_TBL_SQL
public static final String
GET_CALLSTACK_INFORMATION_SQL
public static final String
GET_PIE_INFORMATION_START_TIME_SQL
select START_TIME_TBL.containerTypeOrApplicationType, SUM (START_TIME_TBL.TIME_STAMP) FROM START_TIME_TBL WHERE START_TIME_TBL.RID = 'RequestID_1' GROUP BY START_TIME_TBL.containerTypeOrApplicationType
public static final String
GET_PIE_INFORMATION_END_TIME_SQL
select END_TIME_TBL.containerTypeOrApplicationType, SUM (END_TIME_TBL.TIME_STAMP) FROM END_TIME_TBL WHERE END_TIME_TBL.RID = 'RequestID_1' GROUP BY END_TIME_TBL.containerTypeOrApplicationType
Constructors Summary
Methods Summary