Hibernate Community • View topic - @LOB or path to file?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

@LOB or path to file?

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

nimo23

Post subject: @LOB or path to file?

Posted: Tue Jun 02, 2009 4:58 am

Regular

Joined: Tue Jun 03, 2008 1:12 pm
Posts: 84
Location: germany

I want to store large data objects (size of a data object ~ 100-200 MB) via Hibernate (and mySQL).

What is better:

- to store only the path of a data object in a database:

Code:

@Column(name = "PATH_TO_FILE", nullable = true, insertable = true, updatable = true)
private String pathToFile;

or to store it via LOB. If stored via @Lob, how should I do the mapping:

this way:

Code:

@Lob
private byte[] file;

or that way:

Code:

@Lob
private Blob file;

where lies the differences? Are there other (better) ways?

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum