public class SQLCall extends DatabaseCall implements QueryStringCall
Modifier and Type | Field and Description |
---|---|
protected boolean |
hasCustomSQLArguments |
fields, firstResult, hasOptimisticLock, isCallableStatementRequired, isCursorOutputProcedure, isFieldMatchingRequired, isResultSetScrollable, maxRows, queryTimeout, result, resultSetConcurrency, resultSetType, returnsResultSet, shouldBuildOutputRow, shouldCacheStatement, sqlString, statement, usesBinding
CUSTOM_MODIFY, IN, INOUT, isPrepared, LITERAL, MODIFY, NO_RETURN, OUT, OUT_CURSOR, parameters, parameterTypes, query, RETURN_CURSOR, RETURN_MANY_ROWS, RETURN_ONE_ROW, returnType, TRANSLATION
Constructor and Description |
---|
SQLCall()
PUBLIC:
Create a new SQL call.
|
SQLCall(java.lang.String sqlString)
PUBLIC:
Create a new SQL call.
|
Modifier and Type | Method and Description |
---|---|
protected void |
afterTranslateCustomQuery(java.util.Vector updatedParameters,
java.util.Vector updatedParameterTypes)
INTERNAL:
Set the data passed through setCustomSQLArgumentType and useCustomSQLCursorOutputAsResultSet methods.
|
protected void |
afterTranslateCustomQueryUpdateParameter(DatabaseField field,
int index,
java.lang.Integer parameterType,
java.util.Vector updatedParameters,
java.util.Vector updatedParameterTypes)
INTERNAL:
Set the data passed through setCustomSQLArgumentType and useCustomSQLCursorOutputAsResultSet methods.
|
void |
appendTranslationParameter(java.io.Writer writer,
ParameterExpression expression,
DatabasePlatform platform)
INTERNAL:
All values are printed as ? to allow for parameter binding or translation during the execute of the call.
|
boolean |
hasCustomSQLArguments()
INTERNAL:
Used to avoid misiterpreting the # in custom SQL.
|
boolean |
isQueryStringCall()
Should return true.
|
boolean |
isSQLCall() |
protected void |
prepareInternal(AbstractSession session)
INTERNAL:
Called by prepare method only.
|
void |
setCustomSQLArgumentType(java.lang.String customParameterName,
java.lang.Class type)
PUBLIC:
This method should only be used with custom SQL:
it sets a type to OUT or INOUT parameter (prefixed with ### or #### in custom SQL string).
|
void |
setHasCustomSQLArguments(boolean hasCustomSQLArguments)
INTERNAL:
Used to avoid misiterpreting the # in custom SQL.
|
void |
setSQLString(java.lang.String sqlString)
Set the SQL string.
|
void |
useCustomSQLCursorOutputAsResultSet(java.lang.String customParameterName)
PUBLIC:
This method should only be used with custom SQL:
Used for Oracle result sets through procedures.
|
addContext, appendIn, appendInOut, appendInOut, appendLogParameters, appendOut, appendOutCursor, appendParameter, bindParameter, buildNewQueryMechanism, buildOutputRow, buildQueryMechanism, createInOutParameter, getCallString, getContexts, getCursorOutIndex, getFields, getFieldWithTypeFromDescriptor, getFirstResult, getLogString, getMaxRows, getOutputRowFields, getQueryString, getResult, getResultSetConcurrency, getResultSetType, getReturnsResultSet, getSQLString, getStatement, hasOptimisticLock, isCallableStatementRequired, isCursorOutputProcedure, isCursorReturned, isDynamicCall, isFieldMatchingRequired, isFinished, isLOBLocatorNeeded, isNonCursorOutputProcedure, isResultSetScrollable, matchFieldOrder, prepare, prepareStatement, setContexts, setFields, setFirstResult, setHasOptimisticLock, setIsCallableStatementRequired, setIsCursorOutputProcedure, setIsFieldMatchingRequired, setIsResultSetScrollable, setMaxRows, setQueryString, setResult, setResultSetConcurrency, setResultSetType, setReturnsResultSet, setShouldBuildOutputRow, setShouldCacheStatement, setSQLStringInternal, setStatement, setUsesBinding, shouldBuildOutputRow, shouldCacheStatement, shouldCacheStatement, toString, translate, usesBinding, usesBinding, useUnnamedCursorOutputAsResultSet
appendIn, appendInOut, appendLiteral, appendModify, appendOut, appendTranslation, areManyRowsReturned, argumentMarker, clone, createField, getParameters, getParameterTypes, getQuery, getReturnType, getValueForInOutParameter, getValueForInParameter, hasParameters, isEISInteraction, isEJBQLCall, isNothingReturned, isOneRowReturned, isOutputParameterType, isPrepared, isStoredFunctionCall, isStoredProcedureCall, returnCursor, returnManyRows, returnNothing, returnOneRow, setIsPrepared, setParameters, setParameterTypes, setQuery, setReturnType, translateCustomQuery, translatePureSQLCustomQuery, translateQueryString, whitespace
equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
appendLiteral, appendModify, appendParameter, appendTranslation, getParameters, getParameterTypes, getQueryString, hasParameters, prepare, setQueryString, translate, translateCustomQuery, translateQueryString
buildNewQueryMechanism, buildQueryMechanism, clone, getLogString, isFinished
public SQLCall()
public SQLCall(java.lang.String sqlString)
protected void afterTranslateCustomQuery(java.util.Vector updatedParameters, java.util.Vector updatedParameterTypes)
protected void afterTranslateCustomQueryUpdateParameter(DatabaseField field, int index, java.lang.Integer parameterType, java.util.Vector updatedParameters, java.util.Vector updatedParameterTypes)
public boolean hasCustomSQLArguments()
public boolean isSQLCall()
isSQLCall
in class DatasourceCall
public boolean isQueryStringCall()
QueryStringCall
isQueryStringCall
in interface QueryStringCall
isQueryStringCall
in class DatasourceCall
protected void prepareInternal(AbstractSession session)
prepareInternal
in class DatabaseCall
public void setHasCustomSQLArguments(boolean hasCustomSQLArguments)
public void setCustomSQLArgumentType(java.lang.String customParameterName, java.lang.Class type)
public void setSQLString(java.lang.String sqlString)
public void appendTranslationParameter(java.io.Writer writer, ParameterExpression expression, DatabasePlatform platform) throws java.io.IOException
java.io.IOException
public void useCustomSQLCursorOutputAsResultSet(java.lang.String customParameterName)