org.apache.openjpa.jdbc.sql: public class: FirebirdDictionary

org.apache.openjpa.jdbc.sql
public class: FirebirdDictionary [javadoc | source]

java.lang.Object
   org.apache.openjpa.jdbc.sql.DBDictionary
      org.apache.openjpa.jdbc.sql.InterbaseDictionary
         org.apache.openjpa.jdbc.sql.FirebirdDictionary

All Implemented Interfaces:
ConnectionDecorator, Configurable, SQLWarningHandler, JoinSyntaxes

Dictionary for Firebird.

Fields inherited from org.apache.openjpa.jdbc.sql.DBDictionary:
VENDOR_OTHER, VENDOR_DATADIRECT, SCHEMA_CASE_UPPER, SCHEMA_CASE_LOWER, SCHEMA_CASE_PRESERVE, CONS_NAME_BEFORE, CONS_NAME_MID, CONS_NAME_AFTER, blobBufferSize, clobBufferSize, RANGE_POST_SELECT, RANGE_PRE_DISTINCT, RANGE_POST_DISTINCT, RANGE_POST_LOCK, NANO, MICRO, MILLI, CENTI, DECI, SEC, NAME_ANY, NAME_TABLE, NAME_SEQUENCE, UNLIMITED, NO_BATCH, EMPTY_STRING_LIST, SQL_STATE_CODES, platform, driverVendor, catalogSeparator, createPrimaryKeys, constraintNameMode, maxTableNameLength, maxColumnNameLength, maxConstraintNameLength, maxIndexNameLength, maxIndexesPerTable, supportsForeignKeys, supportsTimestampNanos, supportsUniqueConstraints, supportsDeferredConstraints, supportsRestrictDeleteAction, supportsCascadeDeleteAction, supportsNullDeleteAction, supportsDefaultDeleteAction, supportsRestrictUpdateAction, supportsCascadeUpdateAction, supportsNullUpdateAction, supportsDefaultUpdateAction, supportsAlterTableWithAddColumn, supportsAlterTableWithDropColumn, supportsComments, reservedWords, systemSchemas, systemTables, selectWords, fixedSizeTypeNames, schemaCase, validationSQL, closePoolSQL, initializationSQL, joinSyntax, outerJoinClause, innerJoinClause, crossJoinClause, requiresConditionForCrossJoin, forUpdateClause, tableForUpdateClause, distinctCountColumnSeparator, supportsSelectForUpdate, supportsLockingWithDistinctClause, supportsLockingWithMultipleTables, supportsLockingWithOrderClause, supportsLockingWithOuterJoin, supportsLockingWithInnerJoin, supportsLockingWithSelectRange, supportsQueryTimeout, simulateLocking, supportsSubselect, supportsCorrelatedSubselect, supportsHaving, supportsSelectStartIndex, supportsSelectEndIndex, rangePosition, requiresAliasForSubselect, requiresTargetForDelete, allowsAliasInBulkClause, supportsMultipleNontransactionalResultSets, searchStringEscape, requiresCastForMathFunctions, requiresCastForComparisons, supportsModOperator, supportsXMLColumn, castFunction, toLowerCaseFunction, toUpperCaseFunction, stringLengthFunction, bitLengthFunction, trimLeadingFunction, trimTrailingFunction, trimBothFunction, concatenateFunction, concatenateDelimiter, substringFunctionName, currentDateFunction, currentTimeFunction, currentTimestampFunction, dropTableSQL, storageLimitationsFatal, storeLargeNumbersAsStrings, storeCharsAsNumbers, useGetBytesForBlobs, useSetBytesForBlobs, useGetObjectForBlobs, useGetStringForClobs, useSetStringForClobs, maxEmbeddedBlobSize, maxEmbeddedClobSize, inClauseLimit, datePrecision, characterColumnSize, arrayTypeName, bigintTypeName, binaryTypeName, bitTypeName, blobTypeName, booleanTypeName, charTypeName, clobTypeName, dateTypeName, decimalTypeName, distinctTypeName, doubleTypeName, floatTypeName, integerTypeName, javaObjectTypeName, longVarbinaryTypeName, longVarcharTypeName, nullTypeName, numericTypeName, otherTypeName, realTypeName, refTypeName, smallintTypeName, structTypeName, timeTypeName, timestampTypeName, tinyintTypeName, varbinaryTypeName, varcharTypeName, xmlTypeName, getStringVal, useSchemaName, tableTypes, supportsSchemaForGetTables, supportsSchemaForGetColumns, supportsNullTableForGetColumns, supportsNullTableForGetPrimaryKeys, supportsNullTableForGetIndexInfo, supportsNullTableForGetImportedKeys, useGetBestRowIdentifierForPrimaryKeys, requiresAutoCommitForMetaData, maxAutoAssignNameLength, autoAssignClause, autoAssignTypeName, supportsAutoAssign, lastGeneratedKeyQuery, nextSequenceQuery, sequenceSQL, sequenceSchemaSQL, sequenceNameSQL, conf, log, connected, reservedWordSet, systemSchemaSet, systemTableSet, fixedSizeTypeNameSet, typeModifierSet, selectWordSet, batchLimit

