How to store image in JSP from BLOB captured in Oracle

[pavan kumarthati]

I wrote the following program But i am getting the NullpointerException regarding the storage of image in storeimage.jsp


form.jsp

   <form action="StoreImage.jsp" method="post" enctype="multipart/form-data" >
            <input type="file" name="path">
        <input type="submit" value="submit"></form>
 

storeImage.jsp

    String str=request.getParameter("path");         //Example path=c:\Sunset.jpg
            File file=new File(str);
            FileInputStream fis=new FileInputStream(file);
            ps.setBinaryStream(2, fis,(int) file.length());
            ps.execute();
            ps.close();
            con.close();

Any Answer regarding this is really appreciative........

[ujjwal soni]

Hi,

Try using below code.

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

public class insertImage{
  public static void main(String[] args) {
    System.out.println("Insert Image Example!");
    String driverName = "com.mysql.jdbc.Driver";
    String url = "jdbc:mysql://ujjwal_server:1521/";
    String dbName = "hibernatetutorial";
    String userName = "ujjwal";
    String password = "ujjwalbsoni";
    Connection con = null;
    try{
      Class.forName(driverName);
      con = DriverManager.getConnection(url+dbName,userName,password);
      Statement st = con.createStatement();
      File imgfile = new File("images.jpg");
      FileInputStream fin = new FileInputStream(imgfile);
      PreparedStatement pre = con.prepareStatement("insert into Photos_Table values(?,?,?)");
      pre.setInt(1,5);
      pre.setString(2,"Ujjwal");
      pre.setBinaryStream(3,fin,(int)imgfile.length());
      pre.executeUpdate();
      System.out.println("Inserting Successfully!");
      pre.close();
      con.close();  
    }
    catch (Exception e){
      System.out.println(e.getMessage());
      System.out.println("Error Processing image" + "Ujjwal");
    }
  }
} 

Cheers!!!

Ujjwal B Soni
<MSU BCA STUDENT 2007>

Helping hands are better than praying lips !!!

[Venkat Sadasivam]

You might need to use Multipart parser to get uploaded file content in server-side.
http://commons.apache.org/fileupload/using.html