Better handling of fixed char parameters using JDBC
Details
| Detail name | Value |
|---|---|
| Changelog Number | 6070 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 6.1.0 |
| Resolution Date | 2019-07-02 |
Background
To specify fixed char parameters in JDBC prepared statements, the Exasol JDBC driver offers the method EXAPreparedStatement.setFixedChar(...).
However, the exact data type to be used is not part of this specification.
Improvement
To specify the maximum length of this parameter(s) in a parameter set that is going to be executed, we have added setMaxCharLen() for parameters of type CHAR.
For VARCHAR parameters we already had setMaxVarcharLen().
Changed behavior
Added automatic padding for CHAR parameters in the Exasol server.