Writing as a JPG file to disk

[ram kumar]

The Image gets written to disk and says file size also.

But am unable to see the image.

Some one clarify me on this.

I have Submitted the code.

What am doing is -

I am reading a blob as a byte and trying to save it to disk.

it saves to disk but unable to view the image.

   
import java.awt.image.BufferedImage;
import java.io.FileOutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.imageio.ImageIO;



public class ByteToPicture 
{
	
	public void ByteToPictureConverter()
	{
		byte[] byImageByte  = new byte[5000];
		
		byImageByte = null;
		
		try
		{
			Connection con;
		    Statement stmt;
		    ResultSet rs;
	    	
	    	Class.forName("oracle.jdbc.driver.OracleDriver");
	    
	    	String url = "jdbc:oracle:thin:senet/senet@172.20.175.71:1521:banking9";
	    	
	    	String username = "senet";
	    	
	    	String password = "senet";
	    	
	    	con = DriverManager.getConnection(url,username, password);
	    	
	    	stmt = con.createStatement();
	    	
	    	rs = stmt.executeQuery("select pic_byte from picture_master where picid = 'hai'");
	    	
	    	rs.next();
	    	
	    	//while(rs.next())
	    	{
	    	
	    	
	    	java.sql.Blob blb = (java.sql.Blob)rs.getObject(1);
	    	
	    	byImageByte = blb.getBytes(1,(int)blb.length());    	

	    	System.out.println("byImageByte = "+byImageByte);
	    	
	    	}
	    	
	    	FileOutputStream fout = new FileOutputStream("c:/senet/img.jpg");
	    	
	    	fout.flush();
	    	
	    	fout.write(byImageByte);
	    	
	    	fout.close();
	    	
	    	rs.close();
	    	
	    	stmt.close();
	    	
	    	con.close();
	    	
		}
		catch(Exception e)		
		{
			System.out.println("ByteToPicture :: Exception "+e);
			
		}
		
	}
	
	public static void main(String args[])
	{
		ByteToPicture objByteToPicture = new ByteToPicture();
		
		objByteToPicture.ByteToPictureConverter();
	
	}

}
 

[Ulf Dittmer]

What does "unable to view the image" mean? How are yoo trying to view it, and what happens?

Does the image file have the same size as the bytes array you're retrieving from the DB?

The call to "flush" should occur after the call to "write", not before.

[ram kumar]

Am using the windows picture and fax viewer to view the file.

it gets saved to disk. it shows the same size as the source image that i uploaded to DB as a BLOB

Am not able to view the image in the picture and fax viewer application like the source image.

i did that with fout.flush() after fout.write().

Still this problem persists

[William Brogden]

If this was my problem I would use a programmer's editor capable of showing the hex value of bytes to look at both the original jpg and the file recovered from the DB and written.

I bet you will see that something has corrupted the data recovered from the DB and it no longer resembles the original.

I use the ultraedit editor - best money I ever spent, but you may find that your existing editor can display byte values.

Bill

[ram kumar]

William Brogden wrote:If this was my problem I would use a programmer's editor capable of showing the hex value of bytes to look at both the original jpg and the file recovered from the DB and written.

I bet you will see that something has corrupted the data recovered from the DB and it no longer resembles the original.

I use the ultraedit editor - best money I ever spent, but you may find that your existing editor can display byte values.

Bill

Would you just help me in getting some links regarding this.

i google'd but still i need some more information of

1.how to convert a jpg to blob

2.update oracleDB with the blob.

----------

3. retrive the blob

4.save that in disk as a jpg file.

[Martijn Verburg]

1.how to convert a jpg to blob
2.update oracleDB with the blob.
3. retrive the blob
4.save that in disk as a jpg file.


1.) Save as a ByteArray/ByteStream
2.) Simple Insert/Update statement will do it
3.) Simple select command will do it
4.) Write out as a ByteStream/ByteArray

You really need to look into the File I/O APIs an pay particular attention to _encoding_, e.g. Make sure your encoding is consistent throughout each stage. This article can help and make sure to look at our I/O FAQ

[steve souza]

It seems like you are assuming the bytes in the database are already in the proper format and simply write them to a file. There are many different image formats. Look at this info and see if you can create your own in memory image and write it to disk

http://java.sun.com/j2se/1.4.2/docs/guide/imageio/spec/imageio_guideTOC.fm.html

[ram kumar]

steve souza wrote:It seems like you are assuming the bytes in the database are already in the proper format and simply write them to a file. There are many different image formats. Look at this info and see if you can create your own in memory image and write it to disk

http://java.sun.com/j2se/1.4.2/docs/guide/imageio/spec/imageio_guideTOC.fm.html

Finally this code worked successfully !

I dont know what cases it will fail, but it worked Awesome for uploading images to jpg.

Max File Size uploaded is 25.7 kb

From windows file to oracle DB - Use PictureToBLOB2

