HyperSQL Database 2.7.4 · org.hsqldb.Routine · APIdia, the JavaDoc alternative

Field Summary

Modifier and Type	Field and Description
public static final int	CONTAINS_SQL
pack-priv int	cursorCount
pack-priv int	dataImpact
pack-priv static final Routine[]	emptyArray Hides org.hsqldb.SchemaObject.emptyArray, org.hsqldb.RangeGroup.emptyArray.
pack-priv boolean	isAggregate
pack-priv boolean	isDeterministic
pack-priv boolean	isIndex
private boolean	isLibraryRoutine
pack-priv boolean	isNewSavepointLevel
pack-priv boolean	isNullInputOutput
pack-priv boolean	isRecursive
pack-priv boolean	isSearch
pack-priv Method	javaMethod
pack-priv boolean	javaMethodWithConnection
pack-priv int	language
public static final int	LANGUAGE_JAVA
public static final int	LANGUAGE_SQL
pack-priv int	maxDynamicResults
private String	methodName
public static final int	MODIFIES_SQL
private HsqlNameManager.HsqlName	name
public static final int	NO_SQL
public static final int	PARAM_STYLE_JAVA
public static final int	PARAM_STYLE_SQL
pack-priv OrderedHashMap<String, ColumnSchema>	parameterList
pack-priv int	parameterStyle
pack-priv Type[]	parameterTypes
pack-priv RangeVariable[]	ranges
public static final int	READS_SQL
pack-priv OrderedHashSet<HsqlNameManager.HsqlName>	references
pack-priv boolean	returnsTable
pack-priv Table	returnTable
pack-priv Type	returnType
pack-priv RoutineSchema	routineSchema
pack-priv final int	routineType
private HsqlNameManager.HsqlName	specificName
pack-priv Statement	statement
pack-priv int	triggerOperation
pack-priv Table	triggerTable
pack-priv int	triggerType
pack-priv int	typeGroups
pack-priv int	variableCount

Constructor Summary

Access	Constructor and Description
public	Routine(int type)
public	Routine(Table table, RangeVariable[] ranges, int impact, int triggerType, int operationType)

Method Summary

