问题描述:执行了一条count(*)的sql后报了如下ORA-01013错误。
uncategorized SQLException for SQL []; SQL state [72000]; error code [1013];
--- The error occurred in com/taobao/lottery/biz/dao/report/dataobject/balance_data_sqlmap_mapping.xml.
--- The error occurred while applying a parameter map.
--- Check the IbatisBalanceDataDAO.querySaleBalanceDataCount-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-01013: user requested cancel of current operation
; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/taobao/lottery/biz/dao/report/dataobject/balance_data_sqlmap_mapping.xml.
--- The error occurred while applying a parameter map.
--- Check the IbatisBalanceDataDAO.querySaleBalanceDataCount-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-01013: user requested cancel of current operation查询的量是20万左右,耗的时间是15秒左右,按理说不应该会出现等待时间超时,用户请求退出的情况。
出现这种情况除了这个原因之外还有别的什么原因吗?请大侠们指点,很紧急的问题啊~~
uncategorized SQLException for SQL []; SQL state [72000]; error code [1013];
--- The error occurred in com/taobao/lottery/biz/dao/report/dataobject/balance_data_sqlmap_mapping.xml.
--- The error occurred while applying a parameter map.
--- Check the IbatisBalanceDataDAO.querySaleBalanceDataCount-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-01013: user requested cancel of current operation
; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/taobao/lottery/biz/dao/report/dataobject/balance_data_sqlmap_mapping.xml.
--- The error occurred while applying a parameter map.
--- Check the IbatisBalanceDataDAO.querySaleBalanceDataCount-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-01013: user requested cancel of current operation查询的量是20万左右,耗的时间是15秒左右,按理说不应该会出现等待时间超时,用户请求退出的情况。
出现这种情况除了这个原因之外还有别的什么原因吗?请大侠们指点,很紧急的问题啊~~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货