Unable to open zip file in filesystem retrived from sybase database

[Raja Roy]

Hi,
I have written a java prog which is retriving blob data from my sybase database which i stored as a zip file

PreparedStatement psmt=con.prepareStatement("insert into temp_blob values(?,?)");
File zipname=new File("C:\\1763.zip");
FileInputStream fstream=new FileInputStream(zipname);
psmt.setInt(1,240);
psmt.setBinaryStream(2,fstream,(int)zipname.length());
int count=psmt.executeUpdate();
con.commit();
if(count>0)
{
System.out.println("table data is inserted");
}

this thing working fine and data is inserted .Now I am trying to retrieve this zip I stored and keep it in different directory in filesystem. For that I have done this

PreparedStatement psmt = con
.prepareStatement("select * from temp_blob");
ResultSet rs = psmt.executeQuery();
while (rs.next()) {
System.out.println("PIID IS " + rs.getInt(1));
byte[] bk = rs.getBytes(2);
System.out.println(bk.length);
File f = new File("C:\\11\\dest.zip");
if (!f.exists()) {
f.createNewFile();
}
ByteArrayInputStream baos = new ByteArrayInputStream(bk);
ZipInputStream zis = new ZipInputStream(baos);
ZipOutputStream zos = new ZipOutputStream(new FileOutputStream(
"C:\\11\\dest.zip"));
zos.setLevel(Deflater.DEFAULT_COMPRESSION);
for (ZipEntry ze = zis.getNextEntry(); ze != null;ze = zis.getNextEntry()) {
if (ze.getName() != null) {
zos.putNextEntry(ze);
byte[] buffer = new byte[bk.length];
for (int read = zis.read(buffer); read != -1; read = zis
.read(buffer)) {
zos.write(buffer, 0, read);
}
zos.closeEntry();
}
}
}

For information the zip file I stored contains two xml file
and this prog working fine a zip is created with required size but when I try to open that it is giving error
I have also done a simple prog to check zip functionality like created a zip and move two txt file in that .the case is that zip also not opening

[Richard Tookey]

Why are you unzipping the stream and then re-zipping it to write it out to the new file. Why are you not just writing the binary stream to the output file without unzipping it.