Read CLOBs data from database : Blob Clob « Database « Java Tutorial

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Main {
  private static String url = "jdbc:oracle:thin:@localhost:1521:javaDemo";

  private static String username = "java";

  private static String password = "welcome";

  public static void main(String[] args) throws Exception {
    Connection conn = DriverManager.getConnection(url, username, password);
    PreparedStatement stmt = conn.prepareStatement("SELECT name, description, data FROM documents ");
    ResultSet resultSet = stmt.executeQuery();
    while ( {
      String name = resultSet.getString(1);
      String description = resultSet.getString(2);
      File data = new File("C:\\a.txt");
      Reader reader = resultSet.getCharacterStream(3);
      FileWriter writer = new FileWriter(data);
      char[] buffer = new char[1];
      while ( > 0) {

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