PDF file getting corrupted after clob been written as PDF file in Java

Question

I am using hibernate to insert a pdf file as bytes into database using the below code.

File file = new File("D:\\test.pdf");
byte[] imageData = new byte[(int) file.length()];
FileInputStream fileInputStream = new FileInputStream(file);
fileInputStream.read(imageData);
fileInputStream.close();
emp.setClobdata(new String(imageData));
session.save(emp);

Then I am trying to write the file from database to a pdf file. Using the below code. But the pdf is getting corrupted.

Emp emp = (Emp) session.get(Emp.class, 2);
byte[] b = emp.getClobdata().getBytes();
FileOutputStream fout = new FileOutputStream("D:\\some.pdf");
fout.write(b); fout.flush();

What I am doing wrong with this code?

Can you say more about your database?

dpassage
– dpassage

2014-01-18 03:15:57 +00:00
Commented Jan 18, 2014 at 3:15 — dpassage
– dpassage, Commented Jan 18, 2014 at 3:15

jtahlborn · Accepted Answer · 2014-01-08 18:06:20Z

2

pdf files are binary, you should be using a BLOB not a CLOB.

also, when you read from the file, you need to use something like DataInputStream.readFully to ensure you are reading all the data.

answered Jan 8, 2014 at 18:06

jtahlborn

53.8k5 gold badges80 silver badges122 bronze badges

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

3 Comments

user3173304 Over a year ago

Thanks for your response. I have tried using BLOB in my database. Still issue exists. Could you be bit more specific about DataInputStream.readFully that would really help me.

user3173304 Over a year ago

The updated code is same. All I did was changed the database field type as BLOB. I am experiencing problems with the above mentioned code snippets

jtahlborn Over a year ago

@user3173304 - if your code is the same, then you missed a key point. the data is binary, so you should be treating it as bytes exclusively, not chars (or String).

Collectives™ on Stack Overflow

PDF file getting corrupted after clob been written as PDF file in Java

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related