net.sf.farrago.syslib
Class FarragoKillUDR

java.lang.Object
  net.sf.farrago.syslib.FarragoKillUDR

public abstract class FarragoKillUDR
extends Object

FarragoKillUDR defines some system procedures for killing sessions and executing statements. (Technically these are user-defined procedures.) They are intended for use by a system administrator, and are installed by initsql/createMgmtViews.sql

Version:

$Id: //open/dev/farrago/src/net/sf/farrago/syslib/FarragoKillUDR.java#9 $

Author:

Marc Berkowitz

Field Summary

(package private) static Logger

tracer

Constructor Summary

FarragoKillUDR()

Method Summary

static void	killSession(long id) Kills a running session, destroying it and releasing any resources associated with it.
static void	killSession(long id, boolean cancelOnly) Kills a running session.
static void	killStatement(long id) Kills an executing statement, destroying it and releasing any resources associated with it.
static void	killStatement(long id, boolean cancelOnly) Kills an executing statement.
static void	killStatementMatch(String s) Kills all statements executing SQL that matches a given substring.
static void	killStatementMatch(String s, boolean cancelOnly) Kills all statements executing SQL that matches a given substring.

Methods inherited from class java.lang.Object

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

Field Detail

tracer

static Logger tracer

Constructor Detail

FarragoKillUDR

public FarragoKillUDR()

Method Detail

killSession

public static void killSession(long id)
                        throws SQLException

Kills a running session, destroying it and releasing any resources associated with it.

Parameters:

id - unique session identifier

Throws:

SQLException

killSession

public static void killSession(long id,
                               boolean cancelOnly)
                        throws SQLException

Kills a running session.

Parameters:

id - unique session identifier

cancelOnly - if true, just cancel current execution; if false, destroy session

Throws:

SQLException

killStatement

public static void killStatement(long id)
                          throws SQLException

Kills an executing statement, destroying it and releasing any resources associated with it.

Parameters:

id - unique statement identifier

Throws:

SQLException

killStatement

public static void killStatement(long id,
                                 boolean cancelOnly)
                          throws SQLException

Kills an executing statement.

Parameters:

id - unique statement identifier

cancelOnly - if true, just cancel current execution; if false, destroy statement

Throws:

SQLException

killStatementMatch

public static void killStatementMatch(String s)
                               throws SQLException

Kills all statements executing SQL that matches a given substring.

Parameters:

s - substring to look for in statement SQL text

Throws:

SQLException

killStatementMatch

public static void killStatementMatch(String s,
                                      boolean cancelOnly)
                               throws SQLException

Kills all statements executing SQL that matches a given substring.

Parameters:

s - substring to look for in statement SQL text

cancelOnly - if true, just cancel current execution; if false, destroy statement

Throws:

SQLException