[
https://issues.apache.org/jira/browse/IGNITE-4748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15885679#comment-15885679
]
Anil Dasari commented on IGNITE-4748:
-------------------------------------
Hi [~vkulichenko] -
i made some progress on adding query timeout for ignite jdbc driver.
I see CacheException instead of QueryCancelledException in
JdbcStatement#executeQuery(). Is that expected ? if not, i need to spend little
more time on exception navigation.
java.sql.SQLException: javax.cache.CacheException
at
org.apache.ignite.internal.jdbc2.JdbcStatement.executeQuery(JdbcStatement.java:136)
at
org.apache.ignite.internal.jdbc2.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:64)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at
io.vertx.core.impl.ContextImpl.lambda$executeBlocking$1(ContextImpl.java:263)
at
io.vertx.core.impl.OrderedExecutorFactory$OrderedExecutor.lambda$new$0(OrderedExecutorFactory.java:94)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: javax.cache.CacheException: Failed to run reduce query locally.
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:754)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$5.iterator(IgniteH2Indexing.java:1119)
at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:98)
at
org.apache.ignite.internal.jdbc2.JdbcQueryTask.call(JdbcQueryTask.java:199)
at
org.apache.ignite.internal.jdbc2.JdbcStatement.executeQuery(JdbcStatement.java:123)
... 13 more
Caused by: class org.apache.ignite.cache.query.QueryCancelledException: The
query was cancelled while executing.
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:650)
Thanks
> jdbc2.JdbcStatement does not implement setQueryTimeout method
> -------------------------------------------------------------
>
> Key: IGNITE-4748
> URL: https://issues.apache.org/jira/browse/IGNITE-4748
> Project: Ignite
> Issue Type: Bug
> Components: jdbc-driver
> Affects Versions: 1.8
> Reporter: Valentin Kulichenko
> Priority: Critical
> Fix For: 1.9
>
>
> The method was implemented in the older version of JDBC driver, but was
> missed in the newer version (still throws exception).
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
