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.
