Getting BLOB Data from a Database Table: how to retrieves bytes from a BLOB. : Blob Clob « Database « Java Tutorial

import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Main {
  public static void main(String[] argv) throws Exception {
    String driverName = "com.jnetdirect.jsql.JSQLDriver";

    String serverName = "";
    String portNumber = "1433";
    String mydatabase = serverName + ":" + portNumber;
    String url = "jdbc:JSQLConnect://" + mydatabase;
    String username = "username";
    String password = "password";

    Connection connection = DriverManager.getConnection(url, username, password);
    Statement stmt = connection.createStatement();
    ResultSet rs = stmt.executeQuery("SELECT col_blob FROM mysql_all_table");

    if ( {
      Blob blob = rs.getBlob("col_blob");
      long blobLength = blob.length();

      int pos = 1; // position is 1-based
      int len = 10;
      byte[] bytes = blob.getBytes(pos, len);

      InputStream is = blob.getBinaryStream();
      int b =;

20.22.Blob Clob
20.22.1.Getting and Inserting Binary Data into an Database Table
20.22.2.Store BLOBs data into database
20.22.3.Read BLOBs data from database
20.22.4.Blob and Clob data type
20.22.5.Getting BLOB Data from a Database Table: how to retrieves bytes from a BLOB.
20.22.6.Store CLOBs data into database?
20.22.7.Read CLOBs data from database
20.22.8.Insert an Image
20.22.9.Retrieve an Image