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. The sendTime & lt;=? Group by s1. ServicerecordId) aa where u.u serinfoid=s.u serinfoid and s.s ervicerecordId (+)=aa. ServicerecordId and u.u serinfoid=? And s.l ocale=? ) s left join member m on m.m emberid=s.m emberid) WHERE 1=1 # # # Cause: Java, SQL, SQLRecoverableException: No more data to read from the socket; [SQL]; No more data to read from the socket. Nested exception is Java. SQL. SQLRecoverableException: No more data to read from the socket at

CodePudding user response:

https://blog.csdn.net/it_man/article/details/42173175
Look at this thread

CodePudding user response:

The select NVL (count (1), 0)