how do I store an image to an Oracle database?

Question

How do I store an image into an Oracle database? And how do I retrieve an image from that database? Here is my code:

import java.io.*; 
import java.sql.*; 
import java.util.*; 
class Pic3 
{ 
    public static void main(String args[]) throws Exception 
    { 
        Statement s; 
        Connection c; 
        FileInputStream fis; 
        PreparedStatement ps; 
        File file; 
        try 
        { 
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
            c=DriverManager.getConnection("Jdbc:Odbc:sidhu","system","system"); 
            s=c.createStatement(); 
            s.execute("Create table Img1(Image_No number(5),Photo blob)"); 
        } 
        catch(Exception e1) 
        { 
            e1.printStackTrace(); 
        } 

        try 
        { 
            file=new File("f:/image.jpeg"); 
            fis=new FileInputStream(file); 

            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
            c=DriverManager.getConnection("Jdbc:Odbc:sidhu","system","system"); 

            String str="insert into Img1 values(?,?)"; 
            ps=c.prepareStatement(str); 
            ps.setInt(1,(int)file.length()); 
            ps.setBinaryStream(2,fis,(int)file.length()); 

            //System.out.println("success"); 
            ps.execute(); 

            ps.close(); 
            c.close(); 
        } 
            catch(SQLException e) 
        { 
            e.printStackTrace(); 
        } 
    } 
}

Don't store images in DB .. store the images in a location and then store the path of the image in the DB. Retrieve the image from the location when ever required. http://stackoverflow.com/questions/1212991/do-you-think-its-a-good-idea-to-save-billions-of-images-into-database — Amarnath, Nov 18 '12 at 06:45

sunleo · Accepted Answer · 2012-11-18T06:43:00.610

1

change thess lines like this

Class.forName("oracle.jdbc.driver.OracleDriver");
ps.setBinaryStream(2,fis,(byte)file.length());

instead of

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
ps.setBinaryStream(2,fis,(int)file.length());

because

JDBC-ODBC bridge driver doesn't support blobs, even if the underlying database does.

edited Nov 18 '12 at 06:43

answered Nov 18 '12 at 06:31

sunleo

10,589
35
116
196

plese provide how to get that insert image – Bhaskar Nov 21 '12 at 14:41
you mean , you want to retrieve image stored image in Oracle , am I right?? – sunleo Nov 21 '12 at 14:56

how do I store an image to an Oracle database?

1 Answers1