Hi, I have blob field in SQLServer and i would like to write that blob to a file. Any help or suggestions will be greatly appreciated. Thanks
Greg T Robertson
posted 12 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).