作者:Ss_爱咩咩 | 来源:互联网 | 2023-05-17 11:55
sqlselectdistinctTicketStatefromWorkTicketInfowhereTicketStateISNOTNULLjava.sql.SQLEx
sql====select distinct TicketState from WorkTicketInfo where TicketState IS NOT NULL
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset
sql====select distinct StationName from WorkTicketInfo where StationName<>'null'
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by peer: socket write error
select * from WorkTicketInfo order by DateTime_Draft DESC
出现这个错误,页面时好时坏,有时可以显示,有时不行,多点几次又可以了,
请问如何解决啊,我在jbuilderx里调试的,郁闷啊,谢谢,必定给分,谢谢!!!!!
4 个解决方案
释放什么连接?是conn,rs,还有stmt吗?这个好象我都释放了啊?我用的连接池,查出的rs结果集到jsp中使用,在bean里的finally中我都释放了啊?