What is the significance of @javax.persistence.Lob annotation in JPA?

JavaJpaAnnotationsJava Ee-7

Java Problem Overview


When should I use @javax.persistence.Lob annotation in JPA? What datatypes can be annotated by this annotation?

Java Solutions


Solution 1 - Java

@javax.persistence.Lob signifies that the annotated field should be represented as BLOB (binary data) in the DataBase.

You can annotate any Serializable data type with this annotation. In JPA, upon persisting (retrieval) the field content will be serialized (deserialized) using standard Java serialization.

Common use of @Lob is to annotate a HashMap field inside your Entity to store some of the object properties which are not mapped into DB columns. That way all the unmapped values can be stored in the DB in one column in their binarry representation. Of course the price that is paid is that, as they are stored in binary format, they are not searchable using the JPQL/SQL.

Solution 2 - Java

According to: <https://docs.oracle.com/javaee/7/api/javax/persistence/Lob.html>

@Lob Specifies that a persistent property or field should be persisted as a large object to a database-supported large object type.

> @javax.persistence.Lob signifies that the annotated field should be > represented as BLOB (binary data) in the DataBase.

I suppose in database it could be not only binary data but character-based. As we could have BLOB and CLOB. Here's examples in java code:

@Lob
@Column(name = "CHARS", columnDefinition = "CLOB")
private String chars;`

@Lob
@Basic(fetch = FetchType.LAZY)
@Column(name = "DATA", columnDefinition = "BLOB", nullable = false)
private byte[] data;

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionDevView Question on Stackoverflow
Solution 1 - JavaZieluView Answer on Stackoverflow
Solution 2 - JavalevrunView Answer on Stackoverflow