• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to set and get images in Oracle databse

Manish Tiwari
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Friends here is my code it runs succesfully but when i try to see the image
stored in the file it gives me windows error saying bmp is not a valid file .
can i get the code for saving and retriving the image in BLOB column of database .
PLZ help .
package test;
import java.sql.*;
import java.io.*;
public class GetImage
public static void main(String args[])
Blob blob = null;
Connection1DB cdb = new Connection1DB();
Connection conn = (Connection)(cdb.getConnection());
System.out.println("Got the connection");
FileOutputStream fos= new FileOutputStream("E:/javatest/dbimage.bmp");
String sql1= "select IMAGE1 from IMAGE ";
Statement stmts = conn.createStatement();
ResultSet rs = stmts.executeQuery(sql1);
InputStream ims=null;

long len= blob.length();
byte collect[]= blob.getBytes(1l,(int)len);
System.out.println(""+ collect);
catch(Exception e)



  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic