org.springframework.dao.RecoverableDataAccessException: ### Error querying database. Cause: java.sql.SQLRecoverableException: No more data to read from socket ### The error may exist in file [/data/apache-tomcat-8.5.24-2/webapps/ROOT/WEB-INF/classes/mapper/ServiceDetailExtendMapper.xml] ### The error may involve com.bmw.serve.dao.ServiceDetailMapper.getCount-Inline ### The error occurred while setting parameters ### SQL: select COUNT(1) FROM ( select s.servicerecordId, s.username, m.lastname||m.firstname as membername, m.phone, s.talktime,cont,s.createtime from ( select s.memberid,s.servicerecordId, u.username, talktime,cont,s.createtime from userinfo u, servicerecord s, (select s1.servicerecordId, count(s1.servicerecordId) as cont , to_char(min(s1.sendtime),'yyyy-MM-dd HH24:mi:ss') ||' ~ '||to_char(max(s1.sendtime),'yyyy-MM-dd HH24:mi:ss') as talktime from servicedetail s1 where 1=1 and s1.sendTime >= ? and s1.sendTime <= ? group by s1.servicerecordId ) aa where u.userinfoid = s.userinfoid and s.servicerecordId (+) = aa.servicerecordId and u.userinfoid = ? and s.locale = ? ) s left join member m on m.memberid = s.memberid ) WHERE 1=1 ### Cause: java.sql.SQLRecoverableException: No more data to read from socket ; SQL []; No more data to read from socket; nested exception is java.sql.SQLRecoverableException: No more data to read from socket at
看下这个帖子