This version of the JDBC driver adds these capabilities to those that were already supported in the legacy JDBC driver:
- Ability to handle larger data sets than the legacy JDBC driver; doesn’t try to load whole result set onto the client in all cases
- Support for multibyte characters in data and user metadata UTF-8 encoding
- Support for Single Sign-On (SSO) authentication
- Support for Secure Socket Layers (SSL) encrypted communications
- Support customized connection parameters
- Support configuring statement FetchSize to limit the data being returned
- Support server side cursors
- Support specifying maximum number of rows
- Support for these commands:
- Copy—Moves data between Aster Database tables and a remote client (from and to a file) via the connection between the client and the server.
- Install File—Installs the data file or SQL-MapReduce function in the specified Aster Database schema.
- Uninstall File—Removes the file or SQL-MapReduce function from Aster Database.
- Download File—Downloads the specified installed file or function.
- Display—Obtains the DDL of a single database object and returns the DDL as a string.
- Generate—Returns the DDL of all objects in a database.