Skip to main content

Retrieve File from table by using JDBC with example

To retrieve file from table by using the JDBC here is the example. Let's, come to the first to database as MySQL and table name as myFiles and column name as file_type. These table data we have already inserted files in previous program.

Now, we should retrieve from the ResultSet using getClob() method.

1
Clob file = rs.getClob();

Here, getClob() method retrieving data from column and storing it into Clob class object as file.

Use getCharacterStream() method which will available under the Clob object, it also gets the file data from Clob object into a reader object.

1
Reader r = file.getCharacterStream();

Here, we are reding data from Reader object r and writing it into FileWriter which stores it into a file as D:/OutPutFile.txt.

Registering the Driver and creating Connection and Statements are same in the all JDBC programs. In query we are fetching only file column from table. 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
package com.javatbrains.jdbc;

import java.io.FileWriter;
import java.io.IOException;
import java.io.Reader;
import java.sql.Clob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class RetrieveFiles {

   static Connection con = null;
   static Statement st = null;
   static ResultSet rs = null;

   public static void main(String[] args) throws IOException {
     try {
     // Register Driver
     DriverManager.registerDriver(new com.mysql.jdbc.Driver());

     // Establish Connection
     con = DriverManager
.getConnection("jdbc:mysql://localhost:3306/test?user=root&password=root");

     // Create a Statement
     st = con.createStatement();

     // Here is the query to fetch file column from table
     String query = "Select file_type from myfiles";

     // Execute the query by using the statement
     rs = st.executeQuery(query);
     FileWriter fw = null;
     while(rs.next()){
        // go to first row
        Clob file = rs.getClob(1);

        /*
        * Read file data from Clob instance name as file and sore into
        * Reader object
        */
        Reader r = file.getCharacterStream();

        /* Read data from reader and write into newfile.txt */
        int ch;
        fw = new FileWriter("D:/OutPutFile.txt");
          while ((ch = r.read()) != -1) {
            fw.write((char) ch);
          }
        } 
        fw.close();
      } catch (SQLException e) {
         e.printStackTrace();
      } finally {
         try {
           con.close();
           st.close();
           rs.close();
         } catch (SQLException e) {
           e.printStackTrace();
         }
      }

   }

}

Do you know?

Comments

Popular posts from this blog

JNDI configuration for Tomcat 9 with Oracle

In this article, I am going to place the required source code to get data from the table by using the JNDI configuration. Below are the environment details that I have configured currently. Windows - 7 Oracle - 10g Tomcat - 9 JDK - 8 Eclipse Oxygen Ojdbc6 jar required First, we need to create the Dynamic Web Project. If you don't know how to do <Click Here>. I have faced a lot of issues before getting the output like 405, No driver class to load, etc. I am using JSP & Servlets in the current explanation. Before started writing the application logic, we need to do the below configuration in the installed tomcat directory. Place OJDBC6.jar in the Tomcat LIB directory. Add this Resource under <GlobalNamingResources> in Server.xml file which is present under the conf directory in Tomcat. < Resource name = "jdbc/myoracle" global= "jdbc/myoracle" auth = "Container" type= "javax.sql.DataSource" driverClass...

Prime, Fibonacci and Factorial number with example in java

Prime number, Fibonacci series and Factorial number programs are most commonly asked questions in interview. Read this article to know what is and how to write programs for prime number, fibonacci series and factorial number. Prime Number: prime number is natural number greater than 1 that has no positive divisor other than 1 and itself. A natural number greater than 1 is not a prime number, is called Composite number . For example, 7 is a prime number. Because it can divide with 1 and 7 only. Where as 8 is composite number. Since it has the divisor 2 and 4 in addition to the 1 and 8. The below example represents the finding the passing number is prime number or not. If the passing number is prime number it will print true otherwise it will print false. package com . javatbrains . practice ; public class PrimeNumber { public boolean isPrimeNumber ( int number ) { if ( number <= 1 ) return false ; // There's only one ...

Multithreading in java with example

Multithreading  is one of the most important concept in core java. In this article we will learn what is multithreading? , what is the use of it? and What is the use of Synchronization and when to use it?  with detailed examples. At a time, two or more threads are accessing the same object is called as Multithreading  in Java .  First, we will create two threads for two objects. It is also possible to run two or more threads on a single class object. In this case, there is a possibility to get unreliable results. If the two threads are perform same task, then they need same object to be executed each time. For your better understanding, take an example of any reservations like, railway, movie ticket booking,etc. Let us think only one berth is available in a train and two passengers are asking for that berth. The first person has sent a request to allocate that ticket/berth to him. At the same time, the second person also sent a request to allocate that ...