public class DB2ZPlatform extends DB2Platform
This provides for some additional compatibility in certain DB2 versions.
Responsibilities:
DEFAULT_VARCHAR_SIZE
batchWritingMechanism, castSizeForVarcharParameter, classTypes, cursorCode, DEFAULT_MAX_BATCH_WRITING_SIZE, DEFAULT_PARAMETERIZED_MAX_BATCH_WRITING_SIZE, driverName, driverSupportsNationalCharacterVarying, fieldTypes, IS_VALID_TIMEOUT, isCastRequired, maxBatchWritingSize, partitioningCallback, pingSQL, printInnerJoinInWhereClause, printOuterJoinInWhereClause, shouldBindAllParameters, shouldBindLiterals, shouldBindPartialParameters, shouldCacheAllStatements, shouldCreateIndicesOnForeignKeys, shouldForceBindAllParameters, shouldForceFieldNamesToUpperCase, shouldIgnoreCaseOnFieldComparisons, shouldOptimizeDataConversion, shouldTrimStrings, statementCacheSize, storedProcedureTerminationToken, stringBindingSize, structConverters, supportsAutoCommit, tableCreationSuffix, transactionIsolation, typeConverters, Types_NCLOB, Types_SQLXML, useJDBCStoredProcedureSyntax, useNationalCharacterVarying, useRownumFiltering, usesBatchWriting, usesByteArrayBinding, usesJDBCBatchWriting, usesNativeBatchWriting, usesNativeSQL, usesStreamsForBinding, usesStringBinding
conversionManager, dataTypesConvertedFromAClass, dataTypesConvertedToAClass, defaultNativeSequenceToTable, defaultSeqenceAtNextValue, defaultSequence, endDelimiter, platformOperators, sequences, sequencesLock, startDelimiter, supportsReturnGeneratedKeys, tableQualifier, timestampQuery
Constructor and Description |
---|
DB2ZPlatform() |
Modifier and Type | Method and Description |
---|---|
protected ExpressionOperator |
absOperator()
Disable binding support.
|
protected ExpressionOperator |
avgOperator()
Disable binding support.
|
protected ExpressionOperator |
betweenOperator()
DB2 z/OS requires that at least one argument be a known type
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a
predicate or expression where parameter markers have been used as operands of
the same operator for example: ?
|
protected java.util.Hashtable |
buildFieldTypes() |
java.lang.String |
buildProcedureCallString(StoredProcedureCall call,
org.eclipse.persistence.internal.sessions.AbstractSession session,
org.eclipse.persistence.internal.sessions.AbstractRecord row)
INTERNAL: Used for sp calls.
|
protected ExpressionOperator |
concatOperator()
DB2 z/OS requires that at least one argument be a known type
With binding enabled, DB2 z/OS will throw an error:
The statement cannot be executed because a parameter marker has been used
in an invalid way.
|
protected ExpressionOperator |
equalOperator()
DB2 z/OS requires that at least one argument be a known type
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a
predicate or expression where parameter markers have been used as operands of
the same operator for example: ?
|
java.lang.Object |
getParameterValueFromDatabaseCall(java.sql.CallableStatement statement,
java.lang.String name,
org.eclipse.persistence.internal.sessions.AbstractSession session) |
java.lang.String |
getProcedureArgument(java.lang.String name,
java.lang.Object parameter,
org.eclipse.persistence.internal.databaseaccess.DatasourceCall.ParameterType parameterType,
StoredProcedureCall call,
org.eclipse.persistence.internal.sessions.AbstractSession session)
Obtain the platform specific argument string
|
java.lang.String |
getProcedureOptionList()
DB2 on Z uses ":" as prefix for procedure arguments.
|
java.lang.String |
getTableCreationSuffix() |
protected ExpressionOperator |
greaterThanEqualOperator()
DB2 z/OS requires that at least one argument be a known type
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a
predicate or expression where parameter markers have been used as operands of
the same operator for example: ?
|
protected ExpressionOperator |
greaterThanOperator()
DB2 z/OS requires that at least one argument be a known type
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a
predicate or expression where parameter markers have been used as operands of
the same operator for example: ?
|
protected void |
initializePlatformOperators()
INTERNAL:
Initialize any platform-specific operators
|
protected ExpressionOperator |
inOperator()
DB2 z/OS requires that at least one argument be a known type
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a
predicate or expression where parameter markers have been used as operands of
the same operator for example: ?
|
boolean |
isDB2Z() |
protected ExpressionOperator |
isNotNullOperator()
Disable binding support.
|
protected ExpressionOperator |
isNullOperator()
Disable binding support.
|
protected ExpressionOperator |
lessThanEqualOperator()
DB2 z/OS requires that at least one argument be a known type
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a
predicate or expression where parameter markers have been used as operands of
the same operator for example: ?
|
protected ExpressionOperator |
lessThanOperator()
DB2 z/OS requires that at least one argument be a known type
For ALL, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a
predicate or expression where parameter markers have been used as operands of
the same operator for example: ?
|
protected ExpressionOperator |
locate2Operator()
Disable binding support.
|
protected ExpressionOperator |
locateOperator()
Disable binding support.
|
protected ExpressionOperator |
ltrim2Operator()
Disable binding support.
|
protected ExpressionOperator |
ltrimOperator()
Disable binding support.
|
protected ExpressionOperator |
modOperator()
Disable binding support.
|
protected ExpressionOperator |
notBetweenOperator()
DB2 z/OS requires that at least one argument be a known type
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a
predicate or expression where parameter markers have been used as operands of
the same operator for example: ?
|
protected ExpressionOperator |
notEqualOperator()
DB2 z/OS requires that at least one argument be a known type
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a
predicate or expression where parameter markers have been used as operands of
the same operator for example: ?
|
void |
registerOutputParameter(java.sql.CallableStatement statement,
java.lang.String name,
int jdbcType)
This method is used to register output parameter on Callable Statements for Stored Procedures
as each database seems to have a different method.
|
void |
registerOutputParameter(java.sql.CallableStatement statement,
java.lang.String name,
int jdbcType,
java.lang.String typeName)
This method is used to register output parameter on Callable Statements for Stored Procedures
as each database seems to have a different method.
|
protected ExpressionOperator |
rtrim2Operator()
Disable binding support.
|
protected ExpressionOperator |
rtrimOperator()
Disable binding support.
|
protected void |
setNullFromDatabaseField(org.eclipse.persistence.internal.helper.DatabaseField databaseField,
java.sql.CallableStatement statement,
java.lang.String name) |
void |
setParameterValueInDatabaseCall(java.lang.Object parameter,
java.sql.CallableStatement statement,
java.lang.String name,
org.eclipse.persistence.internal.sessions.AbstractSession session) |
protected ExpressionOperator |
sqrtOperator()
Disable binding support.
|
protected ExpressionOperator |
sumOperator()
Disable binding support.
|
protected ExpressionOperator |
trim2()
Disable binding support.
|
protected ExpressionOperator |
trimOperator()
Disable binding support.
|
allowBindingForSelectClause, appendByteArray, appendCalendar, appendDate, appendDB2Calendar, appendDB2Date, appendDB2Timestamp, appendTime, appendTimestamp, ascendingOperator, buildSelectQueryForIdentity, buildSelectQueryForSequenceObject, caseConditionOperator, caseOperator, coalesceOperator, count, descendingOperator, disableAllBindingExpression, disableAtLeast1BindingExpression, distinct, dontBindUpdateAllQueryUsingTempTables, getCreateTempTableSqlBodyForTable, getCreateTempTableSqlPrefix, getCreateTempTableSqlSuffix, getMaxFieldNameSize, getMaxForeignKeyNameSize, getMaxUniqueKeyNameSize, getNativeTableInfo, getNoWaitString, getProcedureAsString, getProcedureBeginString, getProcedureCallHeader, getProcedureEndString, getSelectForUpdateString, getTempTableForTable, getTimestampQuery, initializeConnectionData, isAlterSequenceObjectSupported, isDB2, isDynamicSQLRequiredForFunctions, isNullAllowedInSelectClause, lengthOperator, max, maximumNumericValues, min, minimumNumericValues, nullifOperator, printFieldIdentityClause, printFieldTypeSize, printSQLSelectStatement, shouldBindPartialParameters, shouldIgnoreException, shouldPrintForUpdateClause, shouldPrintOutputTokenAtStart, shouldUseJDBCOuterJoinSyntax, supportsGlobalTempTables, supportsIdentity, supportsLockingQueriesWithMultipleTables, supportsOrderByParameters, supportsSequenceObjects, writeParameterMarker
addBatch, addStructConverter, allowsSizeInProcedureArguments, appendBoolean, appendLiteralToCall, appendLiteralToCallWithBinding, appendNumber, appendParameter, appendParameterInternal, appendString, autoCommit, beginTransaction, buildBatchCriteria, buildBatchCriteriaForComplexId, buildCallWithReturning, buildClassTypes, buildCreateIndex, buildCreateIndex, buildDropIndex, buildDropIndex, buildSequenceObjectAlterIncrementWriter, buildSequenceObjectCreationWriter, buildSequenceObjectDeletionWriter, canBatchWriteWithOptimisticLocking, canBuildCallWithReturning, checkTableExists, commitTransaction, computeMaxRowsForSQL, convertToDatabaseType, copyInto, createArray, createArray, createPlatformDefaultSequence, createStruct, createStruct, createStruct, executeBatch, executeStoredProcedure, freeTemporaryObject, getAssignmentString, getBatchBeginString, getBatchDelimiterString, getBatchEndString, getBatchRowCountAssignString, getBatchRowCountDeclareString, getBatchRowCountReturnString, getBatchWritingMechanism, getCastSizeForVarcharParameter, getClassTypes, getConnection, getConnectionUserName, getConstraintDeletionString, getCreateDatabaseSchemaString, getCreateViewString, getCreationInOutputProcedureToken, getCreationOutputProcedureToken, getCursorCode, getCustomModifyValueForCall, getDefaultSequenceTableName, getDriverSupportsNVarChar, getDropCascadeString, getDropDatabaseSchemaString, getFieldTypeDefinition, getFieldTypes, getFunctionCallHeader, getIdentifierQuoteCharacter, getIndexNamePrefix, getInOutputProcedureToken, getInputProcedureToken, getJDBCOuterJoinString, getJDBCType, getJDBCType, getJDBCTypeForSetNull, getJdbcTypeName, getMaxBatchWritingSize, getMaxIndexNameSize, getObjectFromResultSet, getOutputProcedureToken, getParameterValueFromDatabaseCall, getPartitioningCallback, getPingSQL, getProcedureArgument, getProcedureArgumentString, getProcedureCallTail, getQualifiedName, getQualifiedSequenceTableName, getRefValue, getRefValue, getSelectForUpdateNoWaitString, getSelectForUpdateOfString, getSelectForUpdateWaitString, getSequenceCounterFieldName, getSequenceNameFieldName, getSequencePreallocationSize, getSequenceTableName, getStatementCacheSize, getStoredProcedureParameterPrefix, getStoredProcedureTerminationToken, getStringBindingSize, getStructConverters, getTableExistsQuery, getTransactionIsolation, getTypeConverters, getUniqueConstraintDeletionString, getUseNationalCharacterVaryingTypeForString, getVPDClearIdentifierQuery, getVPDCreationFunctionString, getVPDCreationPolicyString, getVPDDeletionString, getVPDSetIdentifierQuery, hasPartitioningCallback, initialize, isCastRequired, isForUpdateCompatibleWithDistinct, isInformixOuterJoin, isJDBCExecuteCompliant, isLobCompatibleWithDistinct, isLockTimeoutException, isOutputAllowWithResultSet, isRowCountOutputParameterRequired, isXDBDocument, minimumTimeIncrement, prepareBatchStatement, printFieldNotNullClause, printFieldNullClause, printFieldTypeSize, printFieldUnique, printFieldUnique, printStoredFunctionReturnKeyWord, printValuelist, printValuelist, registerOutputParameter, registerOutputParameter, requiresNamedPrimaryKeyConstraints, requiresProcedureBrackets, requiresProcedureCallBrackets, requiresProcedureCallOuputToken, requiresTableInIndexDropDDL, requiresTypeNameToRegisterOutputParameter, requiresUniqueConstraintCreationOnTableCreate, retrieveFirstPrimaryKeyOrOne, rollbackTransaction, setBatchWritingMechanism, setCastSizeForVarcharParameter, setClassTypes, setCursorCode, setDriverName, setDriverSupportsNVarChar, setFieldTypes, setIsCastRequired, setMaxBatchWritingSize, setNullFromDatabaseField, setParameterValueInDatabaseCall, setPartitioningCallback, setPingSQL, setPrintInnerJoinInWhereClause, setPrintOuterJoinInWhereClause, setSequenceCounterFieldName, setSequenceNameFieldName, setSequenceTableName, setShouldBindAllParameters, setShouldBindLiterals, setShouldBindPartialParameters, setShouldCacheAllStatements, setShouldCreateIndicesOnForeignKeys, setShouldForceBindAllParameters, setShouldForceFieldNamesToUpperCase, setShouldIgnoreCaseOnFieldComparisons, setShouldOptimizeDataConversion, setShouldTrimStrings, setShouldUseRownumFiltering, setStatementCacheSize, setStoredProcedureTerminationToken, setStringBindingSize, setSupportsAutoCommit, setTableCreationSuffix, setTransactionIsolation, setUseJDBCStoredProcedureSyntax, setUseNationalCharacterVaryingTypeForString, setUsesBatchWriting, setUsesByteArrayBinding, setUsesJDBCBatchWriting, setUsesNativeBatchWriting, setUsesNativeSQL, setUsesStreamsForBinding, setUsesStringBinding, shouldAlwaysUseTempStorageForModifyAll, shouldBindAllParameters, shouldBindLiterals, shouldCacheAllStatements, shouldCreateIndicesForPrimaryKeys, shouldCreateIndicesOnForeignKeys, shouldCreateIndicesOnUniqueKeys, shouldForceBindAllParameters, shouldForceFieldNamesToUpperCase, shouldIgnoreCaseOnFieldComparisons, shouldOptimizeDataConversion, shouldPrintAliasForUpdate, shouldPrintConstraintNameAfter, shouldPrintFieldIdentityClause, shouldPrintInnerJoinInWhereClause, shouldPrintInOutputTokenBeforeType, shouldPrintInputTokenAtStart, shouldPrintLockingClauseAfterWhereClause, shouldPrintOuterJoinInWhereClause, shouldPrintOutputTokenBeforeType, shouldPrintStoredProcedureArgumentNameInCall, shouldPrintStoredProcedureVariablesAfterBeginString, shouldTempTableSpecifyPrimaryKeys, shouldTrimStrings, shouldUseCustomModifyForCall, shouldUseGetSetNString, shouldUseRownumFiltering, supportsANSIInnerJoinSyntax, supportsAutoCommit, supportsAutoConversionToNumericForArithmeticOperations, supportsConnectionUserName, supportsCountDistinctWithMultipleFields, supportsDeleteOnCascade, supportsForeignKeyConstraints, supportsIndexes, supportsIndividualTableLocking, supportsLocalTempTables, supportsNestingOuterJoins, supportsOuterJoinsWithBrackets, supportsPrimaryKeyConstraint, supportsStoredFunctions, supportsTempTables, supportsUniqueColumns, supportsUniqueKeyConstraints, supportsVPD, supportsWaitForUpdate, usesBatchWriting, usesByteArrayBinding, usesJDBCBatchWriting, usesNativeBatchWriting, usesNativeSQL, usesSequenceTable, usesStreamsForBinding, usesStringBinding, wasFailureCommunicationBased, writeAddColumnClause, writeAutoAssignmentSetClause, writeAutoJoinWhereClause, writeCleanUpTempTableSql, writeCreateTempTableSql, writeDeleteFromTargetTableUsingTempTableSql, writeFields, writeFieldsAutoClause, writeFieldsList, writeInsertIntoTableSql, writeJoinWhereClause, writeLOB, writeTableCreationSuffix, writeUpdateOriginalFromTempTableSql
addOperator, addSequence, addSequence, buildNativeCall, buildSelectQueryForIdentity, buildSelectQueryForSequenceObject, clone, convertObject, createConnectionCustomizer, createExpressionFor, getConversionManager, getDataTypesConvertedFrom, getDataTypesConvertedTo, getDefaultNativeSequenceToTable, getDefaultSeqenceAtNextValue, getDefaultSequence, getDefaultSequenceToWrite, getEndDelimiter, getINClauseLimit, getOperator, getPlatformOperators, getSelectSequenceQuery, getSequence, getSequences, getSequencesToWrite, getStartDelimiter, getTableQualifier, getTimestampFromServer, getUpdateSequenceQuery, hasDefaultSequence, initializeDefaultQueries, isAccess, isAttunity, isCloudscape, isDBase, isDerby, isFirebird, isH2, isHANA, isHSQL, isInformix, isMaxDB, isMySQL, isODBC, isOracle, isOracle9, isPervasive, isPointBase, isPostgreSQL, isSQLAnywhere, isSQLServer, isSybase, isSymfoware, isTimesTen, isTimesTen7, removeAllSequences, removeSequence, sequencesAfterCloneCleanup, setConversionManager, setDefaultNativeSequenceToTable, setDefaultSeqenceAtNextValue, setDefaultSequence, setEndDelimiter, setSelectSequenceNumberQuery, setSequencePreallocationSize, setSequences, setStartDelimiter, setSupportsReturnGeneratedKeys, setTableQualifier, setTimestampQuery, setUpdateSequenceQuery, shouldNativeSequenceUseTransaction, shouldPrepare, shouldSelectDistinctIncludeOrderBy, shouldSelectIncludeOrderBy, supportsNativeSequenceNumbers, supportsReturnGeneratedKeys, toString, usesPlatformDefaultSequence
protected java.util.Hashtable buildFieldTypes()
buildFieldTypes
in class DB2Platform
public java.lang.String getTableCreationSuffix()
getTableCreationSuffix
in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
public java.lang.String getProcedureArgument(java.lang.String name, java.lang.Object parameter, org.eclipse.persistence.internal.databaseaccess.DatasourceCall.ParameterType parameterType, StoredProcedureCall call, org.eclipse.persistence.internal.sessions.AbstractSession session)
DB2Platform
getProcedureArgument
in class DB2Platform
public java.lang.String getProcedureOptionList()
getProcedureOptionList
in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
public boolean isDB2Z()
isDB2Z
in interface org.eclipse.persistence.internal.databaseaccess.Platform
isDB2Z
in class org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform
protected void initializePlatformOperators()
initializePlatformOperators
in class DB2Platform
protected ExpressionOperator avgOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610
protected ExpressionOperator sumOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610
protected ExpressionOperator absOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610
protected ExpressionOperator concatOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610
concatOperator
in class DB2Platform
protected ExpressionOperator equalOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609
protected ExpressionOperator notEqualOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609
protected ExpressionOperator greaterThanOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609
protected ExpressionOperator greaterThanEqualOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609
protected ExpressionOperator lessThanOperator()
For ALL, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609
protected ExpressionOperator lessThanEqualOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609
protected ExpressionOperator isNullOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609
protected ExpressionOperator isNotNullOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609
protected ExpressionOperator betweenOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609
protected ExpressionOperator notBetweenOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609
protected ExpressionOperator locateOperator()
With all binding enabled, DB2 z/OS will throw an error:
The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610
With some binding enabled, DB2 z/OS will throw an error:
The data type, the length, or the value of an argument of a scalar function is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815
protected ExpressionOperator locate2Operator()
With all binding enabled, DB2 z/OS will throw an error:
The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610
With some binding enabled, DB2 z/OS will throw an error:
The data type, the length, or the value of an argument of a scalar function is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815
protected ExpressionOperator modOperator()
With all binding enabled, DB2 z/OS will throw an error:
The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610
With some binding enabled, DB2 z/OS will throw an error:
The data type, the length, or the value of an argument of a scalar function is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815
protected ExpressionOperator sqrtOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610
protected ExpressionOperator trimOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610
protected ExpressionOperator trim2()
With binding enabled, DB2 z/OS will throw an error:
The data type, the length, or the value of an argument of a scalar function is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815
trim2
in class DB2Platform
protected ExpressionOperator ltrimOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610
protected ExpressionOperator ltrim2Operator()
With binding enabled, DB2 z/OS will throw an error:
The data type, the length, or the value of an argument of a scalar function is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815
ltrim2Operator
in class DB2Platform
protected ExpressionOperator rtrimOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement cannot be executed because a parameter marker has been used in an invalid way. DB2 SQL Error: SQLCODE=-418, SQLSTATE=42610
protected ExpressionOperator rtrim2Operator()
With binding enabled, DB2 z/OS will throw an error:
The data type, the length, or the value of an argument of a scalar function is incorrect. DB2 SQL Error: SQLCODE=-171, SQLSTATE=42815
rtrim2Operator
in class DB2Platform
protected ExpressionOperator inOperator()
With binding enabled, DB2 z/OS will throw an error:
The statement string specified as the object of a PREPARE contains a predicate or expression where parameter markers have been used as operands of the same operator for example: ? > ?. DB2 SQL Error: SQLCODE=-417, SQLSTATE=42609
public java.lang.String buildProcedureCallString(StoredProcedureCall call, org.eclipse.persistence.internal.sessions.AbstractSession session, org.eclipse.persistence.internal.sessions.AbstractRecord row)
buildProcedureCallString
in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
public void registerOutputParameter(java.sql.CallableStatement statement, java.lang.String name, int jdbcType) throws java.sql.SQLException
registerOutputParameter
in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
java.sql.SQLException
public void registerOutputParameter(java.sql.CallableStatement statement, java.lang.String name, int jdbcType, java.lang.String typeName) throws java.sql.SQLException
registerOutputParameter
in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
java.sql.SQLException
public void setParameterValueInDatabaseCall(java.lang.Object parameter, java.sql.CallableStatement statement, java.lang.String name, org.eclipse.persistence.internal.sessions.AbstractSession session) throws java.sql.SQLException
setParameterValueInDatabaseCall
in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
java.sql.SQLException
protected void setNullFromDatabaseField(org.eclipse.persistence.internal.helper.DatabaseField databaseField, java.sql.CallableStatement statement, java.lang.String name) throws java.sql.SQLException
setNullFromDatabaseField
in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
java.sql.SQLException
public java.lang.Object getParameterValueFromDatabaseCall(java.sql.CallableStatement statement, java.lang.String name, org.eclipse.persistence.internal.sessions.AbstractSession session) throws java.sql.SQLException
getParameterValueFromDatabaseCall
in class org.eclipse.persistence.internal.databaseaccess.DatabasePlatform
java.sql.SQLException