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.
