Skip to main content

Usage Limits

Hint

This article is generated by AI translation.

JDBC adapters based on dbvisitor-driver have the following usage limits regarding JDBC interface support:

  • Properties obtained through the DatabaseMetaData interface are unreliable.
  • When using resultSetType, resultSetConcurrency, resultSetHoldability, and fetchDirection parameters, only the following default values are supported:
    • resultSetType = TYPE_FORWARD_ONLY
    • resultSetConcurrency = CONCUR_READ_ONLY
    • resultSetHoldability = HOLD_CURSORS_OVER_COMMIT
    • fetchDirection = FETCH_FORWARD
  • When using ResultSet:
    • The ResultSet.update/insert/deleteXXX series of methods are not supported.
  • When using Statement and PreparedStatement interfaces, overloaded methods with the following parameters are not supported:
    • xxx(String sql, int[] columnIndexes) methods
    • xxx(String sql, String[] columnNames) methods
  • Unsupported JDBC data types:
    • SQLXML, REF_CURSOR, RowId, Ref, Struct, DISTINCT
  • addBatch and clearBatch batch operations are not supported
  • Savepoint operations are not supported
  • Array, Blob, Clob, and NClob type data is pre-read into memory; please be aware of data size