i am facing problem in storing and retrieve image to and from sql server so if you know the code than please paste it thanx for taking time for reading this question
I do not have code available but I can walk you through to process. To Insert an image into the db, read the file into a byte[]. Create a PreparedStatement with the appropriate SQL. Call the preparedstatement setBinaryStream(int pos, InputStream is, int length) Use the ByteArrayInputStream in place of the InputStream as this will take the byte[] in the constructor. Execute the prepared statement. To read the image back from the db, run an SQL query and obtain a resultset. Call the resultset getBinaryStream(int pos) method to get an InputStream. Use this stream to read the bytes back from the db and re assemble them in an image file. This method expects to read to and from a file. The ByteArrayInputStream is trick to make the db think it came from a file. David Sun Certified Programmer for the Java2 Platform
Post by:autobot
Joel Salatin has signs on his property that say "Trespassers will be Impressed!" Impressive tiny ad:
a bit of art, as a gift, that will fit in a stocking