Modifier and Type	Method and Description
public void	addParameter(ColumnSchema param)
pack-priv void	checkSQLData(Session session)
public void	compile(Session session, SchemaObject parentObject) Overrides default org.hsqldb.SchemaObject.compile.
pack-priv Object[]	convertArgsToJava(Session session, Object[] callArguments)
pack-priv void	convertArgsToSQL(Session session, Object[] callArguments, Object[] data)
public static void	createRoutines(Session session, HsqlNameManager.HsqlName schema, String name) simply named function only - requires return type
public Routine	duplicate()
public HsqlNameManager.HsqlName	getCatalogName() Implements org.hsqldb.SchemaObject.getCatalogName.
public long	getChangeTimestamp() Implements org.hsqldb.SchemaObject.getChangeTimestamp.
public int	getCursorCount()
public int	getDataImpact()
public String	getDataImpactString()
private String	getDefinitionSQL(boolean withBody)
public String	getExternalName()
public int	getLanguage()
public int	getMaxDynamicResults()
public Method	getMethod()
pack-priv static Method	getMethod(String name, Routine routine, boolean[] hasConnection, boolean returnsTable)
pack-priv static Method[]	getMethods(String name)
public HsqlNameManager.HsqlName	getName() Implements org.hsqldb.SchemaObject.getName.
public Grantee	getOwner() Implements org.hsqldb.SchemaObject.getOwner.
public ColumnSchema	getParameter(int i)
public int	getParameterCount()
public int	getParameterCount(int type)
public int	getParameterIndex(String name)
pack-priv int	getParameterSignature()
pack-priv Type[]	getParameterTypes()
public Statement	getProcedure()
public RangeVariable[]	getRangeVariables() Implements org.hsqldb.RangeGroup.getRangeVariables.
public OrderedHashSet<HsqlNameManager.HsqlName>	getReferences() Overrides default org.hsqldb.SchemaObject.getReferences.
public Type	getReturnType()
public HsqlNameManager.HsqlName	getSchemaName() Implements org.hsqldb.SchemaObject.getSchemaName.
public HsqlNameManager.HsqlName	getSpecificName()
public String	getSQL() Implements org.hsqldb.SchemaObject.getSQL.
public String	getSQLAlter()
public String	getSQLBodyDefinition()
public String	getSQLDeclaration()
public Table	getTable()
public HsqlNameManager.HsqlName[]	getTableNamesForRead()
public HsqlNameManager.HsqlName[]	getTableNamesForWrite()
public int	getType() Implements org.hsqldb.SchemaObject.getType.
public int	getVariableCount()
public Result	invoke(Session session, Object[] data, Object[] aggregateData, boolean push)
pack-priv Result	invokeJavaMethod(Session session, Object[] data)
public Result	invokeJavaMethodDirect(Object[] data)
public boolean	isAggregate()
public boolean	isDeterministic()
public boolean	isFunction()
public boolean	isLibraryRoutine()
public boolean	isNullInputOutput()
public boolean	isProcedure()
pack-priv boolean	isPSM()
public boolean	isTrigger()
public boolean	isVariable() Implements org.hsqldb.RangeGroup.isVariable.
public static Routine	newRoutine(Session session, Method method) Returns a new function Routine object based solely on a Java Method object.
public static Routine[]	newRoutines(Session session, Method[] methods)
public void	resetAlteredRoutineSettings()
public void	resolve(Session session)
pack-priv void	resolveReferences(Session session)
public boolean	returnsTable()
public void	setAggregate(boolean isAggregate)
public void	setAsAlteredRoutine(Routine routine)
public void	setCorrelated() Implements org.hsqldb.RangeGroup.setCorrelated.
public void	setDataImpact(int impact)
public void	setDeterministic(boolean value)
public void	setLanguage(int lang)
public void	setMaxDynamicResults(int value)
public void	setMethod(Method method)
public void	setMethodURL(String url)
public void	setName(HsqlNameManager.HsqlName name)
public void	setNewSavepointLevel(boolean value)
public void	setNullInputOutput(boolean value)
public void	setParameterStyle(int style)
public void	setProcedure(Statement statement)
private void	setReferences()
public void	setReturnTable(TableDerived table)
public void	setReturnType(Type type)
public void	setSpecificName(HsqlNameManager.HsqlName name)

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

CONTAINS_SQL	back to summary
public static final int CONTAINS_SQL

cursorCount	back to summary
pack-priv int cursorCount

dataImpact	back to summary
pack-priv int dataImpact

emptyArray	back to summary
pack-priv static final Routine[] emptyArray Hides org.hsqldb.SchemaObject.emptyArray, org.hsqldb.RangeGroup.emptyArray.

isAggregate	back to summary
pack-priv boolean isAggregate

isDeterministic	back to summary
pack-priv boolean isDeterministic

isIndex	back to summary
pack-priv boolean isIndex

isLibraryRoutine	back to summary
private boolean isLibraryRoutine

isNewSavepointLevel	back to summary
pack-priv boolean isNewSavepointLevel

isNullInputOutput	back to summary
pack-priv boolean isNullInputOutput

isRecursive	back to summary
pack-priv boolean isRecursive

isSearch	back to summary
pack-priv boolean isSearch

javaMethod	back to summary
pack-priv Method javaMethod

javaMethodWithConnection	back to summary
pack-priv boolean javaMethodWithConnection

language	back to summary
pack-priv int language

LANGUAGE_JAVA	back to summary
public static final int LANGUAGE_JAVA

LANGUAGE_SQL	back to summary
public static final int LANGUAGE_SQL

maxDynamicResults	back to summary
pack-priv int maxDynamicResults

methodName	back to summary
private String methodName

MODIFIES_SQL	back to summary
public static final int MODIFIES_SQL

name	back to summary
private HsqlNameManager.HsqlName name

NO_SQL	back to summary
public static final int NO_SQL

