Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

jdbc: metadata: verify DatabaseMetaData.supports* methods #108

Open
Totktonada opened this issue Jan 23, 2019 · 1 comment
Open

jdbc: metadata: verify DatabaseMetaData.supports* methods #108

Totktonada opened this issue Jan 23, 2019 · 1 comment
Labels
backlog jdbc prio1
Milestone
JDBC metadata

Comments

@Totktonada
Copy link
Member

DatabaseMetaData.

Methods:

  • supportsAlterTableWithAddColumn
  • supportsAlterTableWithDropColumn
  • supportsANSI92EntryLevelSQL
  • supportsANSI92FullSQL
  • supportsANSI92IntermediateSQL
  • supportsBatchUpdates
  • supportsCatalogsInDataManipulation
  • supportsCatalogsInIndexDefinitions
  • supportsCatalogsInPrivilegeDefinitions
  • supportsCatalogsInProcedureCalls
  • supportsCatalogsInTableDefinitions
  • supportsColumnAliasing
  • supportsConvert
  • supportsConvert
  • supportsCoreSQLGrammar
  • supportsCorrelatedSubqueries
  • supportsDataDefinitionAndDataManipulationTransactions
  • supportsDataManipulationTransactionsOnly
  • supportsDifferentTableCorrelationNames
  • supportsExpressionsInOrderBy
  • supportsExtendedSQLGrammar
  • supportsFullOuterJoins
  • supportsGetGeneratedKeys
  • supportsGroupBy
  • supportsGroupByBeyondSelect
  • supportsGroupByUnrelated
  • supportsIntegrityEnhancementFacility
  • supportsLikeEscapeClause
  • supportsLimitedOuterJoins
  • supportsMinimumSQLGrammar
  • supportsMixedCaseIdentifiers
  • supportsMixedCaseQuotedIdentifiers
  • supportsMultipleOpenResults
  • supportsMultipleResultSets
  • supportsMultipleTransactions
  • supportsNamedParameters
  • supportsNonNullableColumns
  • supportsOpenCursorsAcrossCommit
  • supportsOpenCursorsAcrossRollback
  • supportsOpenStatementsAcrossCommit
  • supportsOpenStatementsAcrossRollback
  • supportsOrderByUnrelated
  • supportsOuterJoins
  • supportsPositionedDelete
  • supportsPositionedUpdate
  • supportsRefCursors
  • supportsResultSetConcurrency
  • supportsResultSetHoldability
  • supportsResultSetType
  • supportsSavepoints
  • supportsSchemasInDataManipulation
  • supportsSchemasInIndexDefinitions
  • supportsSchemasInPrivilegeDefinitions
  • supportsSchemasInProcedureCalls
  • supportsSchemasInTableDefinitions
  • supportsSelectForUpdate
  • supportsStatementPooling
  • supportsStoredFunctionsUsingCallSyntax
  • supportsStoredProcedures
  • supportsSubqueriesInComparisons
  • supportsSubqueriesInExists
  • supportsSubqueriesInIns
  • supportsSubqueriesInQuantifieds
  • supportsTableCorrelationNames
  • supportsTransactionIsolationLevel
  • supportsTransactions
  • supportsUnion
  • supportsUnionAll

We need also test all these methods.
@Totktonada Totktonada modified the milestones: JDBC MVP, JDBC metadata Jan 23, 2019
nicktorwald added a commit that referenced this issue Apr 5, 2019
@nicktorwald
Add support for JDBC result set type
30427b3 
Provide support for FORWARD_ONLY and INSENSITIVE scroll types. Now
statements as well as theirs resultSets can be built using a forward
only iterator or full implemented insensitive iterator. To achieve this
iteration logic was extracted into two separate classes to support two
scroll types respectively. This is a cross-cutting support through
SQLMetadata, SQLConnection, SQL(Prepared)Statement, SQLResultSet.

Extend SQLStates constants. '24000' state was added in scope of
iterator support.

Add missed implementation of a closing for SQLStatement and
SQLResultSet.

Deprecate JDBCBridge. This redundant class should be removed completely
in scope of another task. Mapping of field labels was moved to
SQLResultSet.

