public class SQLCall extends DatabaseCall implements QueryStringCall
FIRSTRESULT_FIELD, MAXROW_FIELD
CUSTOM_MODIFY, IN, INLINE, INOUT, LITERAL, MODIFY, OUT, OUT_CURSOR, 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 |
---|---|
void |
appendTranslationParameter(java.io.Writer writer,
ParameterExpression expression,
DatabasePlatform platform,
AbstractRecord record)
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 misinterpreting the # in custom SQL.
|
boolean |
isQueryStringCall()
Should return true.
|
boolean |
isSQLCall() |
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 IN, OUT or INOUT parameter (prefixed with #, ### or #### in custom SQL string).
|
void |
setCustomSQLArgumentType(java.lang.String argumentFieldName,
int type)
PUBLIC:
This method should only be used with custom SQL:
it sets a type to IN, OUT or INOUT parameter (prefixed with #, ### or #### in custom SQL string).
|
void |
setCustomSQLArgumentType(java.lang.String argumentFieldName,
int type,
java.lang.String typeName)
PUBLIC:
This method should only be used with custom SQL:
it sets a type to IN, OUT or INOUT parameter (prefixed with #, ### or #### in custom SQL string).
|
void |
setCustomSQLArgumentType(java.lang.String argumentFieldName,
int type,
java.lang.String typeName,
java.lang.Class javaType)
PUBLIC:
This method should only be used with custom SQL:
it sets a type to IN, OUT or INOUT parameter (prefixed with #, ### or #### in custom SQL string).
|
void |
setCustomSQLArgumentType(java.lang.String argumentFieldName,
int type,
java.lang.String typeName,
java.lang.Class javaType,
DatabaseField nestedType)
PUBLIC:
This method should only be used with custom SQL:
it sets a type to IN, OUT or INOUT parameter (prefixed with #, ### or #### in custom SQL string).
|
void |
setCustomSQLArgumentType(java.lang.String argumentFieldName,
int type,
java.lang.String typeName,
DatabaseField nestedType)
PUBLIC:
This method should only be used with custom SQL:
it sets a type to IN, OUT or INOUT parameter (prefixed with #, ### or #### in custom SQL string).
|
void |
setHasCustomSQLArguments(boolean hasCustomSQLArguments)
INTERNAL:
Used to avoid misinterpreting the # in custom SQL.
|
void |
setSQLString(java.lang.String sqlString)
Set the SQL string.
|
void |
translateCustomQuery()
INTERNAL:
Keep track of the fact that this call has been translated.
|
void |
translatePureSQLCustomQuery()
INTERNAL:
Only translate the call if it was not previously translated
This code ensures the translation code for a custom SQLCall is only run once
In the case of inheritance we will try to call the translation code once to get the
list of types and again for each subclass
|
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, getCallString, getContexts, getCursorOutIndex, getExecuteReturnValue, getFields, getFieldsArray, getFirstResult, getLogString, getMaxRows, getOutputCursors, getOutputRowFields, getQueryString, getQueryTimeout, getResult, getResultSetConcurrency, getResultSetFetchSize, getResultSetType, getReturnsResultSet, getSQLString, getStatement, hasAllocatedConnection, hasMultipleResultSets, hasOptimisticLock, hasOutputCursors, isBatchExecutionSupported, isCursorOutputProcedure, isCursorReturned, isFieldMatchingRequired, isFinished, isLOBLocatorNeeded, isMultipleCursorOutputProcedure, isNonCursorOutputProcedure, isResultSetScrollable, isUsesBindingSet, matchFieldOrder, prepare, prepareStatement, returnMultipleResultSetCollections, setBatchExecutionSupported, setContexts, setExecuteReturnValue, setFields, setFirstResult, setHasAllocatedConnection, setHasMultipleResultSets, setHasOptimisticLock, setIgnoreFirstRowSetting, setIgnoreMaxResultsSetting, setIsCursorOutputProcedure, setIsFieldMatchingRequired, setIsMultipleCursorOutputProcedure, setIsResultSetScrollable, setMaxRows, setQueryString, setQueryTimeout, setResult, setResultSetConcurrency, setResultSetFetchSize, setResultSetType, setReturnMultipleResultSetCollections, setReturnsResultSet, setShouldCacheStatement, setStatement, setUsesBinding, shouldBuildOutputRow, shouldCacheStatement, shouldCacheStatement, shouldIgnoreFirstRowSetting, shouldIgnoreMaxResultsSetting, toString, translate, translateQueryStringForParameterizedIN, usesBinding, usesBinding, useUnnamedCursorOutputAsResultSet
appendIn, appendInOut, appendLiteral, appendModify, appendOut, appendTranslation, areManyRowsReturned, clone, getParameters, getParameterTypes, getQuery, getReturnType, hasParameters, isEISInteraction, isExecuteUpdate, isJPQLCall, isNativeConnectionRequired, isNothingReturned, isOneRowReturned, isOutputParameterType, isPrepared, isReturnSet, isStoredFunctionCall, isStoredPLSQLFunctionCall, isStoredPLSQLProcedureCall, isStoredProcedureCall, returnCursor, returnManyRows, returnNothing, returnOneRow, setExecuteUpdate, setIsNativeConnectionRequired, setIsPrepared, setParameters, setParameterTypes, setQuery, setReturnType, translateQueryString
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
appendLiteral, appendModify, appendParameter, appendTranslation, getParameters, getParameterTypes, getQueryString, hasParameters, prepare, setQueryString, translate, translateQueryString
buildNewQueryMechanism, buildQueryMechanism, clone, getLogString, isFinished, isNothingReturned, isOneRowReturned
public SQLCall()
public SQLCall(java.lang.String sqlString)
public boolean hasCustomSQLArguments()
public boolean isSQLCall()
isSQLCall
in class DatasourceCall
public boolean isQueryStringCall()
QueryStringCall
isQueryStringCall
in interface QueryStringCall
isQueryStringCall
in class DatasourceCall
public void setHasCustomSQLArguments(boolean hasCustomSQLArguments)
public void setCustomSQLArgumentType(java.lang.String customParameterName, java.lang.Class type)
public void setCustomSQLArgumentType(java.lang.String argumentFieldName, int type)
public void setCustomSQLArgumentType(java.lang.String argumentFieldName, int type, java.lang.String typeName)
public void setCustomSQLArgumentType(java.lang.String argumentFieldName, int type, java.lang.String typeName, java.lang.Class javaType)
public void setCustomSQLArgumentType(java.lang.String argumentFieldName, int type, java.lang.String typeName, DatabaseField nestedType)
public void setCustomSQLArgumentType(java.lang.String argumentFieldName, int type, java.lang.String typeName, java.lang.Class javaType, DatabaseField nestedType)
public void setSQLString(java.lang.String sqlString)
public void translateCustomQuery()
translateCustomQuery
in interface QueryStringCall
translateCustomQuery
in class DatasourceCall
public void translatePureSQLCustomQuery()
translatePureSQLCustomQuery
in class DatasourceCall
public void appendTranslationParameter(java.io.Writer writer, ParameterExpression expression, DatabasePlatform platform, AbstractRecord record) throws java.io.IOException
java.io.IOException
public void useCustomSQLCursorOutputAsResultSet(java.lang.String customParameterName)
EclipseLink 2.6.3, "build v20160428-59c81c5" API Reference