Am getting below error for an HQL query. Have set the statement timeout to -1 as well as 0 in weblogic console but still same error. The query printed in logs takes 0.856 seconds to execute on oracle SQL developer and fetches 3986 rows.
Query:
select kpiResultDO
from KPIResult kpiResultDO
where kpiResultDO.processedFl = 'NO'
and kpiResultDO.typeCd in ('ABC','XYZ', 'PQR')
order by kpiResultDO.seq
Error:
Caused by: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)