I'm unit testing binary data in a sample database and I want to read the image column from the Categories table from northwind sample db and save it to a file with the latest mssql JDBC driver.
I get the byte array fine but if I write it the image file is invalid. I've read that the format contains an OLE header 78 bytes to remove. I tried that but still the image is not viewable when I save it to a file. I tried saving as JBP and BMP. Neither worked.
Any ideas?
I'm unit testing binary data in a sample database and I want to read the image column from the Categories table from northwind sample db and save it to a file with the latest mssql JDBC driver.
I get the byte array fine but if I write it the image file is invalid. I've read that the format contains an OLE header 78 bytes to remove. I tried that but still the image is not viewable when I save it to a file. I tried saving as JBP and BMP. Neither worked.
Any ideas?