| Location | CA |
HTTP Status 500 - Internal Server Error
HTTP Status 500 - Internal Server Error
Type Exception Report
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
org.springframework.dao.DataAccessResourceFailureException: ### Error querying database. Cause: java.sql.SQLException: I/O Error: DB server closed connection. ### The error may exist in sss/login/db/LoginConfigMapper.xml ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT CASE WHEN count(*) > 0 THEN 1 ELSE 0 END from application_type AT, login_page_config LPC where AT.login_path = ? OR LPC.url = ? ### Cause: java.sql.SQLException: I/O Error: DB server closed connection. ; I/O Error: DB server closed connection.; nested exception is java.sql.SQLException: I/O Error: DB server closed connection. org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88) org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440) com.sun.proxy.$Proxy68.selectOne(Unknown Source) org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159) org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87) org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152) org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85) com.sun.proxy.$Proxy114.isLoginPath(Unknown Source) sss.servlet.UIRedesignActivationFilter.checkForLoginRedirect(UIRedesignActivationFilter.java:121) sss.servlet.UIRedesignActivationFilter.doFilter(UIRedesignActivationFilter.java:208) sss.security.RequestTracingFilter.doFilter(RequestTracingFilter.java:82) sss.servlet.XSSFilter.doFilter(XSSFilter.java:144) sss.SupportedBrowserFilter.doFilter(SupportedBrowserFilter.java:179)
Root Cause
java.sql.SQLException: I/O Error: DB server closed connection. net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1093) net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:563) net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:784) com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:67) org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76) sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) com.sun.proxy.$Proxy68.selectOne(Unknown Source) org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159) org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87) org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152) org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85) com.sun.proxy.$Proxy114.isLoginPath(Unknown Source) sss.servlet.UIRedesignActivationFilter.checkForLoginRedirect(UIRedesignActivationFilter.java:121) sss.servlet.UIRedesignActivationFilter.doFilter(UIRedesignActivationFilter.java:208) sss.security.RequestTracingFilter.doFilter(RequestTracingFilter.java:82) sss.servlet.XSSFilter.doFilter(XSSFilter.java:144) sss.SupportedBrowserFilter.doFilter(SupportedBrowserFilter.java:179)
Root Cause
java.io.IOException: DB server closed connection. net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:852) net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:731) net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:477) net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:114) net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:99) net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:4127) net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1086) net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:563) net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:784) com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:67) org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76) sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:498) org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) com.sun.proxy.$Proxy68.selectOne(Unknown Source) org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159) org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87) org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152) org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85) com.sun.proxy.$Proxy114.isLoginPath(Unknown Source) sss.servlet.UIRedesignActivationFilter.checkForLoginRedirect(UIRedesignActivationFilter.java:121) sss.servlet.UIRedesignActivationFilter.doFilter(UIRedesignActivationFilter.java:208) sss.security.RequestTracingFilter.doFilter(RequestTracingFilter.java:82) sss.servlet.XSSFilter.doFilter(XSSFilter.java:144) sss.SupportedBrowserFilter.doFilter(SupportedBrowserFilter.java:179)
Note The full stack trace of the root cause is available in the server logs.
Apache Tomcat/8.5.39