1. ERROR [http-nio-10.0.1.210-9190-exec-110] controller.AbstractAjaxController.[[]] Dec/06 15:38:45 - Unhandled exception
2. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select aua.*, aual.user_assignment_id language_User_Assignment_Id, aual.item_uuid language_item_uuid, aual.item_version language_item_version, aual.language_locale language_language_locale, aual.is_selected language_is_selected from asa_user_assignments_ev aua join asa_user_assigmt_languages_ev aual ON aual.user_assignment_id = aua.user_assignment_id where aua.is_deleted = 0 and aua.class_uuid = ?]; SQL state [99999]; error code [17011]; Exhausted Resultset; nested exception is java.sql.SQLException: Exhausted Resultset
3.         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84) ~[spring-jdbc-4.1.7.RELEASE.jar:4.1.7.RELEASE]
4.         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-4.1.7.RELEASE.jar:4.1.7.RELEASE]
5.         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-4.1.7.RELEASE.jar:4.1.7.RELEASE]
6.         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:660) ~[spring-jdbc-4.1.7.RELEASE.jar:4.1.7.RELEASE]
7.         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695) ~[spring-jdbc-4.1.7.RELEASE.jar:4.1.7.RELEASE]
8.         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722) ~[spring-jdbc-4.1.7.RELEASE.jar:4.1.7.RELEASE]
9.         at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:154) ~[spring-jdbc-4.1.7.RELEASE.jar:4.1.7.RELEASE]
10.         at com.pearson.ltg.assignments.dataaccess.UserAssignmentDataService.getUserAssignmentToAssignmentCorrelation(UserAssignmentDataService.java:515) ~[UserAssignmentDataService.class:?]
11.         at com.pearson.ltg.assignments.dataaccess.UserAssignmentDataService.getUserAssignmentToAssignmentByClassAndStudentCorrelation(UserAssignmentDataService.java:485) ~[UserAssignmentDataService.class:?]
12.         at com.pearson.ltg.assignments.dataaccess.UserAssignmentDataService$$FastClassBySpringCGLIB$$618b3df9.invoke(<generated>) ~[spring-core-4.1.7.RELEASE.jar:?]
13.         at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[spring-core-4.1.7.RELEASE.jar:4.1.7.RELEASE]
14.         at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717) ~[spring-aop-4.1.7.RELEASE.jar:4.1.7.RELEASE]
15.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.1.7.RELEASE.jar:4.1.7.RELEASE]
16.         at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) ~[spring-tx-4.1.7.RELEASE.jar:4.1.7.RELEASE]
17.         at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) ~[spring-tx-4.1.7.RELEASE.jar:4.1.7.RELEASE]
18.         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) ~[spring-tx-4.1.7.RELEASE.jar:4.1.7.RELEASE]
19.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.1.7.RELEASE.jar:4.1.7.RELEASE]
20.         at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653) ~[spring-aop-4.1.7.RELEASE.jar:4.1.7.RELEASE]
21. Caused by: java.sql.SQLException: Exhausted Resultset
22.         at oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetImpl.java:1436) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0]
23.         at oracle.jdbc.driver.OracleResultSet.getTimestamp(OracleResultSet.java:518) ~[ojdbc6-11.2.0.3.0.jar:11.2.0.3.0]
24.         at org.apache.tomcat.dbcp.dbcp2.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:702) ~[tomcat-dbcp.jar:8.0.17]
25.         at org.apache.tomcat.dbcp.dbcp2.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:702) ~[tomcat-dbcp.jar:8.0.17]
26.         at com.pearson.ltg.assignments.dataaccess.UserAssignmentDataService.resultToUserAssignment(UserAssignmentDataService.java:298) ~[UserAssignmentDataService.class:?]
27.         at com.pearson.ltg.assignments.dataaccess.UserAssignmentDataService$UserAssignmentsByClassExtractor.extractData(UserAssignmentDataService.java:625) ~[UserAssignmentDataService$UserAssignmentsByClassExtractor.class:?]
28.         at com.pearson.ltg.assignments.dataaccess.UserAssignmentDataService$UserAssignmentsByClassExtractor.extractData(UserAssignmentDataService.java:610) ~[UserAssignmentDataService$UserAssignmentsByClassExtractor.class:?]
29.         at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:708) ~[spring-jdbc-4.1.7.RELEASE.jar:4.1.7.RELEASE]
30.         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:644) ~[spring-jdbc-4.1.7.RELEASE.jar:4.1.7.RELEASE]
31.         ... 94 more
32. ERROR [http-nio-10.0.1.210-9190-exec-86] controller.AbstractAjaxController.[[]] Dec/06 15:39:36 - Unhandled exception
33. org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot get a connection, pool error Timeout waiting for idle object
34.         at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) ~[spring-jdbc-4.1.7.RELEASE.jar:4.1.7.RELEASE]
35.         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:630) ~[spring-jdbc-4.1.7.RELEASE.jar:4.1.7.RELEASE]
36.         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695) ~[spring-jdbc-4.1.7.RELEASE.jar:4.1.7.RELEASE]
37.         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722) ~[spring-jdbc-4.1.7.RELEASE.jar:4.1.7.RELEASE]