Hi All,
we are trying to use HIkari connection pooling with ignite JdbcThinDriver.
we are facing issue as
Any idea what is the supported connection pooling mechanism work with
IgniteThinDriver
ERROR LOG
==================
WARN com.zaxxer.hikari.pool.ProxyConnection.157 sm-event-consumer prod
sm-event-consumer-v1-55f4db767d-2kskt - HikariPool-1 - Connection
org.apache.ignite.internal.jdbc.thin.JdbcThinConnection@68f0e2a1 marked as
broken because of SQLSTATE(08006), ErrorCode(0)
java.sql.SQLException: Failed to communicate with Ignite cluster.
at
org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:760)
at
org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.executeBatch(JdbcThinStatement.java:651)
at
com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)
at
com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
at
org.springframework.jdbc.core.JdbcTemplate.lambda$batchUpdate$2(JdbcTemplate.java:950)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:647)
at
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:936)
at
org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.batchUpdate(NamedParameterJdbcTemplate.java:366)
at
com.ecoenergy.cortix.sm.event.cache.SMIgniteCacheManager.updateObjectStates(SMIgniteCacheManager.java:118)
at
com.ecoenergy.cortix.sm.event.notifcator.SMIgniteNotificator.notify(SMIgniteNotificator.java:69)
at
com.ecoenergy.cortix.sm.event.eventhandler.ObjectEventHandler.notify(ObjectEventHandler.java:100)
at
com.ecoenergy.cortix.sm.event.eventhandler.ObjectEventHandler.receiveEvents(ObjectEventHandler.java:86)
at
com.ecoenergy.cortix.sm.event.consumer.ObjectEventConsumer.processObjectEvents(ObjectEventConsumer.java:60)
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/