WARN [http-8888-Processor21] JDBCExceptionReporter.logExceptions(77) | SQL Error: 1000, SQLState: 72000
ERROR [http-8888-Processor21] JDBCExceptionReporter.logExceptions(78) | ORA-01000: maximum open cursors exceededorg.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select personalla0_.PERSONAL_LABOR_ID as PERSONAL1_16_, personalla0_.AMONG_GRANT_MONEY as AMONG2_16_, personalla0_.AMONG_PERSONAL_MONEY as AMONG3_16_, personalla0_.AREA_UNION_SUGGESTION as AREA4_16_, personalla0_.BACKNUM_EIGHT as BACKNUM5_16_, personalla0_.BACKNUM_FIVE as BACKNUM6_16_, personalla0_.BACKNUM_FOUR as BACKNUM7_16_, personalla0_.BACKNUM_NINE as BACKNUM8_16_, personalla0_.BACKNUM_ONE as BACKNUM9_16_, personalla0_.BACKNUM_SEVEN as BACKNUM10_16_, personalla0_.BACKNUM_SIX as BACKNUM11_16_, personalla0_.BACKNUM_TEN as BACKNUM12_16_, personalla0_.BACKNUM_THREE as BACKNUM13_16_, personalla0_.BACKNUM_TWO as BACKNUM14_16_, personalla0_.BASE_SOCIETY_PENSION as BASE15_16_, personalla0_.BELONG_UNION as BELONG16_16_, personalla0_.BIRTH_PLACE as BIRTH17_16_, personalla0_.BIRTHDAY as
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
ERROR [http-8888-Processor21] JDBCExceptionReporter.logExceptions(78) | ORA-01000: maximum open cursors exceededorg.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select personalla0_.PERSONAL_LABOR_ID as PERSONAL1_16_, personalla0_.AMONG_GRANT_MONEY as AMONG2_16_, personalla0_.AMONG_PERSONAL_MONEY as AMONG3_16_, personalla0_.AREA_UNION_SUGGESTION as AREA4_16_, personalla0_.BACKNUM_EIGHT as BACKNUM5_16_, personalla0_.BACKNUM_FIVE as BACKNUM6_16_, personalla0_.BACKNUM_FOUR as BACKNUM7_16_, personalla0_.BACKNUM_NINE as BACKNUM8_16_, personalla0_.BACKNUM_ONE as BACKNUM9_16_, personalla0_.BACKNUM_SEVEN as BACKNUM10_16_, personalla0_.BACKNUM_SIX as BACKNUM11_16_, personalla0_.BACKNUM_TEN as BACKNUM12_16_, personalla0_.BACKNUM_THREE as BACKNUM13_16_, personalla0_.BACKNUM_TWO as BACKNUM14_16_, personalla0_.BASE_SOCIETY_PENSION as BASE15_16_, personalla0_.BELONG_UNION as BELONG16_16_, personalla0_.BIRTH_PLACE as BIRTH17_16_, personalla0_.BIRTHDAY as
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
maximum open cursors exceeded 一次查询的数据过多。
可以提升一下数据库的缓存大小