Easiest way to convert a Blob into a byte array

by

the mySql blob class has the following function :

blob.getBytes

use it like this:

//(assuming you have a ResultSet named RS)
Blob blob = rs.getBlob("SomeDatabaseField");

int blobLength = (int) blob.length();  
byte[] blobAsBytes = blob.getBytes(1, blobLength);

//release the blob and free up memory. (since JDBC 4.0)
blob.free();

More Related Contents:

  1. Retrieve an Image stored as BLOB on a MYSQL DB
  2. Spring, Hibernate, Blob lazy loading
  3. Difference boolean[] b = {false} vs. boolean b = false? [closed]
  4. How to write an array to allocate space for 5 things [closed]
  5. In java, is there anyway to go from a array of objects that got returned to the number of objects in the array? [closed]
  6. Hours and seconds are lost when storing a date in the database [closed]
  7. How to import the Mysql database using Java
  8. Sorted array in Java: how can I implement? [closed]
  9. Java Array Sort descending?
  10. Check string for palindrome
  11. Connection to Db dies after >4
  12. length and length() in Java
  13. Comparing arrays in JUnit assertions, concise built-in way?
  14. How to connect Android with MySQL using Mysql JDBC driver [duplicate]
  15. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  16. Fastest way to set all values of an array?
  17. Hibernate, Postgres & Array Type
  18. Print out elements from an Array with a Comma between the elements
  19. ArrayList: how does the size increase?
  20. Calculating average of an array list?
  21. Iterate through string array in Java
  22. Java Sorting: sort an array of objects by property, object not allowed to use Comparable
  23. Converting an ArrayList into a 2D Array
  24. Java Modifying Elements in a foreach
  25. Interview question – Search in sorted array X for index i such that X[i] = i
  26. Convert byte[] to Base64 string for data URI
  27. Java Iterate Bits in Byte Array
  28. How to convert JSONArray to List with Gson?
  29. In Java, when is the {a,b,c,…} array shorthand inappropriate, and why?
  30. Array with UserType in Hibernate and PostgreSQL –> MappingException

Leave a Comment