Oracle - Extraer bytes[] de campo BLOB

import java.io.File;

import java.io.FileOutputStream;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

public class Main {

  static String url = "jdbc:oracle:thin:@localhost:1521:BaseDatos";

  static String username = "usuario";

  static String password = "contraseña";

  public static void main(String[] args) throws Exception {

    Class.forName("oracle.jdbc.driver.OracleDriver");

    Connection conn = DriverManager.getConnection(url, username, password);

    String sql = "SELECT campo_id, campo_blob FROM tabla_con_blob";

    PreparedStatement stmt = conn.prepareStatement(sql);

    ResultSet resultSet = stmt.executeQuery();

    //Este buqle es para recuperar todos los registros.

    while (resultSet.next()) {

      String id_campo = resultSet.getString(1);

      File blob = new File("C:\\blob"+id_campo+".algo");

      FileOutputStream fos = new FileOutputStream(blob);

      byte[] buffer = new byte[1];

      InputStream is = resultSet.getBinaryStream(3);

      //Este buqle va recuperando el BLOB

      while (is.read(buffer) > 0) {

        fos.write(buffer);

      }

      fos.close();

    }

    conn.close();

  }

}