Insert blob files into Oracle using Java

In this article  I will discuss how to insert a image into database table using PreparedStatement interface of java. All other blob files can be handled in same way. You will need ojdbc6.jar as the oracle driver. If you try to use ojdbc14.jar you may get the following exception :

Exception in thread "main" java.lang.AbstractMethodError:

 Theoracle.jdbc.driver.T4CPreparedStatement.setBinaryStream(ILjava/io/InputStream;)V

Now let's create a database table using the following sql command.

create table imagetable ( imageid numeric(5) , image blob);

Now use the following java code to insert a image in the table.

Class.forName("oracle.jdbc.driver.OracleDriver"); 

Connection connect = DriverManager.getConnection  

                       ("jdbc:oracle:thin:@IP_ADDRESS:PORT_NUMBER/SERVICE_NAME" ,"username","password"); 

String filename = "Your filename here" ; 

InputStream input = new FileInputStream(filename); 

PreparedStatement pstmt = connect.prepareStatement("insert into imagetable values(?,?)"); 

pstmt.setBinaryStream(2, input); 

pstmt.setInt(1, 1); 

pstmt.execute();

Also change the connection parameters according to your's.