PARAM_STYLE_JAVA	back to summary
public static final int PARAM_STYLE_JAVA

PARAM_STYLE_SQL	back to summary
public static final int PARAM_STYLE_SQL

parameterList	back to summary
pack-priv OrderedHashMap<String, ColumnSchema> parameterList

parameterStyle	back to summary
pack-priv int parameterStyle

parameterTypes	back to summary
pack-priv Type[] parameterTypes

ranges	back to summary
pack-priv RangeVariable[] ranges

READS_SQL	back to summary
public static final int READS_SQL

references	back to summary
pack-priv OrderedHashSet<HsqlNameManager.HsqlName> references

returnsTable	back to summary
pack-priv boolean returnsTable

returnTable	back to summary
pack-priv Table returnTable

returnType	back to summary
pack-priv Type returnType

routineSchema	back to summary
pack-priv RoutineSchema routineSchema

routineType	back to summary
pack-priv final int routineType

specificName	back to summary
private HsqlNameManager.HsqlName specificName

statement	back to summary
pack-priv Statement statement

triggerOperation	back to summary
pack-priv int triggerOperation

triggerTable	back to summary
pack-priv Table triggerTable

triggerType	back to summary
pack-priv int triggerType

typeGroups	back to summary
pack-priv int typeGroups

variableCount	back to summary
pack-priv int variableCount

Constructor Detail

Routine	back to summary
public Routine(int type)

Routine	back to summary
public Routine(Table table, RangeVariable[] ranges, int impact, int triggerType, int operationType)

Method Detail

addParameter	back to summary
public void addParameter(ColumnSchema param)

checkSQLData	back to summary
pack-priv void checkSQLData(Session session)

compile	back to summary
public void compile(Session session, SchemaObject parentObject) Overrides default org.hsqldb.SchemaObject.compile.

convertArgsToJava	back to summary
pack-priv Object[] convertArgsToJava(Session session, Object[] callArguments)

convertArgsToSQL	back to summary
pack-priv void convertArgsToSQL(Session session, Object[] callArguments, Object[] data)

createRoutines	back to summary
public static void createRoutines(Session session, HsqlNameManager.HsqlName schema, String name) simply named function only - requires return type

duplicate	back to summary
public Routine duplicate()

getCatalogName	back to summary
public HsqlNameManager.HsqlName getCatalogName() Implements org.hsqldb.SchemaObject.getCatalogName.

getChangeTimestamp	back to summary
public long getChangeTimestamp() Implements org.hsqldb.SchemaObject.getChangeTimestamp.

getCursorCount	back to summary
public int getCursorCount()

getDataImpact	back to summary
public int getDataImpact()

getDataImpactString	back to summary
public String getDataImpactString()

getDefinitionSQL	back to summary
private String getDefinitionSQL(boolean withBody)

getExternalName	back to summary
public String getExternalName()

getLanguage	back to summary
public int getLanguage()

getMaxDynamicResults	back to summary
public int getMaxDynamicResults()

getMethod	back to summary
public Method getMethod()

getMethod	back to summary
pack-priv static Method getMethod(String name, Routine routine, boolean[] hasConnection, boolean returnsTable)

getMethods	back to summary
pack-priv static Method[] getMethods(String name)

getName	back to summary
public HsqlNameManager.HsqlName getName() Implements org.hsqldb.SchemaObject.getName.

getOwner	back to summary
public Grantee getOwner() Implements org.hsqldb.SchemaObject.getOwner.

getParameter	back to summary
public ColumnSchema getParameter(int i)

getParameterCount	back to summary
public int getParameterCount()

getParameterCount	back to summary
public int getParameterCount(int type)

getParameterIndex	back to summary
public int getParameterIndex(String name)

getParameterSignature	back to summary
pack-priv int getParameterSignature()

getParameterTypes	back to summary
pack-priv Type[] getParameterTypes()

getProcedure	back to summary
public Statement getProcedure()

getRangeVariables	back to summary
public RangeVariable[] getRangeVariables() Implements org.hsqldb.RangeGroup.getRangeVariables.

