Help......Writer BLOB from DB to File.....
Greg T Robertson
posted 13 years ago
Basically you can get a Blob (see java.sql.Blob) from the result set. Read the InputStream given by getBinaryStream and write it to an OutputStream in a while loop reading XXXX and then writing XXXX. That's the way I've done in the past on other DBs. This if of course assumes that SQLServer JDBC implementation correctly implements Blob (and I believe it does).