How to Store doc, jpeg, pdf files in postgreSQL using java

Question

In a web application I want to store all doc, jpeg, pdf files in postgreSQL database. I know it can also be done by storing it on file system and storing its path in db, but I am not looking for that solution. I want to know following things:

What should be data type for a table.
Does it maintain formatting of doc ?
And how storing it in postgreSQL can be achieved using java, hibernate technology. IS it required to create nativeSQL query?

Any pointers for this issue will be helpful.

Community · Accepted Answer · 2017-05-23 12:29:10Z

10

You'll want to store the binary data as the bytea type. Here is an example using JDBC and Postgres bytea:

http://jdbc.postgresql.org/documentation/80/binary-data.html

This post about using bytea and Hibernate might be of some use: proper hibernate annotation for byte[]

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Jul 24, 2012 at 5:11

Cody Caughlan

32.8k5 gold badges67 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

How to Store doc, jpeg, pdf files in postgreSQL using java

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related