We have solved the problem selection from a column with trailing spaces CHAR type in Oracle db with Spring like
jdbcTemplate.query("SELECT * from PAYMENTS where CURRENCY_CODE=?",new SqlParameterValue(OracleTypes.FIXED_CHAR, currencyCode));
We would like to use datasource connection property fixedString=true as a general solution, but given properties has not been applied through configurations, but seen in debugging. Is there anything need to be applied that forgotten or is there any other approach we can try?
Properties, have been tried:
spring.datasource.hikari.additional.fixedString=true
spring.datasource.connectionProperties=fixedString=true
spring.datasource.connection-properties=fixedString=true;