Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to set and get images in Oracle databse

 
Manish Tiwari
Greenhorn
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;
try{
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;
while(rs.next())
{
blob=rs.getBlob(1);
}

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

}

}

}
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic