Retrieving BLOB from databse

[jeaton154]

Hello, I am new to this forum and really trying to figure out how to retrieve a jpg from my database to a either an image or label canvas in my project. I read the other forums on this, but they were from 2+ years ago and I couldn’t figure it out with the previous posts on this.

–http://forum.inductiveautomation.com/t/display-blob-image-from-database/14507--

If someone could please let me know I would greatly appreciate it.

[Stevenson.Yuan]

This post might be more relevant:

Load image from DB into Image object

The following code will display a BLOB as the ‘icon’ on a Label component: from javax.swing import ImageIcon from java.io import ByteArrayInputStream from javax.imageio import ImageIO from java.awt import Image from java.net import URL from java.io import File image = # your readfileasbytes output bais = ByteArrayInputStream(image) bImageFromConvert = ImageIO.read(bais) lbl3 = event.source.parent.getComponent('lblImage3') boundWidth = lbl3.width boundHeight = lbl3.height originalWidth = bImage…

You can also load it into image components or the paintable canvas.