aspose file tools
The moose likes JDBC and the fly likes error reading from an iamge type field [ms sql 2000] Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "error reading from an iamge type field [ms sql 2000]" Watch "error reading from an iamge type field [ms sql 2000]" New topic
Author

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

Jay Richards
Ranch Hand

Joined: Jan 16, 2003
Posts: 58
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: error reading from an iamge type field [ms sql 2000]
 
Similar Threads
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing.
Need urgent clariffication
Getting SQL Exception although stored procedure is correct!!!
jsp/sql server connection problem
Strange SQLException