• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

error reading from an iamge type field [ms sql 2000]

 
Jay Richards
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
im trying to retrieve an image from a ms sql database for display using servlet:
...
data = rs.getBinaryStream(imagenum);
....
but i get this error:
java.io.IOException: [Microsoft][SQLServer 2000 Driver for JDBC]Object
has been closed.
at com.microsoft.jdbc.base.BaseInputStreamWrapper.validateClosedState(Unknown Source)
at com.microsoft.jdbc.base.BaseInputStreamWrapper.read(Unknown Source)
at ShowImage.doGet(ShowImage.java:46)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:126)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96)
at com.caucho.server.http.Invocation.service(Invocation.java:312)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:244)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at java.lang.Thread.run(Thread.java:534)
what seem's to be the error... but when i tried porting it to mysql database. it works. (just changed the driver and the connect url)
it seems like a microsoft driver error?
help pls?
thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic