Upload Image into database with Java

In this article, I am going to describe how to upload images to an Oracle database using an java. below are steps for do this.

1. Create table which have a blob data type.
2. Write java program.

Let's see how to insert image into database.Here is the explanation

Create table using oracle database.

Create table image
   name varchar2(20),
   photo blob

Java Program

import java.sql.*;
import java.io.*;

public class ImageWriter {

	static Connection connection = null;
	static CallableStatement pstat = null;
	static String connectionURL = null;

	public static void main(String[] args) {
		Class.forName("oracle connection class");
		connection = DriverManager.getConnection("connection url", "username", "password");

		PreparedStatement pstat = connection.prepareStatement("insert into image(name,photo) values(?,?)");

		FileInputStream fin = new FileInputStream("D:\\test.jpg");
		pstat.setString(1, "ABC");
		pstat.setBinaryStream(2, fin, fin.available());

		int result = pstat.executeUpdate();
		System.out.println(result + " Record Successfully Inserted");


		}catch(Exception e){



Result : 1 Record Successfully Inserted