<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="ru">
		<id>http://jexp.ru/index.php?action=history&amp;feed=atom&amp;title=Java_Tutorial%2FJPA%2FClob_Blob</id>
		<title>Java Tutorial/JPA/Clob Blob - История изменений</title>
		<link rel="self" type="application/atom+xml" href="http://jexp.ru/index.php?action=history&amp;feed=atom&amp;title=Java_Tutorial%2FJPA%2FClob_Blob"/>
		<link rel="alternate" type="text/html" href="http://jexp.ru/index.php?title=Java_Tutorial/JPA/Clob_Blob&amp;action=history"/>
		<updated>2026-04-11T13:21:07Z</updated>
		<subtitle>История изменений этой страницы в вики</subtitle>
		<generator>MediaWiki 1.30.0</generator>

	<entry>
		<id>http://jexp.ru/index.php?title=Java_Tutorial/JPA/Clob_Blob&amp;diff=5184&amp;oldid=prev</id>
		<title>Admin: 1 версия</title>
		<link rel="alternate" type="text/html" href="http://jexp.ru/index.php?title=Java_Tutorial/JPA/Clob_Blob&amp;diff=5184&amp;oldid=prev"/>
				<updated>2010-06-01T05:18:32Z</updated>
		
		<summary type="html">&lt;p&gt;1 версия&lt;/p&gt;
&lt;table class=&quot;diff diff-contentalign-left&quot; data-mw=&quot;interface&quot;&gt;
				&lt;tr style=&quot;vertical-align: top;&quot; lang=&quot;ru&quot;&gt;
				&lt;td colspan=&quot;1&quot; style=&quot;background-color: white; color:black; text-align: center;&quot;&gt;← Предыдущая&lt;/td&gt;
				&lt;td colspan=&quot;1&quot; style=&quot;background-color: white; color:black; text-align: center;&quot;&gt;Версия 05:18, 1 июня 2010&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; style=&quot;text-align: center;&quot; lang=&quot;ru&quot;&gt;&lt;div class=&quot;mw-diff-empty&quot;&gt;(нет различий)&lt;/div&gt;
&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;</summary>
		<author><name>Admin</name></author>	</entry>

	<entry>
		<id>http://jexp.ru/index.php?title=Java_Tutorial/JPA/Clob_Blob&amp;diff=5183&amp;oldid=prev</id>
		<title> в 17:44, 31 мая 2010</title>
		<link rel="alternate" type="text/html" href="http://jexp.ru/index.php?title=Java_Tutorial/JPA/Clob_Blob&amp;diff=5183&amp;oldid=prev"/>
				<updated>2010-05-31T17:44:27Z</updated>
		
		<summary type="html">&lt;p&gt;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;Новая страница&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==  Java Byte Array Lob Mapped To Long VarBinary ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;p&amp;gt;File: Main.java&amp;lt;/p&amp;gt;&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;java&amp;quot;&amp;gt;&lt;br /&gt;
