Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes How to set and get images in Oracle databse   Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "How to set and get images in Oracle databse   " Watch "How to set and get images in Oracle databse   " New topic
Author

How to set and get images in Oracle databse

Manish Tiwari
Greenhorn

Joined: May 19, 2004
Posts: 5
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();

}

}

}
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to set and get images in Oracle databse
 
Similar Threads
problem in getting Blob data and displaying
Retreving PDF File from Database using Java
write pdf files whith servlets
getblob from db, then convert to byte and write to bitmap/jpeg
Writing as a JPG file to disk