Class SQLServerDictionary
java.lang.Object
org.apache.openjpa.jdbc.sql.DBDictionary
org.apache.openjpa.jdbc.sql.AbstractSQLServerDictionary
org.apache.openjpa.jdbc.sql.SQLServerDictionary
- All Implemented Interfaces:
JoinSyntaxes, Configurable, IdentifierConfiguration, ConnectionDecorator, LoggingConnectionDecorator.SQLWarningHandler
Dictionary for Microsoft SQL Server.
-
Nested Class Summary
Nested classes/interfaces inherited from class DBDictionary
DBDictionary.DateMillisecondBehaviors, DBDictionary.SerializedData -
Field Summary
FieldsModifier and TypeFieldDescriptionSQLServer doesn't like a java.sql.Time as default.booleanFlag whether to treat UNIQUEIDENTIFIER as VARBINARY or VARCHARstatic final Stringstatic final Stringstatic final StringFields inherited from class DBDictionary
_procs, _proxyManager, allowQueryTimeoutOnFindUpdate, allowsAliasInBulkClause, allowsBulkTargetInSubselect, arrayTypeName, autoAssignClause, autoAssignTypeName, backslashEscapesInStringLiterals, batchLimit, bigintTypeName, binaryTypeName, bitLengthFunction, bitTypeName, blobBufferSize, blobTypeName, booleanRepresentation, booleanTypeName, castFunction, catalogSeparator, ceilingFunction, CENTI, characterColumnSize, charTypeName, clobBufferSize, clobTypeName, closePoolSQL, concatenateDelimiter, concatenateFunction, conf, connected, CONS_NAME_AFTER, CONS_NAME_BEFORE, CONS_NAME_MID, constraintNameMode, createPrimaryKeys, crossJoinClause, currentDateFunction, currentTimeFunction, currentTimestampFunction, databaseProductName, databaseProductVersion, dateFractionDigits, datePrecision, dateTypeName, DECI, decimalTypeName, defaultSchemaName, delimitedCase, disableAlterSeqenceIncrementBy, disableSchemaFactoryColumnTypeErrors, distinctCountColumnSeparator, distinctTypeName, doubleTypeName, driverVendor, dropTableSQL, exceptFunction, extractDateTimeFieldFunction, fixedSizeTypeNames, fixedSizeTypeNameSet, floatTypeName, forUpdateClause, fractionalTypeNameSet, fullResultCollectionInOrderByRelation, getStringVal, inClauseLimit, indexPhysicalForeignKeys, initializationSQL, innerJoinClause, integerCastTypeName, integerTypeName, invalidColumnWordSet, invalidTableWordSet, isJDBC3, isJDBC4, javaObjectTypeName, javaToDbColumnNameProcessing, joinSyntax, lastGeneratedKeyQuery, leadingDelimiter, leftFunctionName, log, longCastTypeName, longVarbinaryTypeName, longVarcharTypeName, maxAutoAssignNameLength, maxColumnNameLength, maxConstraintNameLength, maxEmbeddedBlobSize, maxEmbeddedClobSize, maxIndexesPerTable, maxIndexNameLength, maxTableNameLength, MICRO, MILLI, NAME_ANY, NAME_SEQUENCE, NAME_TABLE, nameConcatenator, NANO, nativeSequenceType, naturalLogarithmFunction, nextSequenceQuery, NO_BATCH, nullTypeName, numericTypeName, otherTypeName, outerJoinClause, platform, RANGE_POST_DISTINCT, RANGE_POST_LOCK, RANGE_POST_SELECT, RANGE_PRE_DISTINCT, rangePosition, realTypeName, refTypeName, replaceFunctionName, reportsSuccessNoInfoOnBatchUpdates, requiresAliasForSubselect, requiresAutoCommitForMetaData, requiresCastForCaseStringResult, requiresCastForComparisons, requiresCastForExtractOperand, requiresCastForMathFunctions, requiresConditionForCrossJoin, requiresSearchStringEscapeForLike, requiresTargetForDelete, reservedWords, reservedWordSet, rightFunctionName, roundTimeToMillisec, SCHEMA_CASE_LOWER, SCHEMA_CASE_PRESERVE, SCHEMA_CASE_UPPER, searchStringEscape, searchStringNoEscape, SEC, selectWords, selectWordSet, sequenceNameSQL, sequenceSchemaSQL, sequenceSQL, setStringRightTruncationOn, simulateLocking, smallintTypeName, sqlStateCodes, storageLimitationsFatal, storeCharsAsNumbers, storeLargeNumbersAsStrings, stringLengthFunction, structTypeName, substringFunctionName, supportsAlterTableWithAddColumn, supportsAlterTableWithDropColumn, supportsAutoAssign, supportsCascadeDeleteAction, supportsCascadeUpdateAction, supportsCaseConversionForLob, supportsComments, supportsCorrelatedSubselect, supportsDefaultDeleteAction, supportsDefaultUpdateAction, supportsDeferredConstraints, supportsDelimitedIdentifiers, supportsForeignKeys, supportsForeignKeysComposite, supportsGeneralCaseExpression, supportsGetGeneratedKeys, supportsHaving, supportsLockingWithDistinctClause, supportsLockingWithInnerJoin, supportsLockingWithMultipleTables, supportsLockingWithOrderClause, supportsLockingWithOuterJoin, supportsLockingWithSelectRange, supportsModOperator, supportsMultipleNontransactionalResultSets, supportsNullDeleteAction, supportsNullTableForGetColumns, supportsNullTableForGetImportedKeys, supportsNullTableForGetIndexInfo, supportsNullTableForGetPrimaryKeys, supportsNullUniqueColumn, supportsNullUpdateAction, supportsParameterInSelect, supportsQueryTimeout, supportsRestrictDeleteAction, supportsRestrictUpdateAction, supportsSchemaForGetColumns, supportsSchemaForGetTables, supportsSelectEndIndex, supportsSelectForUpdate, supportsSelectFromFinalTable, supportsSelectStartIndex, supportsSimpleCaseExpression, supportsSubselect, supportsUniqueConstraints, supportsUnsizedCharOnCast, supportsUuidType, supportsXMLColumn, systemSchemas, systemSchemaSet, systemTables, systemTableSet, tableForUpdateClause, tableLengthIncludesSchema, tableTypes, timestampTypeName, timestampWithZoneTypeName, timeTypeName, timeWithZoneTypeName, tinyintTypeName, toLowerCaseFunction, toUpperCaseFunction, trailingDelimiter, trimBothFunction, trimLeadingFunction, trimSchemaName, trimStringColumns, trimTrailingFunction, typecastToStringTypeName, typeModifierSet, UNLIMITED, useGetBestRowIdentifierForPrimaryKeys, useGetBytesForBlobs, useGetObjectForBlobs, useGetStringForClobs, useJDBC4SetBinaryStream, useNativeSequenceCache, useSchemaName, useSetBytesForBlobs, useSetStringForClobs, useWildCardForCount, uuidTypeName, validationSQL, varbinaryTypeName, varcharTypeName, VENDOR_DATADIRECT, VENDOR_OTHER, xmlTypeEncoding, xmlTypeNameFields inherited from interface JoinSyntaxes
SYNTAX_DATABASE, SYNTAX_SQL92, SYNTAX_TRADITIONAL -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionprotected voidappendLength(SQLBuffer buf, int type) voidappendNullsPrecedence(SQLBuffer ordering, int nullPrecedence) MSSQLServer do not support ANSI SQLNULLS FIRST/NULLS LAST.protected voidappendSelectRange(SQLBuffer buf, long start, long end, boolean subselect) If this dictionary can select ranges, use this method to append the range SQL.voidappendXmlComparison(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs, boolean lhsxml, boolean rhsxml) If this dictionary supports XML type, use this method to append xml predicate.voidThis method is called when the dictionary first sees any connection.getCharacterStream(ResultSet rs, int column) Column[]getColumns(DatabaseMetaData meta, String catalog, String schemaName, String tableName, String columnName, Connection conn) Reflect on the schema to find columns matching the given table and column patterns.Column[]getColumns(DatabaseMetaData meta, DBIdentifier catalog, DBIdentifier schemaName, DBIdentifier tableName, DBIdentifier columnName, Connection conn) Reflect on the schema to find columns matching the given table and column patterns.String[]A SQL Server sequence created withoutSTART WITHstarts at the minimum value of its type, -2^63 for the defaultBIGINT, rather than at 0, so an initial value of 0 is given explicitly.String[]getDropColumnSQL(Column column) SQL Server refuses to drop a column that the primary key, a unique constraint, an index, a default constraint or a foreign key of the table depends on, while most other databases drop these with the column.DATEPART(WEEK) counts the weeks from January 1st; DATEPART(ISO_WEEK) gives the ISO-8601 week that JPA defines.getLOBStream(JDBCStore store, ResultSet rs, int column) getLocalDate(ResultSet rs, int column) Retrieve the specified column of the SQL ResultSet to the properLocalDatejava type.getLocalDateTime(ResultSet rs, int column) Retrieve the specified column of the SQL ResultSet to the properLocalDateTimejava type.getLocalTime(ResultSet rs, int column) Retrieve the specified column of the SQL ResultSet to the properLocalTimejava type.getOffsetDateTime(ResultSet rs, int column) h2 does intentionally not supportgetTimestamp()for 'TIME WITH TIME ZONE' columns.Return DB specific schemaCaseprotected StringgetSequencesSQL(String schemaName, String sequenceName) SQL Server lists sequences insys.sequences.protected StringgetSequencesSQL(DBIdentifier schemaName, DBIdentifier sequenceName) getStoredProcedure(DatabaseMetaData meta, DBIdentifier catalog, DBIdentifier schema, String procedure) SQL Server reports a procedure asname;versionand its parameters with a leading@.getStoredProcedureCallSQL(StoredProcedure procedure) SQL Server does not understand a bareCALLstatement, hence the JDBC escape syntax{call name(?, ...)}is used.intADATETIMEcolumn, reported with three fractional digits, stores multiples of 1/300 of a second, which the driver'sDATETIME2parameter of a millisecond value does not compare equal to: .123 is stored as .1233333.getTypeName(Column col) SQL Server reads an unsizedNUMERICorDECIMALasDECIMAL(18,0), which rounds every value to an integer.voidindexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) Invoke this database's indexOf function.booleanisFatalException(int subtype, SQLException ex) Determine if the given SQL Exception is fatal or recoverable (such as a timeout).voidsetLocalDateTime(PreparedStatement stmnt, int idx, LocalDateTime val, Column col) Set the given LocalTime value as a parameter to the statement.voidsetLocalTime(PreparedStatement stmnt, int idx, LocalTime val, Column col) Set the given LocalTime value as a parameter to the statement.voidsetOffsetDateTime(PreparedStatement stmnt, int idx, OffsetDateTime val, Column col) Set the given LocalTime value as a parameter to the statement.voidsetSupportsXMLColumn(boolean b) voidsetTime(PreparedStatement stmnt, int idx, Time val, Calendar cal, Column col) Set the given value as a parameter to the statement.toJDBCEscapedDateTimeLiteral(String escape, int parseType) Methods inherited from class AbstractSQLServerDictionary
getFullName, setNull, substring, toStringLiteralMethods inherited from class DBDictionary
addCastAsType, addErrorCode, allowsBulkUpdateOfJoinedTables, appendBulkPrimaryKeysIn, appendCast, appendNumericCast, appendSelect, appendSize, appendUpdates, applyRange, assertSupport, calculateValue, canOuterJoin, closeDataSource, combineForeignKey, comment, comparison, configureNamingRules, convertSchemaCase, convertSchemaCase, copy, copy, createIndexIfNecessary, createIndexIfNecessary, decorate, deleteStream, delimitAll, endConfiguration, executeQuery, fromDBName, getAddColumnSQL, getAddForeignKeySQL, getAddPrimaryKeySQL, getAlterSequenceSQL, getArray, getAsciiStream, getBatchFetchSize, getBatchLimit, getBatchUpdateCount, getBigDecimal, getBigInteger, getBinaryStream, getBlob, getBlobObject, getBoolean, getBooleanRepresentation, getByte, getBytes, getCalendar, getCastFunction, getCastFunction, getCatalogNameForMetadata, getCatalogNameForMetadata, getChar, getClob, getClobString, getColumnDBName, getColumnIdentifier, getColumnNameForMetadata, getColumnNameForMetadata, getConversionKey, getCreateIndexSQL, getCreateTableSQL, getCreateTableSQL, getDate, getDate, getDateFractionDigits, getDeclareColumnSQL, getDefaultIdentifierRule, getDefaultSchemaName, getDeleteTableContentsSQL, getDeleteTargets, getDelimitedCase, getDelimitIdentifiers, getDouble, getDropForeignKeySQL, getDropIndexSQL, getDropPrimaryKeySQL, getDropSequenceSQL, getDropTableSQL, getExtractDateTimePartFunction, getExtractField, getExtractOperandCastType, getFloat, getForeignKeyConstraintSQL, getForUpdateClause, getFrom, getFromSelect, getFullIdentifier, getFullName, getFullName, getGeneratedKey, getGeneratedKeySequenceName, getGenKeySeqName, getIdentifierConcatenator, getIdentifierDelimiter, getIdentifierRule, getIdentifierRules, getIdentityColumnName, getImportedKeys, getImportedKeys, getImportedKeys, getImportedKeys, getIndexInfo, getIndexInfo, getInstant, getInt, getIntegerCastTypeName, getInvalidColumnWordSet, getInvalidTableWordSet, getIsNotNullSQL, getIsNullSQL, getJDBCType, getJDBCType, getJDBCType, getKey, getLeadingDelimiter, getLocale, getLog, getLong, getLongCastTypeName, getMajorVersion, getMarkerForInsertUpdate, getMillisecondBehavior, getMinorVersion, getNamingUtil, getNormalizingRule, getNumber, getNumberCastTypeName, getObject, getOffsetTime, getPlaceholderValueString, getPreferredType, getPrimaryKeyConstraintSQL, getPrimaryKeys, getPrimaryKeys, getPrimaryKeysFromBestRowIdentifier, getPrimaryKeysFromBestRowIdentifier, getPrimaryKeysFromGetPrimaryKeys, getPrimaryKeysFromGetPrimaryKeys, getRef, getSchemaNameForMetadata, getSchemaNameForMetadata, getSelectOperation, getSelects, getSelectTableAliases, getSequence, getSequenceIncrement, getSequences, getSequences, getShort, getStoreCharsAsNumbers, getStoredProcedureNameCandidates, getString, getStringCastTypeName, getSupportsDelimitedIdentifiers, getSupportsXMLColumn, getTableNameForMetadata, getTableNameForMetadata, getTables, getTables, getTime, getTimestamp, getTrailingDelimiter, getTrimSchemaName, getTypeName, getUniqueConstraintSQL, getValidColumnName, getValidColumnName, getValidColumnName, getValidColumnName, getValidDefaultSequenceName, getValidDefaultTableName, getValidForeignKeyName, getValidForeignKeyName, getValidIndexName, getValidIndexName, getValidPrimaryKeyName, getValidSequenceName, getValidSequenceName, getValidTableName, getValidTableName, getValidUniqueName, getValidUniqueName, getVersionColumn, getVersionColumn, getWhere, getXMLTypeEncoding, getYear, handleWarning, insertBlobForStreamingLoad, insertClobForStreamingLoad, insertSize, isConnected, isDroppable, isImplicitJoin, isReplicationConnection, isSelect, isStoreCharsAsNumbersExplicit, isSystemIndex, isSystemIndex, isSystemSequence, isSystemSequence, isSystemSequence, isSystemTable, isSystemTable, isUnsizedDecimal, isUsingLimit, isUsingOffset, isUsingOrderBy, isUsingRange, left, makeNameValid, makeNameValid, makeNameValid, makeNameValid, matchErrorState, mathFunction, needsToCreateIndex, needsToCreateIndex, newColumn, newForeignKey, newIndex, newPrimaryKey, newSequence, newStoreException, newTable, normalize, prepareStatement, processDBColumnName, putBytes, putChars, putString, refSchemaComponents, replace, right, serialize, setArray, setAsciiStream, setBatchLimit, setBigDecimal, setBigInteger, setBinaryStream, setBlob, setBlobObject, setBoolean, setBooleanRepresentation, setByte, setBytes, setCalendar, setChar, setCharacterStream, setClob, setClobString, setConfiguration, setDate, setDate, setDateMillisecondBehavior, setDefaultSchemaName, setDelimitedCase, setDelimitIdentifiers, setDouble, setFloat, setInstant, setInt, setJoinSyntax, setLeadingDelimiter, setLocalDate, setLocale, setLong, setMajorVersion, setMinorVersion, setNumber, setObject, setOffsetTime, setQueryTimeout, setRef, setShort, setStatementQueryTimeout, setStoreCharsAsNumbers, setString, setSupportsDelimitedIdentifiers, setTimeouts, setTimeouts, setTimestamp, setTrailingDelimiter, setTrimSchemaName, setTyped, setUnknown, setUnknown, setXMLTypeEncoding, setYear, shorten, startConfiguration, storageWarning, supportsDeferredForeignKeyConstraints, supportsDeferredUniqueConstraints, supportsDeleteAction, supportsIsolationForUpdate, supportsLocking, supportsRandomAccessResultSet, supportsUpdateAction, toBulkOperation, toDBName, toDBName, toDelete, toNativeJoin, toOperation, toOperation, toSelect, toSelect, toSelect, toSelect, toSelect, toSelectCount, toSnakeCase, toSQL92Join, toTableUpdate, toTraditionalJoin, toTypedDateTimeLiteral, toUpdate, updateBlob, updateClob, validateBatchProcess, validateDBSpecificBatchProcess, versionEqualOrEarlierThan, versionEqualOrLaterThan, versionLaterThan
-
Field Details
-
VENDOR_MICROSOFT
- See Also:
-
VENDOR_NETDIRECT
- See Also:
-
VENDOR_JTDS
- See Also:
-
uniqueIdentifierAsVarbinary
public boolean uniqueIdentifierAsVarbinaryFlag whether to treat UNIQUEIDENTIFIER as VARBINARY or VARCHAR -
sendTimeAsString
SQLServer doesn't like a java.sql.Time as default. So either we send it as String or people configure sendTimeAsDatetime=false on the Connection. This is depending how the Database actually is setup. To mitigate misconfiguration we can work around by sending the time as String to the JDBC driver.
-
-
Constructor Details
-
SQLServerDictionary
public SQLServerDictionary()
-
-
Method Details
-
connectedConfiguration
Description copied from class:DBDictionaryThis method is called when the dictionary first sees any connection. It is used to initialize dictionary metadata if needed. If you override this method, be sure to callsuper.connectedConfiguration.- Overrides:
connectedConfigurationin classDBDictionary- Throws:
SQLException
-
getTimestampPrecision
ADATETIMEcolumn, reported with three fractional digits, stores multiples of 1/300 of a second, which the driver'sDATETIME2parameter of a millisecond value does not compare equal to: .123 is stored as .1233333. Multiples of 10 milliseconds are exact in both types. ADATETIME2(3)column keeps whole milliseconds and is left to the default.- Overrides:
getTimestampPrecisionin classDBDictionary- Parameters:
col- the column the value is bound to; may be null- See Also:
-
getCreateSequenceSQL
A SQL Server sequence created withoutSTART WITHstarts at the minimum value of its type, -2^63 for the defaultBIGINT, rather than at 0, so an initial value of 0 is given explicitly.- Overrides:
getCreateSequenceSQLin classDBDictionary
-
getSequencesSQL
SQL Server lists sequences insys.sequences. Without a schema the query is restricted to the default schema of the user, where an unqualified sequence is created;sys.sequencesonly covers the current database.- Overrides:
getSequencesSQLin classDBDictionary
-
getSequencesSQL
- Overrides:
getSequencesSQLin classDBDictionary
-
getExtractDateTimeFieldFunction
DATEPART(WEEK) counts the weeks from January 1st; DATEPART(ISO_WEEK) gives the ISO-8601 week that JPA defines. DATEPART(SECOND) returns the whole seconds only; the fraction of the second that JPA includes is added from DATEPART(NANOSECOND).- Overrides:
getExtractDateTimeFieldFunctionin classDBDictionary
-
getTypeName
SQL Server reads an unsizedNUMERICorDECIMALasDECIMAL(18,0), which rounds every value to an integer. A decimal column of a non integral Java type without a precision is created with the largest precision and the given scale, or a scale of 10 if none is given, so that the fraction of the value is kept. A scale above 38, which SQL Server rejects, is lowered to 38. ANumericTypeNameorDecimalTypeNameset by the user is kept.- Overrides:
getTypeNamein classDBDictionary
-
getColumns
public Column[] getColumns(DatabaseMetaData meta, String catalog, String schemaName, String tableName, String columnName, Connection conn) throws SQLException Description copied from class:DBDictionaryReflect on the schema to find columns matching the given table and column patterns.- Overrides:
getColumnsin classAbstractSQLServerDictionary- Throws:
SQLException
-
getColumns
public Column[] getColumns(DatabaseMetaData meta, DBIdentifier catalog, DBIdentifier schemaName, DBIdentifier tableName, DBIdentifier columnName, Connection conn) throws SQLException Description copied from class:DBDictionaryReflect on the schema to find columns matching the given table and column patterns.- Overrides:
getColumnsin classDBDictionary- Throws:
SQLException
-
getDropColumnSQL
SQL Server refuses to drop a column that the primary key, a unique constraint, an index, a default constraint or a foreign key of the table depends on, while most other databases drop these with the column. The schema tool drops single columns when a table holds columns that are not mapped, for example the columns of a subclass that is not listed. Drop the objects that depend on the column, as found in the catalog views, and then the column, in one transaction, so that nothing is dropped if the column cannot be dropped, for example because a foreign key of another table references the primary key.- Overrides:
getDropColumnSQLin classDBDictionary
-
appendLength
- Overrides:
appendLengthin classDBDictionary
-
appendXmlComparison
public void appendXmlComparison(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs, boolean lhsxml, boolean rhsxml) If this dictionary supports XML type, use this method to append xml predicate.- Overrides:
appendXmlComparisonin classDBDictionary- Parameters:
buf- the SQL buffer to write the comparisonop- the comparison operation to performlhs- the left hand side of the comparisonrhs- the right hand side of the comparisonlhsxml- indicates whether the left operand maps to xmlrhsxml- indicates whether the right operand maps to xml
-
getStoredProcedure
public StoredProcedure getStoredProcedure(DatabaseMetaData meta, DBIdentifier catalog, DBIdentifier schema, String procedure) throws SQLException SQL Server reports a procedure asname;versionand its parameters with a leading@. Both are stripped so that the procedure can be called by its name and its parameters can be referenced by the names they were declared with.- Overrides:
getStoredProcedurein classDBDictionary- Parameters:
meta- the database meta datacatalog- the catalog name or nullschema- the schema name or nullprocedure- the procedure name- Returns:
- metadata about the named procedure or null
- Throws:
SQLException- when metadata query goes wrong
-
getStoredProcedureCallSQL
SQL Server does not understand a bareCALLstatement, hence the JDBC escape syntax{call name(?, ...)}is used.- Overrides:
getStoredProcedureCallSQLin classDBDictionary
-
getSchemaCase
Return DB specific schemaCase- Specified by:
getSchemaCasein interfaceIdentifierConfiguration- Overrides:
getSchemaCasein classDBDictionary- Returns:
- upper, lower, or preserve
-
setSupportsXMLColumn
public void setSupportsXMLColumn(boolean b) - Overrides:
setSupportsXMLColumnin classDBDictionary- Parameters:
b- boolean representing if XML columns are supported
-
isFatalException
Description copied from class:DBDictionaryDetermine if the given SQL Exception is fatal or recoverable (such as a timeout). This implementation always returns true (i.e. all exceptions are fatal). The current dictionary implementation can overwrite this method to mark certain exception conditions as recoverable error.- Overrides:
isFatalExceptionin classDBDictionary- Parameters:
subtype- A constant indicating the category of error as defined inStoreException.ex- original SQL Exception as raised by the database driver.- Returns:
- false if the error is fatal.
-
getLOBStream
Obtain anInputStreamby usingResultSet.getBlob(int)andBlob.getBinaryStream(). Unfortunately this will load entire BLOB into memory. The alternativeResultSet.getBinaryStream(int)provides true streaming but the stream can be consumed only as long asResultSetis open.- Overrides:
getLOBStreamin classDBDictionary- Throws:
SQLException
-
getCharacterStream
Obtain aReaderby usingResultSet.getClob(int)andClob.getCharacterStream(). Unfortunately this will load entire CLOB into memory. The alternativeResultSet.getCharacterStream(int)provides true streaming but the stream can be consumed only as long asResultSetis open.- Overrides:
getCharacterStreamin classDBDictionary- Throws:
SQLException
-
getLocalDate
Description copied from class:DBDictionaryRetrieve the specified column of the SQL ResultSet to the properLocalDatejava type.- Overrides:
getLocalDatein classDBDictionary- Throws:
SQLException
-
setLocalTime
public void setLocalTime(PreparedStatement stmnt, int idx, LocalTime val, Column col) throws SQLException Description copied from class:DBDictionarySet the given LocalTime value as a parameter to the statement.- Overrides:
setLocalTimein classDBDictionary- Throws:
SQLException
-
getLocalTime
Description copied from class:DBDictionaryRetrieve the specified column of the SQL ResultSet to the properLocalTimejava type.- Overrides:
getLocalTimein classDBDictionary- Throws:
SQLException
-
setLocalDateTime
public void setLocalDateTime(PreparedStatement stmnt, int idx, LocalDateTime val, Column col) throws SQLException Description copied from class:DBDictionarySet the given LocalTime value as a parameter to the statement.- Overrides:
setLocalDateTimein classDBDictionary- Throws:
SQLException
-
getLocalDateTime
Description copied from class:DBDictionaryRetrieve the specified column of the SQL ResultSet to the properLocalDateTimejava type.- Overrides:
getLocalDateTimein classDBDictionary- Throws:
SQLException
-
setOffsetDateTime
public void setOffsetDateTime(PreparedStatement stmnt, int idx, OffsetDateTime val, Column col) throws SQLException Description copied from class:DBDictionarySet the given LocalTime value as a parameter to the statement.- Overrides:
setOffsetDateTimein classDBDictionary- Throws:
SQLException
-
getOffsetDateTime
h2 does intentionally not supportgetTimestamp()for 'TIME WITH TIME ZONE' columns. See h2 ticket #413.- Overrides:
getOffsetDateTimein classDBDictionary- Throws:
SQLException
-
setTime
public void setTime(PreparedStatement stmnt, int idx, Time val, Calendar cal, Column col) throws SQLException Description copied from class:DBDictionarySet the given value as a parameter to the statement.- Overrides:
setTimein classDBDictionary- Throws:
SQLException
-
indexOf
Description copied from class:DBDictionaryInvoke this database's indexOf function.- Overrides:
indexOfin classDBDictionary- Parameters:
buf- the SQL buffer to write the indexOf invocation tostr- a query value representing the target stringfind- a query value representing the search stringstart- a query value representing the start index, or null to start at the beginning
-
appendSelectRange
Description copied from class:DBDictionaryIf this dictionary can select ranges, use this method to append the range SQL.- Overrides:
appendSelectRangein classAbstractSQLServerDictionary
-
appendNullsPrecedence
MSSQLServer do not support ANSI SQLNULLS FIRST/NULLS LAST. Emulate via an auxiliaryIIF(<expr> IS NULL, 0, 1)sort key.MSSQLServer's default NULL ordering places NULLs before non-NULLs when sorting ASC and after non-NULLs when sorting DESC. When the requested precedence already matches that default, nothing extra is emitted. Otherwise the last order term
<expr> ASC|DESCis rewritten toIIF(<expr> IS NULL, 0, 1) <sort>, <expr> ASC|DESC.- Overrides:
appendNullsPrecedencein classDBDictionary- Parameters:
ordering- the in-progress ORDER BY buffernullPrecedence-QueryExpressions.NULLS_FIRSTorQueryExpressions.NULLS_LAST
-
toJDBCEscapedDateTimeLiteral
- Overrides:
toJDBCEscapedDateTimeLiteralin classDBDictionary
-