Fields inherited from org.apache.openjpa.jdbc.sql.DBDictionary:

VENDOR_OTHER, VENDOR_DATADIRECT, SCHEMA_CASE_UPPER, SCHEMA_CASE_LOWER, SCHEMA_CASE_PRESERVE, CONS_NAME_BEFORE, CONS_NAME_MID, CONS_NAME_AFTER, blobBufferSize, clobBufferSize, RANGE_POST_SELECT, RANGE_PRE_DISTINCT, RANGE_POST_DISTINCT, RANGE_POST_LOCK, NANO, MICRO, MILLI, CENTI, DECI, SEC, NAME_ANY, NAME_TABLE, NAME_SEQUENCE, UNLIMITED, NO_BATCH, EMPTY_STRING_LIST, SQL_STATE_CODES, platform, driverVendor, catalogSeparator, createPrimaryKeys, constraintNameMode, maxTableNameLength, maxColumnNameLength, maxConstraintNameLength, maxIndexNameLength, maxIndexesPerTable, supportsForeignKeys, supportsTimestampNanos, supportsUniqueConstraints, supportsDeferredConstraints, supportsRestrictDeleteAction, supportsCascadeDeleteAction, supportsNullDeleteAction, supportsDefaultDeleteAction, supportsRestrictUpdateAction, supportsCascadeUpdateAction, supportsNullUpdateAction, supportsDefaultUpdateAction, supportsAlterTableWithAddColumn, supportsAlterTableWithDropColumn, supportsComments, reservedWords, systemSchemas, systemTables, selectWords, fixedSizeTypeNames, schemaCase, validationSQL, closePoolSQL, initializationSQL, joinSyntax, outerJoinClause, innerJoinClause, crossJoinClause, requiresConditionForCrossJoin, forUpdateClause, tableForUpdateClause, distinctCountColumnSeparator, supportsSelectForUpdate, supportsLockingWithDistinctClause, supportsLockingWithMultipleTables, supportsLockingWithOrderClause, supportsLockingWithOuterJoin, supportsLockingWithInnerJoin, supportsLockingWithSelectRange, supportsQueryTimeout, simulateLocking, supportsSubselect, supportsCorrelatedSubselect, supportsHaving, supportsSelectStartIndex, supportsSelectEndIndex, rangePosition, requiresAliasForSubselect, requiresTargetForDelete, allowsAliasInBulkClause, supportsMultipleNontransactionalResultSets, searchStringEscape, requiresCastForMathFunctions, requiresCastForComparisons, supportsModOperator, supportsXMLColumn, castFunction, toLowerCaseFunction, toUpperCaseFunction, stringLengthFunction, bitLengthFunction, trimLeadingFunction, trimTrailingFunction, trimBothFunction, concatenateFunction, concatenateDelimiter, substringFunctionName, currentDateFunction, currentTimeFunction, currentTimestampFunction, dropTableSQL, storageLimitationsFatal, storeLargeNumbersAsStrings, storeCharsAsNumbers, useGetBytesForBlobs, useSetBytesForBlobs, useGetObjectForBlobs, useGetStringForClobs, useSetStringForClobs, maxEmbeddedBlobSize, maxEmbeddedClobSize, inClauseLimit, datePrecision, characterColumnSize, arrayTypeName, bigintTypeName, binaryTypeName, bitTypeName, blobTypeName, booleanTypeName, charTypeName, clobTypeName, dateTypeName, decimalTypeName, distinctTypeName, doubleTypeName, floatTypeName, integerTypeName, javaObjectTypeName, longVarbinaryTypeName, longVarcharTypeName, nullTypeName, numericTypeName, otherTypeName, realTypeName, refTypeName, smallintTypeName, structTypeName, timeTypeName, timestampTypeName, tinyintTypeName, varbinaryTypeName, varcharTypeName, xmlTypeName, getStringVal, useSchemaName, tableTypes, supportsSchemaForGetTables, supportsSchemaForGetColumns, supportsNullTableForGetColumns, supportsNullTableForGetPrimaryKeys, supportsNullTableForGetIndexInfo, supportsNullTableForGetImportedKeys, useGetBestRowIdentifierForPrimaryKeys, requiresAutoCommitForMetaData, maxAutoAssignNameLength, autoAssignClause, autoAssignTypeName, supportsAutoAssign, lastGeneratedKeyQuery, nextSequenceQuery, sequenceSQL, sequenceSchemaSQL, sequenceNameSQL, conf, log, connected, reservedWordSet, systemSchemaSet, systemTableSet, fixedSizeTypeNameSet, typeModifierSet, selectWordSet, batchLimit

