i see it is because of client timeout. and has been resolved. thanks.
On 6 November 2016 at 00:36, Anil <[email protected]> wrote:
> Hi Manu and All,
>
> Ignite jdbc connection is very slow for very first time even with data
> source.
>
> Consecutive queries are very fast. queries with 1 mins time duration
> becoming slow.
>
> PoolProperties p = new PoolProperties();
> p.setUrl("jdbc:ignite:cfg://cache=TEST_CACHE@file:" +
> System.getProperties().getProperty("ignite.config.file"));
> p.setDriverClassName("org.apache.ignite.IgniteJdbcDriver");
> p.setMaxActive(20);
> p.setInitialSize(5);
> p.setMaxWait(5000);
> p.setMinIdle(5);
> p.setMaxIdle(10);
> p.setTestOnBorrow(true);
> p.setTestWhileIdle(true);
> p.setTestOnReturn(true);
> p.setTimeBetweenEvictionRunsMillis(60000);
> p.setMinEvictableIdleTimeMillis(120000);
> p.setMaxAge(1500000);
> p.setRemoveAbandoned(true);
> p.setRemoveAbandonedTimeout(300);
> p.setLogAbandoned(true);
> p.setFairQueue(true);
> p.setValidationQuery("select count(*) from \"TEST_CACHE\".Person
> limit 1");
> p.setValidationInterval(3000);
> ds = new DataSource();
> ds.setPoolProperties(p);
> anyone facing the similar problem ?
>
> Thanks.
>
