microsoft / microsoft/sql-server-samples
northwind with JDBC
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Description
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?
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the unit test with the Northwind Categories table and the latest mssql JDBC driver. Inspect the byte array written to a file, including the attempted 78-byte OLE header removal and the JBP or BMP output. Done means the image column can be saved as a viewable image file, with the required format or conversion documented.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100