首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > JAVA > Java Exception >

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JD-tomcat

2014-01-26 
At org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Threaool.java:530)at java.lang.Thre

At org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Threaool.java:530)
  at java.lang.Thread.run(Thread.java:536)
  lclException_6=java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JD
  ]Object has been closed.lclException_5=java.sql.SQLException: [Microsoft][SQLSver 2000 Driver for JDBC]Object has been closed.select a.AlbumInfo_ID,a.Albumrt_ID,a.Album_ID,a.User_ID,a.AlbumInfo_Title,a.AlbumInfo_Content,a.AlbumInfo
 

------解决方法--------------------------------------------------------
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JD
  ]Object has been closed
 
  你应该是配置了一个mssql连接池,tomcat启动的时候会去连接该数据库.不过,我的进一步判断是你有启动时就运行的servlet,他去连接数据库,但是在取值之前就把连接关闭了,比如:
 
  ResultSet rs = stmt.executeQuery(sql);
 
  conn.close(); // rs还没使用就关闭连接
 
  if ( rs.next() )
  {
  // do something
  }

        

热点排行