JPA Tutorial - JPA Lob Column Example

• « Previous
• Next »

The following code shows how to save byte array to database with @Lob annotation.

LOBs have two types in the database: character large objects, called CLOBs, and binary large objects, or BLOBs.

A CLOB column holds a large character sequence, and a BLOB column can store a large byte sequence.

The Java types mapped to BLOB columns are byte[] Byte[] , and Serializable types, while char[] Character[] , and String objects are mapped to CLOB columns.

Example

The following code is from Person.java.

package com.java2s.common;

import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.Table;

@Entity
@Table(name="EMP")
public class Person {
  @Id
  @Column(name = "EMP_ID")
  private long id;
  
  @Basic
  private String name;
  private String surname;
  
  @Lob 
  private byte[] picture;
  
  public Person() {}

  public Person(String name, String surname) {
    this.name = name;
    this.surname = surname;
  }
  
  public Long getId() {
    return id;
  }
  public void setId(Long id) {
    this.id = id;
  }
  public String getName() {
    return name;
  }
  public void setName(String name) {
    this.name = name;
  }
  public String getSurname() {
    return surname;
  }
  public void setSurname(String surname) {
    this.surname = surname;
  }
  
  public byte[] getPicture() {
    return picture;
  }

  public void setPicture(byte[] picture) {
    this.picture = picture;
  }

  @Override
  public String toString() {
    return "Person [id=" + id + ", name=" + name + ", surname=" + surname + "]";
  }
}

The following code is from PersonDaoImpl.java.

package com.java2s.common;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

import org.springframework.transaction.annotation.Transactional;

@Transactional
public class PersonDaoImpl {

  @PersistenceContext
  private EntityManager em;
  
  
  public Long save(Person person) {
    em.persist(person);
    return person.getId();
  }
  
  public List<Person>getAll() {
    return em.createQuery("SELECT p FROM Person p", Person.class).getResultList();
  }
  
}

The code above generates the following result.

The following is the database dump.

Table Name: EMP
 Row:
    Column Name: EMP_ID,
    Column Type: BIGINT:
    Column Value: 1

    Column Name: NAME,
    Column Type: VARCHAR:
    Column Value: Tom

    Column Name: PICTURE,
    Column Type: BLOB:
    Column Value: org.hsqldb.jdbc.JDBCBlobClient@5520ae93

    Column Name: SURNAME,
    Column Type: VARCHAR:
    Column Value: Smith

 Row:
    Column Name: EMP_ID,
    Column Type: BIGINT:
    Column Value: 2

    Column Name: NAME,
    Column Type: VARCHAR:
    Column Value: Jack

    Column Name: PICTURE,
    Column Type: BLOB:
    Column Value: null

    Column Name: SURNAME,
    Column Type: VARCHAR:
    Column Value: Kook

• Next »
• « Previous