import java.util.Collection;&lt;br /&gt;
import java.util.List;&lt;br /&gt;
import javax.persistence.EntityManager;&lt;br /&gt;
import javax.persistence.EntityManagerFactory;&lt;br /&gt;
import javax.persistence.Persistence;&lt;br /&gt;
import javax.persistence.Query;&lt;br /&gt;
public class Main {&lt;br /&gt;
  static EntityManagerFactory emf = Persistence.createEntityManagerFactory(&amp;quot;JPAService&amp;quot;);&lt;br /&gt;
  static EntityManager em = emf.createEntityManager();&lt;br /&gt;
  public static void main(String[] a) throws Exception {&lt;br /&gt;
    em.getTransaction().begin();&lt;br /&gt;
    &lt;br /&gt;
    &lt;br /&gt;
    Student student = new Student();&lt;br /&gt;
    student.setId(1);&lt;br /&gt;
    student.setName(&amp;quot;Joe&amp;quot;);&lt;br /&gt;
    student.setPicture(&amp;quot;pic&amp;quot;.getBytes());&lt;br /&gt;
    &lt;br /&gt;
    em.persist(student);&lt;br /&gt;
    em.flush();&lt;br /&gt;
    em.getTransaction().rumit();&lt;br /&gt;
    &lt;br /&gt;
    Query query = em.createQuery(&amp;quot;SELECT e FROM Student e&amp;quot;);&lt;br /&gt;
    List&amp;lt;Student&amp;gt; list = (List&amp;lt;Student&amp;gt;) query.getResultList();&lt;br /&gt;
    System.out.println(list);&lt;br /&gt;
    &lt;br /&gt;
    &lt;br /&gt;
    em.close();&lt;br /&gt;
    emf.close();&lt;br /&gt;
    &lt;br /&gt;
    Helper.checkData();&lt;br /&gt;
  }&lt;br /&gt;
}&amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- end source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==  Map Serializable Entity To Lob ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;p&amp;gt;File: Customer.java&amp;lt;/p&amp;gt;&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;java&amp;quot;&amp;gt;&lt;br /&gt;
import javax.persistence.*;&lt;br /&gt;
import java.util.Date;&lt;br /&gt;
@Entity&lt;br /&gt;
public class Customer implements java.io.Serializable &lt;br /&gt;
{&lt;br /&gt;
   private int id;&lt;br /&gt;
   private JPEG picture;&lt;br /&gt;
   &lt;br /&gt;
   @Id&lt;br /&gt;
   @GeneratedValue&lt;br /&gt;
   public int getId()&lt;br /&gt;
   {&lt;br /&gt;
      return id;&lt;br /&gt;
   }&lt;br /&gt;
   public void setId(int pk) &lt;br /&gt;
   {&lt;br /&gt;
      id = pk;&lt;br /&gt;
   }&lt;br /&gt;
&lt;br /&gt;
   @Lob @Basic(fetch=FetchType.LAZY)&lt;br /&gt;
   public JPEG getPicture() { return picture; }&lt;br /&gt;
   public void setPicture(JPEG jpeg) { picture = jpeg; }&lt;br /&gt;
}&amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- end source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==  Mark Abstract Entity With Mapped Superclass ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;p&amp;gt;File: Employee.java&amp;lt;/p&amp;gt;&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;java&amp;quot;&amp;gt;&lt;br /&gt;
import java.util.Date;&lt;br /&gt;
import javax.persistence.Column;&lt;br /&gt;
import javax.persistence.DiscriminatorColumn;&lt;br /&gt;
import javax.persistence.DiscriminatorValue;&lt;br /&gt;
import javax.persistence.Entity;&lt;br /&gt;
import javax.persistence.Id;&lt;br /&gt;
import javax.persistence.Inheritance;&lt;br /&gt;
import javax.persistence.MappedSuperclass;&lt;br /&gt;
import javax.persistence.Table;&lt;br /&gt;
import javax.persistence.Temporal;&lt;br /&gt;
import javax.persistence.TemporalType;&lt;br /&gt;
@Entity&lt;br /&gt;
@Table(name = &amp;quot;EMP&amp;quot;)&lt;br /&gt;
@Inheritance&lt;br /&gt;
@DiscriminatorColumn(name = &amp;quot;EMP_TYPE&amp;quot;)&lt;br /&gt;
public abstract class Employee {&lt;br /&gt;
  @Id&lt;br /&gt;
  private int id;&lt;br /&gt;
  private String name;&lt;br /&gt;
  @Temporal(TemporalType.DATE)&lt;br /&gt;
  @Column(name = &amp;quot;S_DATE&amp;quot;)&lt;br /&gt;
  private Date startDate;&lt;br /&gt;
  public int getId() {&lt;br /&gt;
    return id;&lt;br /&gt;
  }&lt;br /&gt;
  public void setId(int id) {&lt;br /&gt;
    this.id = id;&lt;br /&gt;
  }&lt;br /&gt;
  public String getName() {&lt;br /&gt;
    return name;&lt;br /&gt;
  }&lt;br /&gt;
  public void setName(String name) {&lt;br /&gt;
    this.name = name;&lt;br /&gt;
  }&lt;br /&gt;
  public Date getStartDate() {&lt;br /&gt;
    return startDate;&lt;br /&gt;
  }&lt;br /&gt;
  public void setStartDate(Date startDate) {&lt;br /&gt;
    this.startDate = startDate;&lt;br /&gt;
  }&lt;br /&gt;
  public String toString() {&lt;br /&gt;
    return &amp;quot;Employee id: &amp;quot; + getId() + &amp;quot; name: &amp;quot; + getName();&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
@MappedSuperclass&lt;br /&gt;
abstract class AbstractEmployee extends Employee {&lt;br /&gt;
  private int vacation;&lt;br /&gt;
  public int getVacation() {&lt;br /&gt;
    return vacation;&lt;br /&gt;
  }&lt;br /&gt;
  public void setVacation(int vacation) {&lt;br /&gt;
    this.vacation = vacation;&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
@Entity&lt;br /&gt;
@DiscriminatorValue(&amp;quot;FTEmp&amp;quot;)&lt;br /&gt;
class FullTimeEmployee extends AbstractEmployee {&lt;br /&gt;
  private long salary;&lt;br /&gt;
  private long pension;&lt;br /&gt;
  public long getPension() {&lt;br /&gt;
    return pension;&lt;br /&gt;
  }&lt;br /&gt;
  public void setPension(long pension) {&lt;br /&gt;
    this.pension = pension;&lt;br /&gt;
  }&lt;br /&gt;
  public long getSalary() {&lt;br /&gt;
    return salary;&lt;br /&gt;
  }&lt;br /&gt;
  public void setSalary(long salary) {&lt;br /&gt;
    this.salary = salary;&lt;br /&gt;
  }&lt;br /&gt;
  public String toString() {&lt;br /&gt;
    return &amp;quot;FullTimeEmployee id: &amp;quot; + getId() + &amp;quot; name: &amp;quot; + getName();&lt;br /&gt;
  }&lt;br /&gt;
}&lt;br /&gt;
@Entity(name = &amp;quot;PTEmp&amp;quot;)&lt;br /&gt;
@DiscriminatorValue(&amp;quot;PTEmp&amp;quot;)&lt;br /&gt;
class PartTimeEmployee extends AbstractEmployee {&lt;br /&gt;
  @Column(name = &amp;quot;H_RATE&amp;quot;)&lt;br /&gt;
  private float hourlyRate;&lt;br /&gt;
  public float getHourlyRate() {&lt;br /&gt;
    return hourlyRate;&lt;br /&gt;
  }&lt;br /&gt;
  public void setHourlyRate(float hourlyRate) {&lt;br /&gt;
    this.hourlyRate = hourlyRate;&lt;br /&gt;
  }&lt;br /&gt;
  public String toString() {&lt;br /&gt;
    return &amp;quot;PartTimeEmployee id: &amp;quot; + getId() + &amp;quot; name: &amp;quot; + getName();&lt;br /&gt;
  }&lt;br /&gt;
}&amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- end source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==  Mark Byte Array Field As Lob ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;p&amp;gt;File: Student.java&amp;lt;/p&amp;gt;&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;java&amp;quot;&amp;gt;&lt;br /&gt;
import javax.persistence.Basic;&lt;br /&gt;
import javax.persistence.Column;&lt;br /&gt;
import javax.persistence.Entity;&lt;br /&gt;
import javax.persistence.FetchType;&lt;br /&gt;
import javax.persistence.Id;&lt;br /&gt;
import javax.persistence.Lob;&lt;br /&gt;
@Entity&lt;br /&gt;
public class Student {&lt;br /&gt;
  @Id&lt;br /&gt;
  private int id = 0;&lt;br /&gt;
  private String name;&lt;br /&gt;
  @Basic(fetch = FetchType.LAZY)&lt;br /&gt;
  @Lob&lt;br /&gt;
  private byte[] picture;&lt;br /&gt;
  public int getId() {&lt;br /&gt;
    return id;&lt;br /&gt;
  }&lt;br /&gt;
  public void setId(int id) {&lt;br /&gt;
    this.id = id;&lt;br /&gt;
  }&lt;br /&gt;
  public String getName() {&lt;br /&gt;
    return name;&lt;br /&gt;
  }&lt;br /&gt;
  public void setName(String name) {&lt;br /&gt;
    this.name = name;&lt;br /&gt;
  }&lt;br /&gt;
  public byte[] getPicture() {&lt;br /&gt;
    return picture;&lt;br /&gt;
  }&lt;br /&gt;
  public void setPicture(byte[] picture) {&lt;br /&gt;
    this.picture = picture;&lt;br /&gt;
  }&lt;br /&gt;
  public String toString() {&lt;br /&gt;
    return &amp;quot;\n\nID:&amp;quot; + id + &amp;quot;\nName:&amp;quot; + name + &amp;quot;\n\n&amp;quot;;&lt;br /&gt;
  }&lt;br /&gt;
}&amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- end source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==  Mark String As Lob ==&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;lt;p&amp;gt;File: Student.java&amp;lt;/p&amp;gt;&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- start source code --&amp;gt;&lt;br /&gt;
   &lt;br /&gt;
    &amp;lt;source lang=&amp;quot;java&amp;quot;&amp;gt;&lt;br /&gt;
import javax.persistence.Basic;&lt;br /&gt;
import javax.persistence.Column;&lt;br /&gt;
import javax.persistence.Entity;&lt;br /&gt;
import javax.persistence.FetchType;&lt;br /&gt;
import javax.persistence.Id;&lt;br /&gt;
import javax.persistence.Lob;&lt;br /&gt;
@Entity&lt;br /&gt;
public class Student {&lt;br /&gt;
  @Id&lt;br /&gt;
  private int id = 0;&lt;br /&gt;
  @Lob&lt;br /&gt;
  private String name;&lt;br /&gt;
&lt;br /&gt;
  &lt;br /&gt;
  public int getId() {&lt;br /&gt;
    return id;&lt;br /&gt;
  }&lt;br /&gt;
  public void setId(int id) {&lt;br /&gt;
    this.id = id;&lt;br /&gt;
  }&lt;br /&gt;
  public String getName() {&lt;br /&gt;
    return name;&lt;br /&gt;
  }&lt;br /&gt;
  public void setName(String name) {&lt;br /&gt;
    this.name = name;&lt;br /&gt;
  }&lt;br /&gt;
&lt;br /&gt;
  public String toString() {&lt;br /&gt;
    return &amp;quot;\n\nID:&amp;quot; + id + &amp;quot;\nName:&amp;quot; + name + &amp;quot;\n\n&amp;quot;;&lt;br /&gt;
  }&lt;br /&gt;
}&amp;lt;/source&amp;gt;&lt;br /&gt;
    &lt;br /&gt;
   &lt;br /&gt;
  &amp;lt;!-- end source code --&amp;gt;&lt;/div&gt;</summary>
			</entry>

	</feed>