Client drivers
Node.js client driver
The vertica-nodejs client driver is now available.
Centralized OAuth configuration
To simplify OAuth configuration, you can now set OAuth parameters with a single JSON
string with the new oauthjsonconfig (ODBC) and OAuthJsonConfig (JDBC) parameters.
To preserve existing configurations, the old parameters take precedence over the new JSON
parameter, but the new JSON parameter is the recommended configuration method, and the old parameters have been deprecated.
JDBC DataSource user property
You can now get and set the user
property of DataSource with getUser()
and setUser()
, respectively. For details, see
JDBC API.
ODBC client driver enhancements
A number of enhancements have been made to the ODBC client driver to better conform to the ODBC specification. These changes may cause regressions in existing ODBC client programs:
-
If an application calls
SQLSetDescField
to set any field other than the following, the record becomes unbound:-
SET_DESC_COUNT
-
The deferred fields:
-
SQL_DESC_DATA_PTR
-
SQL_DESC_INDICATOR_PTR
-
SQL_DESC_OCTET_LENGTH_PTR
-
-
-
SQLSetDescField
must be called in the sequence order specified in the Microsoft documentation. -
If an application wants to set the precision or scale field for a numeric or date type, it must use
SQLSetDescField
to explicitly set those fields rather than relying onSQLBindParameter
. For details, see the Microsoft documentation. -
If an application calls
SQLGetData
, theStrLen_or_IndPtr
can return the actual length of the data available,SQL_NO_TOTAL
, orSQL_NULL_DATA
. If the data is truncated, Vertica returnsSQL_NO_TOTAL
. When checking the length of the available buffer, you must consider all cases, includingSQL_NO_TOTAL
andSQL_NULL_DATA
. For details, see the Microsoft documentation onSQLGetData
and Getting Long Data. -
If an application calls
SQLExecute
, the response will always attempt to set theSQLSTATE
, including the status and other metadata. -
Many exception messages have been improved with more detailed error information.
JDBC: CallableStatement
The Vertica JDBC client driver now supports stored procedures through CallableStatement. For details, see Executing queries through JDBC.