ORA-00604 记录

最新推荐文章于 2025-08-15 21:37:40 发布

原创

最新推荐文章于 2025-08-15 21:37:40 发布 · 2.4k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#Java #Apache #AOP #SQL #Oracle

博客详细记录了遇到ORA-00604错误的过程，该错误是由于递归SQL执行时的问题导致。内容提到了在Spring JDBC操作中触发了这个错误，伴随着'maximum open cursors exceeded'的提示。解决方案包括调整数据库初始化参数文件initSID.ora中的OPEN_CURSORS值，以及设置事件跟踪等。同时，文中还提供了其他可能导致ORA-00604错误的原因及相应的解决策略。

ORA-00600: 内部错误代码，参数: [], [], [], [], [], [], [], []
ORA-00604: 递归 SQL 层出现错误

异常代码：

org.springframework.jdbc.UncategorizedSQLException:

Hibernate operation: could not execute query; uncategorized SQLException for SQL

[select count(*) as col_0_0_ from HC_COMMENT.LEAVEWORD leaveword0_, HC_COMMENT.TOPIC topic1_ where leaveword0_.TOPIC_ID=topic1_.ID and leaveword0_.INFO_ID=108268 and topic1_.AREACODE='001' and leaveword0_.LEAVEWORD_DINGNUM+leaveword0_.LEAVEWORD_BACKNUM>=5]; SQL state [60000]; error code [604]; ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
; nested exception is java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded

        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
        at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
        at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:921)
        at com.hc360.comment.dao.core.HibernateGenericDao.pagedQuery(HibernateGenericDao.java:231)
        at com.hc360.comment.dao.impl.FrontLeavewordDaoImpl.getHotNewLeaveword(FrontLeavewordDaoImpl.java:287)
        at com.hc360.comment.manager.impl.FrontLeavewordManagerImpl.getHotNewLeaveword(FrontLeavewordManagerImpl.java:274)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
        at org.springf