Closes: #85
Affectes: #119, #108
@nicktorwald nicktorwald mentioned this issue Apr 5, 2019
Closed
nicktorwald added a commit that referenced this issue Apr 6, 2019
@nicktorwald
Add support for a result set type and concurrency
bf8eb95 
Provide support for FORWARD_ONLY and INSENSITIVE scroll types. Now
statements as well as theirs resultSets can be built using a forward
only iterator or full implemented insensitive iterator. To achieve this
iteration logic was extracted into two separate classes to support two
scroll types respectively. This is a cross-cutting support through
SQLMetadata, SQLConnection, SQL(Prepared)Statement, SQLResultSet.

Add support for READ_ONLY concurrency level for a result set.

Extend SQLStates constants in scope of cursors and query execution.
0100E and 02000 for query results; 24000 for cursor iteration support.

Add missed implementation of a closing for SQLStatement and
SQLResultSet.

Deprecate JDBCBridge. This redundant class should be removed completely
in scope of another task. Mapping of field labels was moved to
SQLResultSet.

Closes: #85, #86
Affects: #119, #108
nicktorwald added a commit that referenced this issue Apr 7, 2019
@nicktorwald
Add support for a result set type and concurrency
3f3596a 
Provide support for FORWARD_ONLY and INSENSITIVE scroll types. Now
statements as well as theirs resultSets can be built using a forward
only iterator or full implemented insensitive iterator. To achieve this
iteration logic was extracted into two separate classes to support two
scroll types respectively. This is a cross-cutting support through
SQLMetadata, SQLConnection, SQL(Prepared)Statement, SQLResultSet.

Add support for READ_ONLY concurrency level for a result set.

Extend SQLStates constants in scope of cursors and query execution.
0100E and 02000 for query results; 24000 for cursor iteration support.

Add missed implementation of a closing for SQLStatement and
SQLResultSet.

Deprecate JDBCBridge. This redundant class should be removed completely
in scope of another task. Mapping of field labels was moved to
SQLResultSet.

Closes: #85, #86
Affects: #119, #108
nicktorwald added a commit that referenced this issue Apr 16, 2019
@nicktorwald
Add support for a result set type and concurrency
6dd6908 
Provide support for FORWARD_ONLY and INSENSITIVE scroll types. Now
statements as well as theirs resultSets can be built using a forward
only iterator or full implemented insensitive iterator. To achieve this
iteration logic was extracted into two separate classes to support two
scroll types respectively. This is a cross-cutting support through
SQLMetadata, SQLConnection, SQL(Prepared)Statement, SQLResultSet.

Add support for READ_ONLY concurrency level for a result set.

Extend SQLStates constants in scope of cursors and query execution.
0100E and 02000 for query results; 24000 for cursor iteration support.

Add missed implementation of a closing for SQLStatement and
SQLResultSet.

Deprecate JDBCBridge. This redundant class should be removed completely
in scope of another task. Mapping of field labels was moved to
SQLResultSet.

Closes: #85, #86
Affects: #119, #108
nicktorwald added a commit that referenced this issue Apr 16, 2019
@nicktorwald
Add support for a result set type and concurrency
62ee0ee 
Provide support for FORWARD_ONLY and INSENSITIVE scroll types. Now
statements as well as theirs resultSets can be built using a forward
only iterator or full implemented insensitive iterator. To achieve this
iteration logic was extracted into two separate classes to support two
scroll types respectively. This is a cross-cutting support through
SQLMetadata, SQLConnection, SQL(Prepared)Statement, SQLResultSet.

Add support for READ_ONLY concurrency level for a result set.

Extend SQLStates constants in scope of cursors and query execution.
0100E and 02000 for query results; 24000 for cursor iteration support.

Add missed implementation of a closing for SQLStatement and
SQLResultSet.

Deprecate JDBCBridge. This redundant class should be removed completely
in scope of another task. Mapping of field labels was moved to
SQLResultSet.

Closes: #85, #86
Affects: #119, #108
nicktorwald added a commit that referenced this issue Apr 17, 2019
@nicktorwald
Add support for a result set type and concurrency
122be31 
Provide support for FORWARD_ONLY and INSENSITIVE scroll types. Now
statements as well as theirs resultSets can be built using a forward
only iterator or full implemented insensitive iterator. To achieve this
iteration logic was extracted into two separate classes to support two
scroll types respectively. This is a cross-cutting support through
SQLMetadata, SQLConnection, SQL(Prepared)Statement, SQLResultSet.

