Retrieve an Image stored as BLOB on a MYSQL DB

by

On your ResultSet call: 

Blob imageBlob = resultSet.getBlob(yourBlobColumnIndex);
InputStream binaryStream = imageBlob.getBinaryStream(0, imageBlob.length());

Alternatively, you can call:

byte[] imageBytes = imageBlob.getBytes(1, (int) imageBlob.length());

As BalusC noted in his comment, you’d better use:

InputStream binaryStream = resultSet.getBinaryStream(yourBlobColumnIndex);

And then the code depends on how you are going to read and embed the image.

More Related Contents:

  1. java.sql.SQLException: Before start of result set [duplicate]
  2. Connect Java to a MySQL database
  3. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  4. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  5. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  6. Can we connect remote MySQL database in Android using JDBC? [closed]
  7. java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) [closed]
  8. Cannot issue data manipulation statements with executeQuery()
  9. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  10. JDBC MySql connection pooling practices to avoid exhausted connection pool
  11. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  12. right syntax to use near ‘?’
  13. Running a .sql script using MySQL with JDBC
  14. Java JDBC Access denied for user [closed]
  15. Passing parameters to a JDBC PreparedStatement
  16. JDBC character encoding
  17. Spring, Hibernate, Blob lazy loading
  18. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  19. JDBC returning MySQLSyntaxError Exception with correct statement
  20. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  21. Problems reading/writing UTF-8 data in MySQL from Java using JDBC connector 5.1
  22. MySQL connector error “The server time zone value Central European Time” [duplicate]
  23. com.mysql.jdbc.PacketTooBigException
  24. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server [duplicate]
  25. Should a database connection stay open all the time or only be opened when needed?
  26. Converting mysql table to spark dataset is very slow compared to same from csv file
  27. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  28. A persistent connection with JDBC to MySQL
  29. JDBC MySQL connection using Unix Socket
  30. JDBC connection error : unrecognized timezone [duplicate]

Leave a Comment