This section describes the general functionality supported by the driver.

  • Unicode support: Multilingual JDBC applications can be developed on any operating system using the driver to access both Unicode and non-Unicode enabled databases. Internally, Java applications use UTF-16 Unicode encoding for string data. When fetching data, the driver automatically performs the conversion from the character encoding used by the database to UTF-16. Similarly, when inserting or updating data in the database, the driver automatically converts UTF-16 encoding to the character encoding used by the database.

    The JDBC API provides mechanisms for retrieving and storing character data encoded as Unicode (UTF-16) or ASCII. Additionally, the Java String object contains methods for converting UTF-16 encoding of string data to or from many popular character encodings.

  • Isolation levels: The driver supports the Read Committed, Read Uncommitted, Repeatable Read, and Serializable isolation levels. The default is Read Committed.
  • Scrollable cursor support: The driver supports scroll-insensitive result sets and updatable result sets.
    Note: When the driver cannot support the requested result set type or concurrency, it automatically downgrades the cursor and generates one or more SQLWarnings with detailed information.
  • Rowset support: The driver supports any JSR 114 implementation of the RowSet interface, including:
    • CachedRowSets
    • FilteredRowSets
    • WebRowSets
    • JoinRowSets
    • JDBCRowSets

    Visit https://www.jcp.org/en/jsr/detail?id=114 for more information about JSR 114.