Yes, I've tried by setting the timeout in the url driver, but without success. Could the problem be related with this line: https://github.com/ apache/calcite/blob/857c06b6744840daac52f7a3ab7f6e 0d32c90e41/core/src/main/java/org/apache/calcite/runtime/ ResultSetEnumerable.java#L139?
I've put a breakpoint in this line and this is called every time i execute a query. By connection is created like this: this https://github.com/ apache/calcite/blob/69839c3798c8221081d80edaaca27a 310ce9005e/core/src/test/java/org/apache/calcite/test/ CalciteAssert.java#L1117. 2016-09-05 18:56 GMT+01:00 Julian Hyde <[email protected]>: > Does the Oracle JDBC driver support timeout as one of the parameters in > the URL? > > Julian > > > On Sep 5, 2016, at 7:54 AM, Miguel Oliveira < > [email protected]> wrote: > > > > Hi, > > > > I'm using the Apache Calcite JDBC adapter to query to Oracle database but > > i'm getting some timeout exceptions when i need to query a table with > many > > data. How can I turn off the calcite JDBC driver timeout (setting the > > timeout to zero, for example)? > > > > Stacktrace: > > Caused by: java.sql.SQLTimeoutException: ORA-01013: user requested cancel > > of current operation > > > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) > > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) > > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) > > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) > > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) > > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) > > at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195) > > at oracle.jdbc.driver.T4CStatement.executeForDescribe( > T4CStatement.java:876) > > at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe( > > OracleStatement.java:1175) > > at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout( > > OracleStatement.java:1288) > > at oracle.jdbc.driver.OracleStatement.executeQuery( > > OracleStatement.java:1498) > > at oracle.jdbc.driver.OracleStatementWrapper.executeQuery( > > OracleStatementWrapper.java:406) > > at org.apache.commons.dbcp.DelegatingStatement.executeQuery( > > DelegatingStatement.java:208) > > > > Best regards. > >
