How to get svg in database injava

Question

I am having 1 problem. I save SVG images in the database as binary. Now, I want to download it without converting to base64, is there any way. Thank you.

Answer 1

Basically, that would mean getting the BLOB object from the database. I would follow this approach to show it in directly in the browser:

@RestController
public class ImageController {

    @GetMapping(value = "/img-test", produces = "image/svg+xml")
    public byte[] getImg() throws IOException
    {
        // retrieve your image from the DB
        File imgFile = new File("C:\\Users\\USR\\Desktop\\img.svg");

        InputStream inp = new DataInputStream(new FileInputStream(imgFile));

        return inp.readAllBytes(); // This is a Java 9 specific convertion
    }
}

With this approach, you do not change anything on the BLOB image. You take it and return it as is, an array with bytes. And you can directly show it in a browser or embed it somewhere in your HTML file.

The main thing here is the MIME type : image/svg+xml

If you are using an older version of Java, then check this question for the conversion of the InputStream object to a byte array.

And with this approach you can download the file:

@GetMapping("download-img")
    public ResponseEntity downloadImg() throws IOException
    {
        // Get the file from the DB...
        File imgFile = new File("C:\\Users\\USR\\Desktop\\img.svg");

        InputStream inp = new DataInputStream(new FileInputStream(imgFile));
        //Dynamically change the File Name here
        return ResponseEntity.ok()
                .header(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=\"img.svg\"")
                .body(inp.readAllBytes());
    }