I received an error:
com.zaxxer.hikari.pool.HikariProxyConnection cannot be cast to oracle.jdbc.OracleConnection My code is:
SimpleJdbcCall jdbcCall = new SimpleJdbcCall(jdbcTemplate). withCatalogName(packageName). withProcedureName(procedureName); Map<String, Object> sqlParams = new LinkedHashMap<>(); for(RMSEntityParam entityParam: entity.getParams()) { jdbcCall.addDeclaredParameter(new SqlParameter(entityParam.getName(), OracleTypes.ARRAY, entityParam.getType().name())); sqlParams.put(entityParam.getName(), new SqlArrayValue<>(new Object[]{entityParam.getValue()})); } jdbcCall.execute(sqlParams); I know that you can convert Hikari connections to Oracle, as recommended here: https://stackoverflow.com/questions/40087536/hikaricp-pass-oracle-custom-type
but the SimpleJdbcCall constructor can only accept a JdbcTemplate or DataSource as input.
Hikari Version: 2.8.0 SpringBoot: 2.0.0
How can I solve a problem with hikari?
PS: I do not plan to switch to CallableStatement. The problem arose in the transition from Spring Booth 1.5.9 to version 2.0.0. Previously, everything worked out correctly.
PSS: Most likely, the problem arises because of the transfer of a custom type oraklovogo array. But in the previous version there was no error. I do not plan to roll back.
