HTTP Status 500 - PreparedStatementCallback; SQL [SELECT count(*) from unid_exclusion WHERE unid = ?]; No more data to read from socket; nested exception is java.sql.SQLRecoverableException: No more data to read from socket


type Exception report

message PreparedStatementCallback; SQL [SELECT count(*) from unid_exclusion WHERE unid = ?]; No more data to read from socket; nested exception is java.sql.SQLRecoverableException: No more data to read from socket

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [SELECT count(*) from unid_exclusion WHERE unid = ?]; No more data to read from socket; nested exception is java.sql.SQLRecoverableException: No more data to read from socket
	org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:97)
	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:721)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:732)
	org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:759)
	edu.utah.oit.business.UnidExclusionManager.isExcludedUnid(UnidExclusionManager.java:39)
	edu.utah.oit.business.PersonManager.profilePerson(PersonManager.java:85)
	edu.utah.uit.web.interceptor.SlashFilter.doFilter(SlashFilter.java:98)
	org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
	org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

root cause

java.sql.SQLRecoverableException: No more data to read from socket
	oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:456)
	oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:397)
	oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
	oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
	oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
	oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
	oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)
	oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
	oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
	oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
	oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
	oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
	org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:721)
	org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:732)
	org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:759)
	edu.utah.oit.business.UnidExclusionManager.isExcludedUnid(UnidExclusionManager.java:39)
	edu.utah.oit.business.PersonManager.profilePerson(PersonManager.java:85)
	edu.utah.uit.web.interceptor.SlashFilter.doFilter(SlashFilter.java:98)
	org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
	org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.57 logs.


Apache Tomcat/7.0.57