Constructor:
public FirebirdDictionary() { platform = "Firebird"; // Firebird 1.5+ locking statement supportsLockingWithMultipleTables = false; forUpdateClause = "FOR UPDATE WITH LOCK"; }

Constructor:

 public FirebirdDictionary() {
        platform = "Firebird";
        // Firebird 1.5+ locking statement
        supportsLockingWithMultipleTables = false;
        forUpdateClause = "FOR UPDATE WITH LOCK";
}

Method from org.apache.openjpa.jdbc.sql.FirebirdDictionary Summary:
getPlaceholderValueString, substring

Methods from org.apache.openjpa.jdbc.sql.InterbaseDictionary:
appendSize, getColumnNameForMetadata, getDropColumnSQL, getTableNameForMetadata, indexOf, substring

Methods from org.apache.openjpa.jdbc.sql.DBDictionary:
addCastAsType, appendCast, appendLength, appendNumericCast, appendSelect, appendSelectRange, appendSize, appendUpdates, appendXmlComparison, assertSupport, calculateValue, canOuterJoin, closeDataSource, comment, comparison, connectedConfiguration, convertSchemaCase, copy, copy, createIndexIfNecessary, decorate, deleteStream, endConfiguration, executeQuery, getAddColumnSQL, getAddForeignKeySQL, getAddPrimaryKeySQL, getArray, getAsciiStream, getBatchLimit, getBigDecimal, getBigInteger, getBinaryStream, getBlob, getBlobObject, getBoolean, getByte, getBytes, getCalendar, getCastFunction, getCatalogNameForMetadata, getChar, getCharacterStream, getClob, getClobString, getColumnNameForMetadata, getColumns, getCreateIndexSQL, getCreateSequenceSQL, getCreateTableSQL, getDate, getDate, getDeclareColumnSQL, getDeleteTableContentsSQL, getDeleteTargets, getDouble, getDropColumnSQL, getDropForeignKeySQL, getDropIndexSQL, getDropPrimaryKeySQL, getDropSequenceSQL, getDropTableSQL, getFloat, getForUpdateClause, getForeignKeyConstraintSQL, getFrom, getFromSelect, getFullName, getFullName, getFullName, getGeneratedKey, getGeneratedKeySequenceName, getImportedKeys, getIndexInfo, getInt, getJDBCType, getKey, getLOBStream, getLocale, getLong, getNumber, getObject, getPlaceholderValueString, getPreferredType, getPrimaryKeyConstraintSQL, getPrimaryKeys, getPrimaryKeysFromBestRowIdentifier, getPrimaryKeysFromGetPrimaryKeys, getRef, getSQLStates, getSchemaCase, getSchemaNameForMetadata, getSelectOperation, getSelects, getSequence, getSequences, getSequencesSQL, getShort, getString, getTableNameForMetadata, getTables, getTime, getTimestamp, getTypeName, getTypeName, getUniqueConstraintSQL, getValidColumnName, getValidColumnName, getValidForeignKeyName, getValidIndexName, getValidPrimaryKeyName, getValidSequenceName, getValidTableName, getValidUniqueName, getVersionColumn, getWhere, handleWarning, indexOf, insertBlobForStreamingLoad, insertClobForStreamingLoad, insertSize, isSelect, isSystemIndex, isSystemSequence, isSystemTable, makeNameValid, makeNameValid, mathFunction, newColumn, newForeignKey, newIndex, newPrimaryKey, newSequence, newStoreException, newTable, prepareStatement, putBytes, putChars, putString, refSchemaComponents, serialize, setArray, setAsciiStream, setBatchLimit, setBigDecimal, setBigInteger, setBinaryStream, setBlob, setBlobObject, setBoolean, setByte, setBytes, setCalendar, setChar, setCharacterStream, setClob, setClobString, setConfiguration, setDate, setDate, setDouble, setFloat, setInt, setJoinSyntax, setLocale, setLong, setNull, setNumber, setObject, setRef, setShort, setString, setTime, setTimestamp, setTyped, setUnknown, shorten, startConfiguration, storageWarning, substring, supportsDeferredForeignKeyConstraints, supportsDeferredUniqueConstraints, supportsDeleteAction, supportsLocking, supportsRandomAccessResultSet, supportsUpdateAction, toBulkOperation, toDelete, toLong, toNativeJoin, toOperation, toOperation, toSQL92Join, toSelect, toSelect, toSelect, toSelect, toSelect, toSelectCount, toTraditionalJoin, toUpdate, updateBlob, updateClob, validateBatchProcess, validateDBSpecificBatchProcess

Methods from org.apache.openjpa.jdbc.sql.DBDictionary:

addCastAsType, appendCast, appendLength, appendNumericCast, appendSelect, appendSelectRange, appendSize, appendUpdates, appendXmlComparison, assertSupport, calculateValue, canOuterJoin, closeDataSource, comment, comparison, connectedConfiguration, convertSchemaCase, copy, copy, createIndexIfNecessary, decorate, deleteStream, endConfiguration, executeQuery, getAddColumnSQL, getAddForeignKeySQL, getAddPrimaryKeySQL, getArray, getAsciiStream, getBatchLimit, getBigDecimal, getBigInteger, getBinaryStream, getBlob, getBlobObject, getBoolean, getByte, getBytes, getCalendar, getCastFunction, getCatalogNameForMetadata, getChar, getCharacterStream, getClob, getClobString, getColumnNameForMetadata, getColumns, getCreateIndexSQL, getCreateSequenceSQL, getCreateTableSQL, getDate, getDate, getDeclareColumnSQL, getDeleteTableContentsSQL, getDeleteTargets, getDouble, getDropColumnSQL, getDropForeignKeySQL, getDropIndexSQL, getDropPrimaryKeySQL, getDropSequenceSQL, getDropTableSQL, getFloat, getForUpdateClause, getForeignKeyConstraintSQL, getFrom, getFromSelect, getFullName, getFullName, getFullName, getGeneratedKey, getGeneratedKeySequenceName, getImportedKeys, getIndexInfo, getInt, getJDBCType, getKey, getLOBStream, getLocale, getLong, getNumber, getObject, getPlaceholderValueString, getPreferredType, getPrimaryKeyConstraintSQL, getPrimaryKeys, getPrimaryKeysFromBestRowIdentifier, getPrimaryKeysFromGetPrimaryKeys, getRef, getSQLStates, getSchemaCase, getSchemaNameForMetadata, getSelectOperation, getSelects, getSequence, getSequences, getSequencesSQL, getShort, getString, getTableNameForMetadata, getTables, getTime, getTimestamp, getTypeName, getTypeName, getUniqueConstraintSQL, getValidColumnName, getValidColumnName, getValidForeignKeyName, getValidIndexName, getValidPrimaryKeyName, getValidSequenceName, getValidTableName, getValidUniqueName, getVersionColumn, getWhere, handleWarning, indexOf, insertBlobForStreamingLoad, insertClobForStreamingLoad, insertSize, isSelect, isSystemIndex, isSystemSequence, isSystemTable, makeNameValid, makeNameValid, mathFunction, newColumn, newForeignKey, newIndex, newPrimaryKey, newSequence, newStoreException, newTable, prepareStatement, putBytes, putChars, putString, refSchemaComponents, serialize, setArray, setAsciiStream, setBatchLimit, setBigDecimal, setBigInteger, setBinaryStream, setBlob, setBlobObject, setBoolean, setByte, setBytes, setCalendar, setChar, setCharacterStream, setClob, setClobString, setConfiguration, setDate, setDate, setDouble, setFloat, setInt, setJoinSyntax, setLocale, setLong, setNull, setNumber, setObject, setRef, setShort, setString, setTime, setTimestamp, setTyped, setUnknown, shorten, startConfiguration, storageWarning, substring, supportsDeferredForeignKeyConstraints, supportsDeferredUniqueConstraints, supportsDeleteAction, supportsLocking, supportsRandomAccessResultSet, supportsUpdateAction, toBulkOperation, toDelete, toLong, toNativeJoin, toOperation, toOperation, toSQL92Join, toSelect, toSelect, toSelect, toSelect, toSelect, toSelectCount, toTraditionalJoin, toUpdate, updateBlob, updateClob, validateBatchProcess, validateDBSpecificBatchProcess

Methods from java.lang.Object:
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method from org.apache.openjpa.jdbc.sql.FirebirdDictionary Detail:
public String getPlaceholderValueString(Column col) { return super.getPlaceholderValueString(col) + " AS " + getTypeName(col); }
public void substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end) { // SUBSTRING in Firebird is of the form: // SELECT SUBSTRING(SOME_COLUMN FROM 1 FOR 5) buf.append("SUBSTRING("); str.appendTo(buf); buf.append(" FROM "); start.appendTo(buf); buf.append(" + 1"); if (end != null) { buf.append(" FOR "); end.appendTo(buf); buf.append(" - ("); start.appendTo(buf); buf.append(")"); } buf.append(")"); }

Method from org.apache.openjpa.jdbc.sql.FirebirdDictionary Detail:

 public String getPlaceholderValueString(Column col) {
        return super.getPlaceholderValueString(col)
            + " AS " + getTypeName(col);
}

 public  void substring(SQLBuffer buf,
    FilterValue str,
    FilterValue start,
    FilterValue end) {
        // SUBSTRING in Firebird is of the form:
        // SELECT SUBSTRING(SOME_COLUMN FROM 1 FOR 5)
        buf.append("SUBSTRING(");
        str.appendTo(buf);
        buf.append(" FROM ");
        start.appendTo(buf);
        buf.append(" + 1");
        if (end != null) {
            buf.append(" FOR ");
            end.appendTo(buf);
            buf.append(" - (");
            start.appendTo(buf);
            buf.append(")");
        }
        buf.append(")");
}