这是上一篇文章提供给我的解决方案的后续行动:
同样的错误信息回来了!
2017-09-29 18:50:22.497 ERROR 11099 --- [8080-Acceptor-0] org.apache.tomcat.util.net.NioEndpoint : Socket accept failed
java.io.IOException: Too many open files
at sun.nio.ch.ServerSocketChannelImpl.accept0(Native Method) ~[na:1.8.0_141]
at sun.nio.ch.S
第二列记录tkt_no中的以下sql代码没有中断行,它在两个tkt_nos之间仍然有一个空格,比如AAA111 AAA112,我应该如何在两个tkt_nos之间添加一个中断行?请帮帮我,谢谢。
SELECT min(post_no) +'~'+ max(post_no) as post_no, min(tkt_no) + char(13)+char(10) + max(tkt_no) as tkt_no, plic
FROM TEST
WHERE date = '170711'
GROUP BY plic
ORDER BY post_no
这是上面的sql
当我在NHibernate中查询时,我总是得到一个异常。
这是以下查询:
//Query tblSentEmails to pull out all of the records according to that lngMergeID
strQuery =
"SELECT strEmailAddress, tblSentEmails.strSubject FROM tblSentEmails INNER JOIN tblRecipients ON tblSentEmails.strEmailSendID=tbl