From BLOB in DB to File at windows - Use BLOBToPicture2

  

//From windows file to oracle DB 

import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;


public class PictureToBLOB2 
{
	
	public void PictureToByteConverter(int intval)
	{
		//create a table with pic_master as 
		
		/*
		 * SQL> desc picture_master;
 			
 			Name                                      Null?    Type
 			----------------------------------------- -------- ----------------------------

 			PICTURENUMBER                             NOT NULL VARCHAR2(10)
 			PICTURE_BYTE                              NOT NULL BLOB

			SQL>
		 * 
		 */
		String stmInsert = "insert into pic_master values('"+intval+"',EMPTY_BLOB())";
		
		String stmt = "update pic_master set pic_byte=? where picnumber=?";
		
		
		try
		{
			//Byte Convertion
			
			FileInputStream fis = new FileInputStream(new File("C://images//im"+intval+".jpg"));
			
		 	byte[] fileByte = new byte[fis.available()];
		 	
		    if(fis.read(fileByte)!=fis.available())
		    {
		    	System.out.println("file byte = "+fileByte);
		    }
		 	System.out.println("Done");
	        
	        FileOutputStream fos  = new FileOutputStream("C://senet//Senetdev//codeimages//imagetoBLOB"+intval+".jpg");
	        fos.write(fileByte);
	        fos.flush();
	        fos.close();
 	        
	        
	        
	        
			Connection con;
			Statement st;
		    PreparedStatement pstmt;
	    	
	    	Class.forName("oracle.jdbc.driver.OracleDriver");
	    
	    	String url = "jdbc:oracle:thin:senet/senet@172.20.175.71:1521:banking9";
	    	
	    	String username = "senet";
	    	
	    	String password = "senet";
	    	DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
	    	con = DriverManager.getConnection(url);
	    	st = con.createStatement();
	    	pstmt=con.prepareStatement(stmt);	    	
	    	oracle.sql.BLOB newBlob = oracle.sql.BLOB.createTemporary(con, false,oracle.sql.BLOB.DURATION_SESSION);
	 		System.out.println("Connection:"+con);
	 		newBlob.putBytes(1,fileByte);
	 		pstmt.setBlob(1,newBlob);
	 		pstmt.setString(2,intval+"");
	 		
	 		int inRowInsertCount = st.executeUpdate(stmInsert);
	 		System.out.println("inRowInsertCount = "+inRowInsertCount);
	 		
	 		
	 		int inRowCount = pstmt.executeUpdate();
	 		System.out.println("inRowCount  = "+inRowCount);
	 		con.commit();
	 		con.close();
	 		pstmt.close();
		}
		catch(Exception e)
		{
			System.out.println("PictureToByte :: Exception :: "+e);
		}
	}
	
	public static void main(String args[])
	{
		PictureToBLOB2 objPictureToByte = new PictureToBLOB2();
		
		for(int i=0;i<100;i++)
		{
		objPictureToByte.PictureToByteConverter(i);
		}
		
	}

}

 

Convert from BLOB to Picture

i used this code :

  


import java.io.FileOutputStream;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

import java.sql.Statement;





public class BLOBToPicture2 
{
	
	
	public void ByteToPictureConverter(int intval)
	{	
		try
		{	
			Connection con;
		    Statement stmt;
		    ResultSet rs;
	    	
	    	Class.forName("oracle.jdbc.driver.OracleDriver");
	    
	    	String url = "jdbc:oracle:thin:senet/senet@172.20.175.71:1521:banking9";
	    	
	    	String username = "senet";
	    	
	    	String password = "senet";
	    	
	    	con = DriverManager.getConnection(url,username, password);
	    	
	    	stmt = con.createStatement();
	    	byte[] byImageByte  = null;
	    	rs = stmt.executeQuery("select pic_byte from pic_master where picnumber = '"+intval+"'");
	    	if(rs.next())
	    	{
	    	java.sql.Blob blb = (java.sql.Blob)rs.getObject(1);
	    	byImageByte  = blb.getBytes(1,(int)blb.length());
	    	}
	    	System.out.println("Done");
			
	    	
	    	FileOutputStream fout = new FileOutputStream("c://senet//Senetdev//BLOBimages//BLOBtoDisk"+intval+".jpg");
	    	fout.write(byImageByte);
	    	fout.flush();
	    	fout.close();
		}
		catch(Exception e)		
		{
			System.out.println("ByteToPicture :: Exception "+e);
			
		}
		
	}

	
		

	
	public static void main(String args[])
	{
		BLOBToPicture2 objByteToPicture2 = new BLOBToPicture2();
		
		for(int i=0;i<100;i++)
		{
		objByteToPicture2.ByteToPictureConverter(i);
		}
		//objByteToPicture2.readBLOBToFileStream();
		
//		objByteToPicture2.writeBLOBStream();
	}

}