com.aspc.commander.sql

Class CursorCommand

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.CursorCommand

public class CursorCommand
extends Command

Cursor handling.
Syntax

  CURSOR [FETCH name, offset, size] | [ CLOSE name] | [SET option]
  

Usage

  /* Returns the next 100 rows from position 200 */
  CURSOR FETCH c1, 200, 100; 
  
  /* Closes the cursor of c1 */
  CURSOR CLOSE c1; 
  
  /* Sets the global option to request rowcount */
  CURSOR SET rowcount=true;
  

THREAD MODE: SINGLE THREADED command

Since:

3 December 2003

Author:

Nigel Leck

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
void	appendResult(org.w3c.dom.Element group, int seq) append the results.
protected void	execute(Parser p) execute the command.

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

Constructor Detail

CursorCommand

public CursorCommand(Connection connection,
                     Pattern pattern)

std. Command.

Parameters:

connection - the connection

pattern - the pattern

Method Detail

appendResult

public final void appendResult(org.w3c.dom.Element group,
                               int seq)
                        throws java.lang.Exception

append the results.

Specified by:

appendResult in class Command

Parameters:

group - the result group.

seq - the sequence.

Throws:

java.lang.Exception - a serious problem

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