You’re right. I suppose removing line 139 would solve your problem. We should probably add a parameter to the JDBC adapter called jdbcStatementTimeout, default “10s”, where a negative value means "don’t set a timeout” (i.e. use the driver’s default timeout) and 0 means no timeout.
Julian > On Sep 5, 2016, at 3:19 PM, Miguel Oliveira <[email protected]> > wrote: > > 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/857c06b6744840daac52f7a3ab7f6e0d32c90e41/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/69839c3798c8221081d80edaaca27a310ce9005e/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. >> >>