getReferences	back to summary
public OrderedHashSet<HsqlNameManager.HsqlName> getReferences() Overrides default org.hsqldb.SchemaObject.getReferences.

getReturnType	back to summary
public Type getReturnType()

getSchemaName	back to summary
public HsqlNameManager.HsqlName getSchemaName() Implements org.hsqldb.SchemaObject.getSchemaName.

getSpecificName	back to summary
public HsqlNameManager.HsqlName getSpecificName()

getSQL	back to summary
public String getSQL() Implements org.hsqldb.SchemaObject.getSQL.

getSQLAlter	back to summary
public String getSQLAlter()

getSQLBodyDefinition	back to summary
public String getSQLBodyDefinition()

getSQLDeclaration	back to summary
public String getSQLDeclaration()

getTable	back to summary
public Table getTable()

getTableNamesForRead	back to summary
public HsqlNameManager.HsqlName[] getTableNamesForRead()

getTableNamesForWrite	back to summary
public HsqlNameManager.HsqlName[] getTableNamesForWrite()

getType	back to summary
public int getType() Implements org.hsqldb.SchemaObject.getType.

getVariableCount	back to summary
public int getVariableCount()

invoke	back to summary
public Result invoke(Session session, Object[] data, Object[] aggregateData, boolean push)

invokeJavaMethod	back to summary
pack-priv Result invokeJavaMethod(Session session, Object[] data)

invokeJavaMethodDirect	back to summary
public Result invokeJavaMethodDirect(Object[] data)

isAggregate	back to summary
public boolean isAggregate()

isDeterministic	back to summary
public boolean isDeterministic()

isFunction	back to summary
public boolean isFunction()

isLibraryRoutine	back to summary
public boolean isLibraryRoutine()

isNullInputOutput	back to summary
public boolean isNullInputOutput()

isProcedure	back to summary
public boolean isProcedure()

isPSM	back to summary
pack-priv boolean isPSM()

isTrigger	back to summary
public boolean isTrigger()

isVariable	back to summary
public boolean isVariable() Implements org.hsqldb.RangeGroup.isVariable.

newRoutine	back to summary
public static Routine newRoutine(Session session, Method method) Returns a new function Routine object based solely on a Java Method object.

newRoutines	back to summary
public static Routine[] newRoutines(Session session, Method[] methods)

resetAlteredRoutineSettings	back to summary
public void resetAlteredRoutineSettings()

resolve	back to summary
public void resolve(Session session)

resolveReferences	back to summary
pack-priv void resolveReferences(Session session)

returnsTable	back to summary
public boolean returnsTable()

setAggregate	back to summary
public void setAggregate(boolean isAggregate)

setAsAlteredRoutine	back to summary
public void setAsAlteredRoutine(Routine routine)

setCorrelated	back to summary
public void setCorrelated() Implements org.hsqldb.RangeGroup.setCorrelated.

setDataImpact	back to summary
public void setDataImpact(int impact)

setDeterministic	back to summary
public void setDeterministic(boolean value)

setLanguage	back to summary
public void setLanguage(int lang)

setMaxDynamicResults	back to summary
public void setMaxDynamicResults(int value)

setMethod	back to summary
public void setMethod(Method method)

setMethodURL	back to summary
public void setMethodURL(String url)

setName	back to summary
public void setName(HsqlNameManager.HsqlName name)

setNewSavepointLevel	back to summary
public void setNewSavepointLevel(boolean value)

setNullInputOutput	back to summary
public void setNullInputOutput(boolean value)

setParameterStyle	back to summary
public void setParameterStyle(int style)

setProcedure	back to summary
public void setProcedure(Statement statement)

setReferences	back to summary
private void setReferences()

setReturnTable	back to summary
public void setReturnTable(TableDerived table)

setReturnType	back to summary
public void setReturnType(Type type)

setSpecificName	back to summary
public void setSpecificName(HsqlNameManager.HsqlName name)

public Class Routine

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail