Blob to ZIP

[m sandeep]

Hi all,

I have blob data in database which is actually containing a zip file . Now i want to retrieve the blob data from DB and convert it into a zip file .
I am using postgres 8.4 data base .
By doing it normally i am not able to get to see the contents that exists in the file.
Need some suggestion

[Ulf Dittmer]

What is "normally"? What, exactly, is your code doing?

[m sandeep]

FileOutputStream fos;
		try {
			fos = new FileOutputStream(finalPath);
		   	byte[] buffer=new byte[256];
	       InputStream is = new  ByteArrayInputStream(File.getExportedFileFileData().getBString());
	       while(is.read(buffer)>0){
		   fos.write(buffer);
	       }
	 	  fos.close();
	 		} catch (Exception e) {
	 			// TODO Auto-generated catch block
	 			e.printStackTrace();
	 		}
	 		System.err.println("Log  File Exported  >>>"+finalPath);
	 		return finalPath;
	 	  }

[Ulf Dittmer]

So what is this code doing, and how does that differ from what you were expecting?

I notice that you're ignoring the return value of the is.read method call - you can't do that: https://www.coderanch.com/how-to/java/ReadDoesntDoWhatYouThinkItDoes

[Rob Spoor]

And you should check for >= 0, not > 0. 0 is a valid return value that indicates no data is available at this moment, but there could be later on. (I've also edited that FAQ page since it also had > 0.)

[m sandeep]

Rob Spoor wrote:And you should check for >= 0, not > 0. 0 is a valid return value that indicates no data is available at this moment, but there could be later on. (I've also edited that FAQ page since it also had > 0.)

Thank you Rob and everyone for resolving the issue .It worked

[Rob Spoor]

You're welcome.