Feature | Supported |
---|
allProceduresAreCallable | true |
allTablesAreSelectable | true |
isReadOnly | false |
nullsAreSortedHigh | false |
nullsAreSortedLow | true |
nullsAreSortedAtStart | false |
nullsAreSortedAtEnd | false |
usesLocalFiles | false |
usesLocalFilePerTable | false |
supportsMixedCaseIdentifiers | false |
storesUpperCaseIdentifiers | false |
storesLowerCaseIdentifiers | false |
storesMixedCaseIdentifiers | true |
supportsMixedCaseQuotedIdentifiers | false |
storesUpperCaseQuotedIdentifiers | false |
storesLowerCaseQuotedIdentifiers | false |
storesMixedCaseQuotedIdentifiers | true |
supportsAlterTableWithAddColumn | false |
supportsAlterTableWithDropColumn | false |
nullPlusNonNullIsNull | false |
supportsConvert | false |
supportsTableCorrelationNames | false |
supportsDifferentTableCorrelationNames | false |
supportsExpressionsInOrderBy | false |
supportsOrderByUnrelated | true |
supportsGroupBy | false |
supportsGroupByUnrelated | false |
supportsGroupByBeyondSelect | false |
supportsLikeEscapeClause | false |
supportsMultipleResultSets | false |
supportsMultipleTransactions | false |
supportsNonNullableColumns | true |
supportsMinimumSQLGrammar | false |
supportsCoreSQLGrammar | false |
supportsExtendedSQLGrammar | false |
supportsANSI92EntryLevelSQL | false |
supportsANSI92IntermediateSQL | false |
supportsANSI92FullSQL | false |
supportsIntegrityEnhancementFacility | false |
supportsOuterJoins | false |
supportsFullOuterJoins | false |
supportsLimitedOuterJoins | false |
isCatalogAtStart | true |
supportsSchemasInDataManipulation | false |
supportsSchemasInProcedureCalls | false |
supportsSchemasInTableDefinitions | false |
supportsSchemasInIndexDefinitions | false |
supportsSchemasInPrivilegeDefinitions | false |
supportsCatalogsInDataManipulation | false |
supportsCatalogsInProcedureCalls | false |
supportsCatalogsInTableDefinitions | false |
supportsCatalogsInIndexDefinitions | false |
supportsCatalogsInPrivilegeDefinitions | false |
supportsPositionedDelete | false |
supportsPositionedUpdate | false |
supportsSelectForUpdate | false |
supportsStoredProcedures | true |
supportsSubqueriesInComparisons | false |
supportsSubqueriesInExists | false |
supportsSubqueriesInIns | false |
supportsSubqueriesInQuantifieds | false |
supportsCorrelatedSubqueries | false |
supportsUnion | false |
supportsUnionAll | false |
supportsOpenCursorsAcrossCommit | false |
supportsOpenCursorsAcrossRollback | false |
supportsOpenStatementsAcrossCommit | true |
supportsOpenStatementsAcrossRollback | false |
doesMaxRowSizeIncludeBlobs | true |
supportsTransactions | false |
supportsTransactionIsolationLevel | false |
supportsDataDefinitionAndDataManipulationTransactions | false |
supportsDataManipulationTransactionsOnly | true |
dataDefinitionCausesTransactionCommit | false |
dataDefinitionIgnoredInTransactions | true |
getMaxBinaryLiteralLength | 0 |
getMaxCharLiteralLength | 64000 |
getMaxColumnNameLength | 60 |
getMaxColumnsInGroupBy | 0 |
getMaxColumnsInIndex | 0 |
getMaxColumnsInOrderBy | 256000000 |
getMaxColumnsInSelect | 256000000 |
getMaxColumnsInTable | 256000000 |
getMaxConnections | 25 |
getMaxCursorNameLength | 0 |
getMaxIndexLength | 0 |
getMaxSchemaNameLength | 0 |
getMaxProcedureNameLength | 250 |
getMaxCatalogNameLength | 1024 |
getMaxRowSize | 2147483647 |
getMaxStatementLength | 2147483647 |
getMaxStatements | 2147483647 |
getMaxTableNameLength | 31 |
getMaxTablesInSelect | 1 |
getMaxUserNameLength | 64000 |
getDefaultTransactionIsolation | 0 |
getDatabaseProductName | FileMaker Pro Web Companion |
getDatabaseProductVersion | 5.5v3 10/10/2001 |
getURL | jdbc:fmpro:http://141.14.237.74:8050 |
getUserName | rogo |
getDriverName | FileMaker Pro Driver |
getIdentifierQuoteString | " |
getDriverVersion | 1.0v3 6/19/2001 |
getDriverMajorVersion | 1 |
getDriverMinorVersion | 0 |
getSQLKeywords | LAYOUT |
getNumericFunctions | |
getStringFunctions | |
getSystemFunctions | |
getTimeDateFunctions | |
getSearchStringEscape | |
getExtraNameCharacters | .!#$';?@[\]`{|}~ |
getSchemaTerm | |
getProcedureTerm | Script |
getCatalogTerm | Domain |
getCatalogSeparator | / |
  |   |
  |   |
  |   |
  |   |