oracle 常见错误

🧙 Questions

☄️ Ideas

Caused by: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) ~[chunjun-connector-oracle.jar:?]
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[chunjun-connector-oracle.jar:?]
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[chunjun-connector-oracle.jar:?]
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[chunjun-connector-oracle.jar:?]
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[chunjun-connector-oracle.jar:?]
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[chunjun-connector-oracle.jar:?]
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) ~[chunjun-connector-oracle.jar:?]
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) ~[chunjun-connector-oracle.jar:?]
	at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:733) ~[chunjun-connector-oracle.jar:?]
	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904) ~[chunjun-connector-oracle.jar:?]
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082) ~[chunjun-connector-oracle.jar:?]
	at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276) ~[chunjun-connector-oracle.jar:?]
	at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366) ~[chunjun-connector-oracle.jar:?]

解决方案

可能是查询超时了，需要设置queryTimeout的参数，设置大一点

🔗 Links

• oracle docs