Add support for READ_ONLY concurrency level for a result set.

Extend SQLStates constants in scope of cursors and query execution.
0100E and 02000 for query results; 24000 for cursor iteration support.

Add missed implementation of a closing for SQLStatement and
SQLResultSet.

Deprecate JDBCBridge. This redundant class should be removed completely
in scope of another task. Mapping of field labels was moved to
SQLResultSet.

Closes: #85, #86
Affects: #119, #108
nicktorwald added a commit that referenced this issue Apr 17, 2019
@nicktorwald
Add support for a result set type and concurrency
acb17e4 
Provide support for FORWARD_ONLY and INSENSITIVE scroll types. Now
statements as well as theirs resultSets can be built using a forward
only iterator or full implemented insensitive iterator. To achieve this
iteration logic was extracted into two separate classes to support two
scroll types respectively. This is a cross-cutting support through
SQLMetadata, SQLConnection, SQL(Prepared)Statement, SQLResultSet.

Add support for READ_ONLY concurrency level for a result set.

Extend SQLStates constants in scope of cursors and query execution.
0100E and 02000 for query results; 24000 for cursor iteration support.

Add missed implementation of a closing for SQLStatement and
SQLResultSet.

Deprecate JDBCBridge. This redundant class should be removed completely
in scope of another task. Mapping of field labels was moved to
SQLResultSet.

Closes: #85, #86
Affects: #119, #108
@Totktonada
Copy link
Member Author

Also need to support getDefaultTransactionIsolation(int).

nicktorwald added a commit that referenced this issue Aug 3, 2019
@nicktorwald
Support JDBC escape syntax
843b7f1 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes: #79, #76, #80, #81, #83, #84
Affects: #108
@nicktorwald nicktorwald mentioned this issue Aug 3, 2019
Closed
nicktorwald added a commit that referenced this issue Aug 3, 2019
@nicktorwald
Support JDBC escape syntax
d29b3d1 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes: #79, #76, #80, #81, #83, #84
Affects: #108
nicktorwald added a commit that referenced this issue Dec 4, 2019
@nicktorwald
jdbc: support for sub-set of JDBC escape syntax
2a1b6c1 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes #79
Closes #76
Closes #81
Closes #83
Closes #84
Affects: #108
nicktorwald added a commit that referenced this issue Dec 4, 2019
@nicktorwald
jdbc: support for sub-set of JDBC escape syntax
a77d8e4 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes #79
Closes #76
Closes #81
Closes #83
Closes #84
Affects: #108
nicktorwald added a commit that referenced this issue Dec 5, 2019
@nicktorwald
jdbc: support for sub-set of JDBC escape syntax
dd73edd 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes #79
Closes #76
Closes #81
Closes #83
Closes #84
Affects: #108
nicktorwald added a commit that referenced this issue Dec 17, 2019
@nicktorwald
jdbc: support for sub-set of JDBC escape syntax
204508f 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes #79
Closes #76
Closes #81
Closes #83
Closes #84
Affects: #108
nicktorwald added a commit that referenced this issue Dec 17, 2019
@nicktorwald
jdbc: support for sub-set of JDBC escape syntax
d1f72f2 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes #79
Closes #76
Closes #81
Closes #83
Closes #84
Affects: #108
nicktorwald added a commit that referenced this issue Jan 15, 2020
@nicktorwald
jdbc: support for sub-set of JDBC escape syntax
d36814b 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes #79
Closes #76
Closes #81
Closes #83
Closes #84
Affects: #108
nicktorwald added a commit that referenced this issue Jan 15, 2020
@nicktorwald
jdbc: support for sub-set of JDBC escape syntax
939a617 
Add a driver SQL pre-processing before sending it to the server. The
driver supports sub-set of scalar functions defined by the spec
(appendix C), outer joins, escape clause for SQL LIKE operator, and
limit/offset clause. The processed result can be received using
Connection.nativeSQL() method.

Closes #79
Closes #76
Closes #81
Closes #83
Closes #84
Affects: #108
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
backlog jdbc prio1
Projects
None yet
Milestone
JDBC metadata
Development

No branches or pull requests
2 participants
@Totktonada @TarantoolBot