store BLOB inside DB with playframework 1.2.4

Question

I know that by default plays JPA implementation uses DB to store references to BLOBs stored in file system, and I haven't found, by this far, any way to switch this behaviour. - Is it possible somehow? If yes, how?

My specyfic use case requires storing content of large text files inside DB to make access to them as fast as possible.

score 1 · Accepted Answer · answered Apr 17 '12 at 14:58

The correct way to do this is to use the @javax.persistence.Lob annotation.

There was a bug raised that the documentation does not cover the use case of saving data to a DB instead of a filesystem. The resolution to the bug was to point the asker to the following source code...

https://gist.github.com/1275419

score 0 · Answer 2 · edited May 23 '17 at 12:21

0

I based my solution for images on this gist and it works pretty well.

https://gist.github.com/660937

You can also store bytes if you need, look at this other SO question.

How is a blob column annotated in Hibernate?

Hope it helps.

edited May 23 '17 at 12:21

Community

1
1

answered Apr 17 '12 at 15:50

mericano1

2,914
1
18
25

store BLOB inside DB with playframework 1.2.4

2 Answers2