org.objectweb.cjdbc.sql
Class StoredProcedure

java.lang.Object
  org.objectweb.cjdbc.sql.AbstractRequest
      org.objectweb.cjdbc.sql.StoredProcedure

All Implemented Interfaces:

java.io.Serializable

public class StoredProcedure

extends AbstractRequest

A StoredProcedure is a SQL request with the following syntax:

   {call <procedure-name>[<arg1>,<arg2>, ...]}
 

Version:

1.0

Author:

Emmanuel Cecchet

See Also:

Serialized Form

Field Summary

Fields inherited from class org.objectweb.cjdbc.sql.AbstractRequest

cacheable, escapeProcessing, id, isAutoCommit, isParsed, isReadOnly, login, maxRows, sqlQuery, sqlSkeleton, timeout, transactionId

Constructor Summary

StoredProcedure(java.lang.String sqlQuery, boolean escapeProcessing, int timeout)
Creates a new StoredProcedure instance.

Method Summary

void	cloneParsing(AbstractRequest request) Always throws a SQLException: it is useless to parse a stored procedure call since we can't know which tables are affected by this procedure.
boolean	isReadRequest() Returns true if this request is a read request (SELECT requests for example perform a read).
boolean	isUnknownRequest() Returns true if the resulting operation on this request is unknown (some non-standard command or stored procedure for example).
boolean	isWriteRequest() Returns true if this request is a write request (INSERT or UPDATE for example perform writes).
void	parse(DatabaseSchema schema, int granularity, boolean isCaseSensitive) Always throws a SQLException: it is useless to parse a stored procedure call since we can't know which tables are affected by this procedure.

Methods inherited from class org.objectweb.cjdbc.sql.AbstractRequest

debug, equals, getCacheAbility, getEscapeProcessing, getId, getLogin, getMaxRows, getSQL, getSqlSkeleton, getTimeout, getTransactionId, isAutoCommit, isParsed, isReadOnly, setCacheAbility, setId, setIsAutoCommit, setIsReadOnly, setLogin, setMaxRows, setSQL, setSqlSkeleton, setTimeout, setTransactionId, trimCarriageReturn

Methods inherited from class java.lang.Object

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

Constructor Detail

StoredProcedure

public StoredProcedure(java.lang.String sqlQuery,
                       boolean escapeProcessing,
                       int timeout)

Creates a new StoredProcedure instance.

Parameters:

sqlQuery - the SQL request

escapeProcessing - should the driver to escape processing before sending to the database ?

timeout - an int value

See Also:

parse(org.objectweb.cjdbc.sql.schema.DatabaseSchema, int, boolean)

Method Detail

isReadRequest

public boolean isReadRequest()

Description copied from class: AbstractRequest

Returns true if this request is a read request (SELECT requests for example perform a read).

Specified by:

isReadRequest in class AbstractRequest

Returns:

false

See Also:

AbstractRequest.isReadRequest()

isWriteRequest

public boolean isWriteRequest()

Description copied from class: AbstractRequest

Returns true if this request is a write request (INSERT or UPDATE for example perform writes).

Specified by:

isWriteRequest in class AbstractRequest

Returns:

false

See Also:

AbstractRequest.isWriteRequest()

isUnknownRequest

public boolean isUnknownRequest()

Description copied from class: AbstractRequest

Returns true if the resulting operation on this request is unknown (some non-standard command or stored procedure for example).

Specified by:

isUnknownRequest in class AbstractRequest

Returns:

true

See Also:

AbstractRequest.isUnknownRequest()

parse

public void parse(DatabaseSchema schema,
                  int granularity,
                  boolean isCaseSensitive)
           throws java.sql.SQLException

Always throws a SQLException: it is useless to parse a stored procedure call since we can't know which tables are affected by this procedure.

Specified by:

parse in class AbstractRequest

Parameters:

schema - a DatabaseSchema value

granularity - parsing granularity as defined in ParsingGranularities

isCaseSensitive - true if parsing must be case sensitive

Throws:

java.sql.SQLException - if the parsing fails

See Also:

AbstractRequest.parse(org.objectweb.cjdbc.sql.schema.DatabaseSchema, int, boolean)

cloneParsing

public void cloneParsing(AbstractRequest request)

Always throws a SQLException: it is useless to parse a stored procedure call since we can't know which tables are affected by this procedure.

Specified by:

cloneParsing in class AbstractRequest

Parameters:

request - the parsed request to clone

See Also:

AbstractRequest.cloneParsing(AbstractRequest)