Snippet to create a file from the contents of a blob in Java

Question

I have some files stored in a database blob column in Oracle 9.

I would like to have those files stored in the file system.

This should be pretty easy, but I don't find the right snipped.

How can I do this in java?

 PreparedStatement ptmst = ...
 ResutlSet rs = pstmt.executeQuery();
 rs.getBlob();
 // mistery 
 FileOutputStream out = new FileOutputStream();
 out.write(); // etc et c

I know it should be something like that... what I don't know is what is commented as mistery

Thanks

EDIT

I finally got this derived from David's question.

This is my lazy implementation:

PreparedStatement pstmt = connection.prepareStatement("select BINARY from MYTABLE");
ResultSet rs = pstmt.executeQuery();
while( rs.next() ) {
    Blob blob = rs.getBlob("BINARY");
    System.out.println("Read "+ blob.length() + " bytes ");
    byte [] array = blob.getBytes( 1, ( int ) blob.length() );
    File file = File.createTempFile("something-", ".binary", new File("."));
    FileOutputStream out = new FileOutputStream( file );
    out.write( array );
    out.close();
}

David Winslow · Accepted Answer · 2009-07-02 22:58:41Z

27

You'd want to get the blob as an inputstream and dump its contents to the outputstream. So 'misery' should be something like:

Blob blob = rs.getBlob(column);
InputStream in = blob.getBinaryStream();
OutputStream out = new FileOutputStream(someFile);
byte[] buff = new byte[4096];  // how much of the blob to read/write at a time
int len = 0;

while ((len = in.read(buff)) != -1) {
    out.write(buff, 0, len);
}

If you find yourself doing a lot of IO work like this, you might look into using Apache Commons IO to take care of the details. Then everything after setting up the streams would just be:

IOUtils.copy(in, out);

answered Jul 2, 2009 at 22:58

David Winslow

8,6201 gold badge33 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

pjp Over a year ago

The brings back some good old memories using Oracle XML DB with Java.

j0k · Accepted Answer · 2012-12-27 10:53:33Z

1

There is another way of doing the same operation faster. Actually the answer above works fine but like IOUtils.copy(in,out) it takes a lot of time for big documents. The reason is you are trying to write your blob by 4KB iteration. Simplier solution :

Blob blob = rs.getBlob(column);
InputStream in = blob.getBinaryStream();
OutputStream out = new FileOutputStream(someFile);
byte[] buff = blob.getBytes(1,(int)blob.getLength());
out.write(buff);
out.close();

Your outputStream will write the blob in one shot.

Edit

Sorry didn't see the Edit section on the intial Post.

edited Dec 27, 2012 at 10:53

j0k

22.8k28 gold badges81 silver badges90 bronze badges

answered Dec 27, 2012 at 10:33

GiantSteps

111 bronze badge

Collectives™ on Stack Overflow

Snippet to create a file from the contents of a blob in Java

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related