61. Hibernate

import java.util.Date;

public class Personnes {

  private Integer idPersonne;
  private String nomPersonne;
  private String prenomPersonne;
  private Date datenaissPersonne;

  public Personnes(String nomPersonne, String prenomPersonne, Date datenaissPersonne) {
    this.nomPersonne = nomPersonne;
    this.prenomPersonne = prenomPersonne;
    this.datenaissPersonne = datenaissPersonne;
  }

  public Personnes() {
  }

  public Date getDatenaissPersonne() {
    return datenaissPersonne;
  }

  public Integer getIdPersonne() {
    return idPersonne;
  }

  public String getNomPersonne() {
    return nomPersonne;
  }

  public String getPrenomPersonne() {
    return prenomPersonne;
  }

  public void setDatenaissPersonne(Date date) {
    datenaissPersonne = date;
  }

  public void setIdPersonne(Integer integer) {
    idPersonne = integer;
  }

  public void setNomPersonne(String string) {
    nomPersonne = string;
  }

  public void setPrenomPersonne(String string) {
    prenomPersonne = string;
  }

}

<?xml version="1.0"?>
  <!DOCTYPE hibernate-mapping
    PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<?xml version="1.0"?><!DOCTYPE hibernate-mapping
  PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
  "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd"><hibernate-mapping>
  <class name="Personnes" table="personnes">
    <id name="idPersonne" type="int" column="idpersonne">
      <generator class="native"/>
    </id>
    <property name="nomPersonne" type="string" not-null="true" />
    <property name="prenomPersonne" type="string" not-null="true" />
    <property name="datenaissPersonne" type="date">
      <meta attribute="field-description">date de naissance</meta>
    </property>
  </class>
</hibernate-mapping>

hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.connection.url=jdbc:mysql://localhost/testDB
hibernate.connection.username=root
hibernate.connection.password=

<?xml version='1.0' encoding='utf-8'?> 
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 2.0//EN"
  "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
  <session-factory>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost/testDB</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.connection.password"></property>
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="show_sql">true</property>
    <mapping resource="Personnes.hbm.xml"/>
  </session-factory>
</hibernate-configuration>

import org.hibernate.*;
import org.hibernate.cfg.Configuration;
import java.util.Date;

public class TestHibernate1 {
  
  public static void main(String args[]) throws Exception {
    Configuration config = new Configuration();
    config.addClass(Personnes.class);
    SessionFactory sessionFactory = config.buildSessionFactory();
    Session session = sessionFactory.openSession();
...

import org.hibernate.*; 
import org.hibernate.cfg.Configuration; 
import java.util.*; 

public class TestHibernate1 { 
  public static void main(String args[]) throws Exception { 
    SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory(); 
...

import org.hibernate.*;
import org.hibernate.cfg.Configuration;
import java.util.Date;

public class TestHibernate1 {
  
  public static void main(String args[]) throws Exception {
    Configuration config = new Configuration();
    config.addClass(Personnes.class);
    SessionFactory sessionFactory = config.buildSessionFactory();
    Session session = sessionFactory.openSession(); 

    Transaction tx = null; 
    try { 
      tx = session.beginTransaction(); 
      Personnes personne = new Personnes("nom3", "prenom3", new Date());
      session.save(personne);
      session.flush() ;
      tx.commit();
    } catch (Exception e) {
      if (tx != null) {
        tx.rollback();
      }
      throw e;
    } finally { 
      session.close(); 
    } 
    
    sessionFactory.close(); 
  } 
}

C:\java\test\testhibernate>ant TestHibernate1
Buildfile: build.xml
init:
[copy] Copying 1 file to C:\java\test\testhibernate\bin
compile:
TestHibernate1:
[java] 12:41:37,402 INFO Environment:462 - Hibernate 2.1.2
[java] 12:41:37,422 INFO Environment:496 - loaded properties from resource
hibernate.properties: {hibernate.connection.username=root, hibernate.connection
.password=, hibernate.cglib.use_reflection_optimizer=true, hibernate.dialect=net
.sf.hibernate.dialect.MySQLDialect, hibernate.connection.url=jdbc:mysql://localh
ost/testDB, hibernate.connection.driver_class=com.mysql.jdbc.Driver}
[java] 12:41:37,432 INFO Environment:519 - using CGLIB reflection optimizer
[java] 12:41:37,502 INFO Configuration:329 - Mapping resource: Personnes.hbm.xml
[java] 12:41:38,784 INFO Binder:229 - Mapping class: Personnes -> personnes
[java] 12:41:38,984 INFO Configuration:595 - processing one-to-many association mappings
[java] 12:41:38,994 INFO Configuration:604 - processing one-to-one association property 
references
[java] 12:41:38,994 INFO Configuration:629 - processing foreign key constraints
[java] 12:41:39,074 INFO Dialect:82 - Using dialect: org.hibernate.dialect.MySQLDialect
[java] 12:41:39,084 INFO SettingsFactory:62 - Use outer join fetching: true
[java] 12:41:39,104 INFO DriverManagerConnectionProvider:41 - Using Hibernate 
built-in connection pool (not for production use!)
[java] 12:41:39,114 INFO DriverManagerConnectionProvider:42 - Hibernate co
nnection pool size: 20
[java] 12:41:39,144 INFO DriverManagerConnectionProvider:71 - using driver
: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/testDB
[java] 12:41:39,154 INFO DriverManagerConnectionProvider:72 - connection p
roperties: {user=root, password=}
[java] 12:41:39,185 INFO TransactionManagerLookupFactory:33 - No Transacti
onManagerLookup configured (in JTA environment, use of process level read-write
cache is not recommended)
[java] 12:41:39,625 INFO SettingsFactory:102 - Use scrollable result sets:true
[java] 12:41:39,635 INFO SettingsFactory:105 - Use JDBC3 getGeneratedKeys(): true
[java] 12:41:39,635 INFO SettingsFactory:108 - Optimize cache for minimal puts: false
[java] 12:41:39,635 INFO SettingsFactory:117 - Query language substitutions: {}
[java] 12:41:39,645 INFO SettingsFactory:128 - cache provider: org.ehcache.hibernate.
Provider
[java] 12:41:39,685 INFO Configuration:1080 - instantiating and configuring caches
[java] 12:41:39,946 INFO SessionFactoryImpl:119 - building session factory
[java] 12:41:41,237 INFO SessionFactoryObjectFactory:82 - no JNDI name configured
[java] 12:41:41,768 INFO SessionFactoryImpl:531 - closing
[java] 12:41:41,768 INFO DriverManagerConnectionProvider:137 - cleaning up
connection pool: jdbc:mysql://localhost/testDB
BUILD SUCCESSFUL
Total time: 7 seconds
C:\java\test\testhibernate>

import org.hibernate.*; 
import org.hibernate.cfg.Configuration; 

public class TestHibernate2 { 
  
  public static void main(String args[]) throws Exception { 
    Configuration config = new Configuration(); 
    config.addClass(Personnes.class); 
    SessionFactory sessionFactory = config.buildSessionFactory(); 
    Session session = sessionFactory.openSession(); 
    
    try { 
      Personnes personne = (Personnes) session.load(Personnes.class, new Integer(3)); 
      System.out.println("nom = " + personne.getNomPersonne()); 
    } finally { 
      session.close(); 
    } 
    
    sessionFactory.close(); 
  } 
} 

C:\java\test\testhibernate>ant TestHibernate2                        
Buildfile: build.xml                                                 
                                                                     
init:                                                                
                                                                     
compile:                                                             
    [javac] Compiling 1 source file to C:\java\test\testhibernate\bin
                                                                     
TestHibernate2:                                                      
     [java] nom = nom3                                               
                                                                     
BUILD SUCCESSFUL                                                     
Total time: 9 seconds

select avg(emp.salaire) from Employe as emp 

from Employe as emp where emp.salaire >= (select avg(Employe.salaire)

from Employe)

Session session;
Query query = session.createQuery("select pers.nom from Personne as pers");
List result = query.list();

import org.hibernate.*;
import org.hibernate.cfg.Configuration;
import java.util.*;

public class TestHibernate8 {
  
  public static void main(String args[]) throws Exception {
    SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
    Session session = sessionFactory.openSession();
    
    try {
      Query query = session.createQuery("from Personnes p where p.nomPersonne = :nom");
      query.setString("nom", "nom2");
      Iterator personnes = query.iterate();
      
      while (personnes.hasNext()) {
        Personnes personne = (Personnes) personnes.next();
        System.out.println("nom = " + personne.getNomPersonne());
      }
    } finally {
      session.close();
    }

    sessionFactory.close();
  }
}

C:\java\test\testhibernate>ant TestHibernate8
Buildfile: build.xml

init:
     [copy] Copying 1 file to C:\java\test\testhibernate\bin

compile:

TestHibernate8:
     [java] nom = nom2

BUILD SUCCESSFUL
Total time: 7 seconds

import org.hibernate.*; 
import org.hibernate.cfg.Configuration; 
import java.util.*; 

public class TestHibernate3 { 
  
  public static void main(String args[]) throws Exception { 
    Configuration config = new Configuration(); 
    config.addClass(Personnes.class); 
    SessionFactory sessionFactory = config.buildSessionFactory(); 
    Session session = sessionFactory.openSession(); 

    try { 
      List personnes = session.find("from Personnes"); 
      for (int i = 0; i < personnes.size(); i++) { 
        Personnes personne = (Personnes) personnes.get(i); 
        System.out.println("nom = " + personne.getNomPersonne()); 
      } 
    } finally { 
      session.close(); 
    } 
    sessionFactory.close(); 
  } 
}

C:\java\test\testhibernate>ant TestHibernate3
Buildfile: build.xml

init:

compile:
    [javac] Compiling 1 source file to C:\java\test\testhibernate\bin

TestHibernate3:
     [java] nom = nom1
     [java] nom = nom2
     [java] nom = nom3

BUILD SUCCESSFUL
Total time: 14 seconds

import org.hibernate.*; 
import org.hibernate.cfg.Configuration; 
import java.util.*; 

public class TestHibernate4 { 
 
  public static void main(String args[]) throws Exception { 
    Configuration config = new Configuration(); 
    config.addClass(Personnes.class); 
    SessionFactory sessionFactory = config.buildSessionFactory(); 
    Session session = sessionFactory.openSession(); 

    try { 
      List personnes = session.find("from Personnes p where p.nomPersonne=?",
        "nom1", Hibernate.STRING); 
      for (int i = 0; i < personnes.size(); i++) {  
        Personnes personne = (Personnes) personnes.get(i); 
        System.out.println("nom = " + personne.getNomPersonne()); 
      } 
    } finally { 
      session.close(); 
    } 
  
    sessionFactory.close(); 
  } 
}

C:\java\test\testhibernate>ant TestHibernate4
Buildfile: build.xml

init:

compile:
    [javac] Compiling 1 source file to C:\java\test\testhibernate\bin

TestHibernate4:
     [java] nom = nom1

BUILD SUCCESSFUL

import org.hibernate.*;
import org.hibernate.cfg.Configuration;
import java.util.*;

public class TestHibernate6 {
  
  public static void main(String args[]) throws Exception {
    Configuration config = new Configuration();
    config.addClass(Personnes.class);
    SessionFactory sessionFactory = config.buildSessionFactory();
    Session session = sessionFactory.openSession();

    try {
      Iterator personnes = session.iterate("from Personnes ");
      while (personnes.hasNext()) {
        Personnes personne = (Personnes) personnes.next();
        System.out.println("nom = " + personne.getNomPersonne());
      } 
    } finally {
      session.close();
    }
    
    sessionFactory.close();
  }
}

C:\java\test\testhibernate>ant TestHibernate6
Buildfile: build.xml

init:

compile:
    [javac] Compiling 1 source file to C:\java\test\testhibernate\bin

TestHibernate6:
     [java] nom = nom1
     [java] nom = nom2
     [java] nom = nom3

BUILD SUCCESSFUL

import org.hibernate.*;
import org.hibernate.cfg.Configuration;
import java.util.*;

public class TestHibernate5 {

  public static void main(String args[]) throws Exception {
    Configuration config = new Configuration();
    config.addClass(Personnes.class);
    SessionFactory sessionFactory = config.buildSessionFactory();
    Session session = sessionFactory.openSession();

    try {
      int compteur = ( (Integer) session.iterate(
        "select count(*) from Personnes").next() ).intValue();
      System.out.println("compteur = " + compteur);
    } finally {
      session.close();
    }
    
    sessionFactory.close();
  }
}

C:\java\test\testhibernate>ant TestHibernate5
Buildfile: build.xml

init:

compile:
    [javac] Compiling 1 source file to C:\java\test\testhibernate\bin

TestHibernate5:
     [java] compteur = 3

BUILD SUCCESSFUL

select * from Personne

      List personnes = session.createCriteria(Personne.class).list(); 

      Criteria criteria = session.createCriteria(Personne.class);
      Criterion critere = Restrictions.eq("id", 2l);
      criteria.add(critere);
      List personnes = criteria.list();

      System.out.println("nb personnes = " + personnes.size());
      Iterator it = personnes.iterator();
      while (it.hasNext()) {
        Personne personne = (Personne) it.next();
        System.out.println("Personne : " + personne);
      }

SELECT nom FROM Personne 

    List noms = session.createCriteria(Personne.class)
           .setProjection(Projections.property("nom"))
           .list();
     
    System.out.println("nb personnes = " + noms.size());
     
    Iterator it = noms.iterator();  
    while (it.hasNext()) { 
      String nom = (String) it.next();
      System.out.println("Personne : " + nom);
    }

  public List rechercher(Session session,
                                String nom,
                                String prenom,
                                Date dateDeb,
                                Date dateFin,
                                Integer taille) {
    Map<String, Object> parametres = new HashMap<String, Object>();
    boolean premiereClause = true;
    StringBuffer requeteBuffer = new StringBuffer("from Personne p ");

    if (nom != null) {
      requeteBuffer.append(premiereClause ? "where " : " and ");
      requeteBuffer.append("p.nom = :nom");
      parametres.put("nom", nom);
      premiereClause = false;
    }
    if (prenom != null) {
      requeteBuffer.append(premiereClause ? " where " : " and ");
      requeteBuffer.append("p.prenom = :prenom");
      parametres.put("prenom", prenom);
      premiereClause = false;
    }
    if (dateDeb != null) {
      requeteBuffer.append(premiereClause ? " where " : " and ");
      requeteBuffer.append("p.dateNais >= :dateDeb");
      parametres.put("dateDeb", dateDeb);
      premiereClause = false;
    }
    if (dateFin != null) {
      requeteBuffer.append(premiereClause ? " where " : " and ");
      requeteBuffer.append("p.dateNais <= :dateFin");
      parametres.put("endDate", dateFin);
      premiereClause = false;
    }
    if (taille != null) {
      requeteBuffer.append(premiereClause ? " where " : " and ");
      requeteBuffer.append("p.taille = :taille");
      parametres.put("taille", taille);
      premiereClause = false;
    }

    String requeteHql = requeteBuffer.toString();

    Query query = session.createQuery(requeteHql);

    Iterator<String> iter = parametres.keySet().iterator();
    while (iter.hasNext()) {
      String name = iter.next();
      Object value = parametres.get(name);
      query.setParameter(name, value);
    }

    return query.list();
  } 

  public List rechercher(Session session,
                                String nom,
                                String prenom,
                                Date dateDeb,
                                Date dateFin,
                                Integer taille) {
    Criteria criteria = session.createCriteria(Personne.class);
    if (dateDeb != null) {
      criteria.add(Restrictions.ge("dateNais", dateDeb));
    }
    if (dateFin != null) {
      criteria.add(Restrictions.le("dateNais", dateFin));
    }
    if (nom != null) {
      criteria.add(Restrictions.eq("nom", nom));
    }
    if (prenom != null) {
      criteria.add(Restrictions.eq("prenom", prenom));
    }
    if (taille != null) {
      criteria.add(Restrictions.eq("taille", taille));
    }
    List resultat = criteria.list();

    return resultat;

  } 

      Criteria criteria = session.createCriteria(Personne.class);
      criteria.setMaxResults(10);
      List personnes = criteria.list();

      List personnes = session.createCriteria(Personne.class)
                    .add(Restrictions.like("nom", "Dup%"))
                    .add(Restrictions.gt("taille", new Integer(180)))
                    .addOrder(Order.asc("age"))
                    .list();

      Calendar cal = Calendar.getInstance();
      cal.set(1980, Calendar.JANUARY, 01);
      Date dateDeb = cal.getTime();
      cal.set(1980, Calendar.DECEMBER, 31);
      Date dateFin = cal.getTime();
      personnes = session.createCriteria(Personne.class)
                         .add(Restrictions.ge("dateNais", dateDeb))
                         .add(Restrictions.le("dateNais", dateFin))
                         .addOrder(Order.asc("dateNais"))
                         .setFirstResult(0)
                         .setMaxResults(10)
                         .list();

SELECT * FROM Personne WHERE IdPers=1;

      List personnes = session.createCriteria(Personne.class)
                              .add(Restrictions.eq("id", 1l))
                              .list();

      List personnes = session.createCriteria(Personne.class)                    
                              .add(Restrictions.lt("dateNais", dateSaisie))
                              .list();

      List personnes = session.createCriteria(Personne.class)
                              .add(Restrictions.between("dateNais", dateDeb, dateFin))
                              .add(Restrictions.like("nom", "Dup%"))
                              .list();

      List personnes = session.createCriteria(Personne.class)
                              .add(Restrictions.eqProperty("nom", "prenom"))
                              .list();

      List personnes = session.createCriteria(Personne.class)
                              .add(Restrictions.or(Restrictions.eq("prenom", "Jean"),
                                   Restrictions.eq("prenom", "Paul")))
                              .list();

SELECT NOM, PRENOM FROM PERSONNE 

      List resultats = session.createCriteria(Personne.class)
                .setProjection(Projections.projectionList()
                               .add(Projections.property("nom"))
                               .add(Projections.property("prenom")))
                .list();

      System.out.println("nb personnes = " + resultats.size());
      Iterator it = resultats.iterator();
      while (it.hasNext()) {
        Object[] donnees = (Object[]) it.next();
        System.out.println("Nom : " + donnees[0] 
                         + " Prenom : " + donnees[1]);
      } 

      List resultats = session.createCriteria(Personne.class)
                              .setProjection(Projections.rowCount())
                              .list();
      Long valeur = (Long) resultats.get(0);
      System.out.println("nb personnes = " + valeur);

SELECT COUNT(ID) FROM PERSONNE GROUP BY TAILLE 

      List resultats = session.createCriteria(Personne.class)
                    .setProjection(Projections.projectionList()
                                              .add(Projections.count("id"))
                                              .add(Projections.groupProperty("taille")))
                    .list();

      Iterator it = resultats.iterator();
      while (it.hasNext()) {
        Object[] donnees = (Object[]) it.next();
        System.out.println("Nombre : " + donnees[0] + " taille : " + donnees[1]);
      } 

      List resultats = session.createCriteria(Personne.class)
        .add(Restrictions.between("dateNais",dateDeb,dateFin))
        .addOrder(Order.desc("dateNais"))
        .addOrder(Order.asc("nom"));

SELECT P.*, A.* FROM Personne P, Adresse A WHERE P.adresse_id=A.id
AND A.Nom = 'Dupond'; 

from Personne personne
where Personne.nom = :nom left join fetch personne.adresse 

package fr.jmdoudoux.dej.hibernate;
      
import java.util.Iterator;
import java.util.List;
import org.hibernate.FetchMode;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;

public class TestHibernateCriteria {

  public static void main(String args[]) {
    SessionFactory sessionFactory = new AnnotationConfiguration().configure()
                                                                 .buildSessionFactory();
    Transaction transaction = null;
    List personnes = null;
    Session session = sessionFactory.openSession();

    try {
      transaction = session.beginTransaction();
      personnes = session.createCriteria(Personne.class)
                         .setFetchMode("adresse", FetchMode.JOIN)
                         .list();
      System.out.println("nbpersonnes = " + personnes.size());

      Iterator it = personnes.iterator();
      while (it.hasNext()) {
        Personne personne = (Personne) it.next();
       
        System.out.println("Personne : " + personne);
        System.out.println("  Adresse : " + personne.getAdresse());
      }

      transaction.commit();
    } catch (Exception e) {
      transaction.rollback();
      e.printStackTrace();
    } finally {
      session.close();
    }
    sessionFactory.close();
  }
}

 from Personne p join p.adresse a where a.cp = '54000' 

package fr.jmdoudoux.dej.hibernate;
      
import java.util.Iterator;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.criterion.Restrictions;

public class TestHibernateCriteria {

  public static void main(String args[]) {
    SessionFactory sessionFactory = new AnnotationConfiguration().configure()
                                                                 .buildSessionFactory();
   
    Transaction transaction = null;
    List personnes = null;
   
    Session session = sessionFactory.openSession();
    try {
      transaction = session.beginTransaction();
      personnes = session.createCriteria(Personne.class)
                         .createCriteria("adresse", "a")
                         .add(Restrictions.eq("a.cp", "54700"))
                         .list();
     
      System.out.println("nb personnes = " + personnes.size());
     
      Iterator it = personnes.iterator();
      while (it.hasNext()) {
        Personne personne = (Personne) it.next();
        System.out.println("Personne : " + personne);
        System.out.println("  Adresse: " + personne.getAdresse());
      }
     
      transaction.commit();
    } catch (Exception e) {
      transaction.rollback();
      e.printStackTrace();
    } finally {
      session.close();
    }
   
    sessionFactory.close();
  }
}

      personnes = session.createCriteria(Personne.class)
                         .createAlias("adresse", "a")
                         .add(Restrictions.eq("a.cp", "54000"))
                         .list();

SELECT G.*, P.* FROM Personnes P, Groupe G WHERE G.IdGroup=P.IdGroup AND G.IdGroup=l;

      List groupes = session.createCriteria(Groupe.class) 
                            .setFetchMode("Personne",FetchMode.JOIN) 
                            .add(Restrictions.eq("IdGroup","1"))
                            .list();

      transaction = session.beginTransaction();
      Date dateDebut = new GregorianCalendar(1980, Calendar.JANUARY, 01).getTime();
      Date dateFin = new GregorianCalendar(1981, Calendar.JANUARY, 01).getTime();

      Personne personneExemple = new Personne();
      personneExemple.setNom("Dupond");
      personneExemple.setPrenom("Michel");
      Example example = Example.create(personneExemple).ignoreCase().excludeZeroes();
      List<Personne> resultats = session.createCriteria(Personne.class)
                                              .add(example)
                                              .add(Restrictions.between("dateNais",
                                                   dateDebut, dateFin)).list();
      System.out.println("nbpersonnes = " + personnes.size());
      
      Iterator it = personnes.iterator();
      while (it.hasNext()) {
        Personne personne = (Personne) it.next(); 
        System.out.println("Personne : " + personne);
        System.out.println("  Adresse : " + personne.getAdresse());
      }
      transaction.commit();

session.delete("from Personnes");

mysql> desc personne;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| Id         | int(11)      |      | PRI | NULL    | auto_increment |
| Nom        | varchar(255) |      |     |         |                |
| Prenom     | varchar(255) |      |     |         |                |
| DateNais   | date         | YES  |     | NULL    |                |
| ligne1_adr | varchar(80)  |      |     |         |                |
| ligne2_adr | varchar(80)  | YES  |     | NULL    |                |
| cp_adr     | varchar(5)   | YES  |     | NULL    |                |
| ville_adr  | varchar(80)  | YES  |     | NULL    |                |
| ligne3_adr | varchar(80)  | YES  |     | NULL    |                |
+------------+--------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)

CREATE TABLE `personne` (
  `Id` int(11) NOT NULL auto_increment,
  `Nom` varchar(255) NOT NULL default '',
  `Prenom` varchar(255) NOT NULL default '',
  `DateNais` date default NULL,
  `ligne1_adr` varchar(80) NOT NULL default '',
  `ligne2_adr` varchar(80) default NULL,
  `cp_adr` varchar(5) default NULL,
  `ville_adr` varchar(80) default NULL,
  `ligne3_adr` varchar(80) default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

package fr.jmdoudoux.dej.hibernate;

public class Personne {

  private Long id;
  private String nom;
  private String prenom;
  private String dateNais;
  private Adresse adresse;

  public Personne(String nom, String prenom, String dateNais, Adresse adresse) {
    this.nom = nom;
    this.prenom = prenom;
    this.dateNais = dateNais;
    this.adresse = adresse;
  }

  public Personne() {
  }

  public String getNom() {
    return nom;
  }

  public void setNom(String nom) {
    this.nom = nom;
  }

  public String getPrenom() {
    return prenom;
  }

  public void setPrenom(String prenom) {
    this.prenom = prenom;
  }

  public String getDateNais() {
    return dateNais;
  }

  public void setDateNais(String dateNais) {
    this.dateNais = dateNais;
  }

  public Long getId() {
    return id;
  }

  // Attention le setter est requis par Hibernate

  public void setId(Long id) {
    this.id = id;
  }

  public Adresse getAdresse() {
    return adresse;
  }

  public void setAdresse(Adresse adresse) {
    this.adresse = adresse;
  }

  @Override
  public String toString() {
    return this.id + " : " + this.nom + " " + this.prenom;
  }
}

package fr.jmdoudoux.dej.hibernate;

public class Adresse {

  private String ligne1;
  private String ligne2;
  private String cp;
  private String ville;
  private String ligne3;

  public Adresse(String ligne1, String ligne2, String cp, String ville, String ligne3) {
    super();
    this.ligne1 = ligne1;
    this.ligne2 = ligne2;
    this.cp = cp;
    this.ville = ville;
    this.ligne3 = ligne3;
  }

  public Adresse() {
  }

  //

  // getter et setter sur les champs de la classe

  //


}

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
  <class name="fr.jmdoudoux.dej.hibernate.Personne" table="Personne">
    <id name="id" column="id">
      <generator class="increment" />
    </id>
    <property name="nom" column="Nom" />
    <property name="prenom" column="Prenom" />
    <property name="dateNais" column="DateNais" />
    <component name="adresse" class="fr.jmdoudoux.dej.hibernate.Adresse">
      <property name="ligne1" column="ligne1_adr" />
      <property name="ligne2" column="ligne2_adr" />
      <property name="cp" column="cp_adr" />
      <property name="ville" column="ville_adr" />
      <property name="ligne3" column="ligne3_adr" />
    </component>
  </class>
</hibernate-mapping>

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
         
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <property name="connection.url">jdbc:mysql://localhost/mabdd</property>
    <property name="connection.username">root</property>
    <property name="connection.password"></property>
    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="transaction.factory_class">
org.hibernate.transaction.JDBCTransactionFactory</property>
    <property name="current_session_context_class">thread</property>
    <property name="hibernate.show_sql">true</property>
    <mapping resource="com/jmdoudoux/test/hibernate/Personne.hbm.xml"></mapping>
  </session-factory>
</hibernate-configuration>

package fr.jmdoudoux.dej.hibernate;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class TestHibernate15 {

  public static void main(String args[]) {
    SessionFactory sessionFactory = new Configuration().configure()
                                                    .buildSessionFactory();
 
    Transaction transaction = null;
    int index = 6;

    Session session = sessionFactory.openSession();

    try {
      transaction = session.beginTransaction();

      Adresse adresse = new Adresse("ligne1_" + index, "ligne2_" + index, "cp_"
          + index, "ville" + index, "ligne3_" + index);
      Personne personne = new Personne("nom" + index,
                                       "prenom_" + index,
                                       null,
                                       adresse);

      session.save(personne);
      transaction.commit();

      System.out.println("La nouvelle personne a ete enregistree");

    } catch (Exception e) {
      transaction.rollback();
      e.printStackTrace();
    } finally {
      session.close();
    }

    sessionFactory.close();
  }
}

mysql> select * from personne;
+----+------+----------+----------+------------+------------+--------+----------
-+------------+
| Id | Nom  | Prenom   | DateNais | ligne1_adr | ligne2_adr |
cp_adr | ville_adr
 | ligne3_adr |
+----+------+----------+----------+------------+------------+--------+----------
-+------------+
|  1 | nom6 | prenom_6 | NULL     | ligne1_6   | ligne2_6  
| cp_6   | ville6
 | ligne3_6   |
+----+------+----------+----------+------------+------------+--------+----------
-+------------+
1 row in set (0.00 sec)

package fr.jmdoudoux.dej.hibernate;

import javax.persistence.Column;
import javax.persistence.Embedded;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "personne")
public class Personne {

  @Id
  @GeneratedValue
  @Column(name = "Id")
  private Long id;

  @Column(name = "Nom")
  private String nom;

  @Column(name = "Prenom")
  private String prenom;

  @Column(name = "DateNais")
  private String dateNais;

  @Embedded
  private Adresse adresse;

  public Personne(String nom, String prenom, String dateNais, Adresse adresse) {
    this.nom = nom;
    this.prenom = prenom;
    this.dateNais = dateNais;
    this.adresse = adresse;
  }

  public Personne() {
  }

  public Long getId() {
    return id;
  }

  public Adresse getAdresse() {
    return adresse;
  }

  public void setAdresse(Adresse adresse) {
    this.adresse = adresse;
  }

  //

  // getter et setter sur les autres champs de la classe

  //


  @Override
  public String toString() {
    return this.id + " : " + this.nom + " " + this.prenom;
  }

}

package fr.jmdoudoux.dej.hibernate;

import javax.persistence.Column;
import javax.persistence.Embeddable;

@Embeddable
public class Adresse {

  @Column(name = "ligne1_adr", nullable = false)
  private String ligne1;

  @Column(name = "ligne2_adr")
  private String ligne2;

  @Column(name = "cp_adr")
  private String cp;

  @Column(name = "ville_adr")
  private String ville;

  @Column(name = "ligne3_adr")
  private String ligne3;

  public Adresse(String ligne1, String ligne2, String cp, String ville,
      String ligne3) {
    super();
    this.ligne1 = ligne1;
    this.ligne2 = ligne2;
    this.cp = cp;
    this.ville = ville;
    this.ligne3 = ligne3;
  }

  public Adresse() {
  }

  //

  // getter et setter sur les champs de la classe

  //


}

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <property name="connection.url">jdbc:mysql://localhost/mabdd</property>
    <property name="connection.username">root</property>
    <property name="connection.password"></property>
    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="transaction.factory_class">
org.hibernate.transaction.JDBCTransactionFactory</property>
    <property name="current_session_context_class">thread</property>
    <property name="hibernate.show_sql">true</property>
    <mapping class="fr.jmdoudoux.dej.hibernate.Personne"></mapping>
    <mapping class="fr.jmdoudoux.dej.hibernate.Adresse"></mapping>
  </session-factory>
</hibernate-configuration>

package fr.jmdoudoux.dej.hibernate;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;

public class TestHibernate16 {

  public static void main(String args[]) {
    SessionFactory sessionFactory = new AnnotationConfiguration().configure()
                                                                 .buildSessionFactory();
    Transaction transaction = null;
    int index = 7;

    Session session = sessionFactory.openSession();

    try {
      transaction = session.beginTransaction();

      Adresse adresse = new Adresse("ligne1_" + index, "ligne2_" + index, "cp_"
          + index, "ville" + index, "ligne3_" + index);
      Personne personne = new Personne("nom" + index,
                                       "prenom_" + index,
                                       null,
                                       adresse);

      session.save(personne);
      transaction.commit();

      System.out.println("La nouvelle personne a ete enregistree");

    } catch (Exception e) {
      transaction.rollback();
      e.printStackTrace();
    } finally {
      session.close();
    }

    sessionFactory.close();
  }
}

mysql> select * from personne;
+----+------+----------+----------+------------+------------+--------+----------
-+------------+
| Id | Nom  | Prenom   | DateNais | ligne1_adr | ligne2_adr | cp_adr | ville_adr
 | ligne3_adr |
+----+------+----------+----------+------------+------------+--------+----------
-+------------+
|  2 | nom7 | prenom_7 | NULL     | ligne1_7   | ligne2_7   | cp_7   | ville7
 | ligne3_7   |
+----+------+----------+----------+------------+------------+--------+----------
-+------------+
1 row in set (0.00 sec)

mysql> desc personne;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| Id       | bigint(20)   |      | PRI | NULL    | auto_increment |
| Nom      | varchar(255) |      |     |         |                |
| Prenom   | varchar(255) |      |     |         |                |
| DateNais | date         | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

CREATE TABLE `personne` (
  `Id` bigint(20) NOT NULL auto_increment,
  `Nom` varchar(255) NOT NULL default '',
  `Prenom` varchar(255) NOT NULL default '',
  `DateNais` date default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

mysql> desc adresse;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id         | bigint(20)  |      | PRI | 0       |       |
| ligne1_adr | varchar(80) |      |     |         |       |
| ligne2_adr | varchar(80) | YES  |     | NULL    |       |
| cp_adr     | varchar(5)  | YES  |     | NULL    |       |
| ville_adr  | varchar(80) | YES  |     | NULL    |       |
| ligne3_adr | varchar(80) | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
6 rows in set (0.11 sec)

CREATE TABLE `adresse` (
  `id` bigint(20) NOT NULL default '0',
  `ligne1_adr` varchar(80) NOT NULL default '',
  `ligne2_adr` varchar(80) default NULL,
  `cp_adr` varchar(5) default NULL,
  `ville_adr` varchar(80) default NULL,
  `ligne3_adr` varchar(80) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

package fr.jmdoudoux.dej.hibernate;

public class Adresse {

  private Long id;
  private String ligne1;
  private String ligne2;
  private String cp;
  private String ville;
  private String ligne3;

  private Personne personne;

  public Adresse(String ligne1, String ligne2, String cp, String ville,
      String ligne3) {
    super();
    this.ligne1 = ligne1;
    this.ligne2 = ligne2;
    this.cp = cp;
    this.ville = ville;
    this.ligne3 = ligne3;
  }

  public Adresse() {
  }

  public Long getId() {
    return id;
  }

  // setter requis par Hibernate

  public void setId(Long id) {
    this.id = id;
  }

  public Personne getPersonne() {
    return personne;
  }

  public void setPersonne(Personne personne) {
    this.personne = personne;
  }

  //

  // getter et setter sur les autres champs de la classe

  //


}

package fr.jmdoudoux.dej.hibernate;

public class Personne {

  private Long id;
  private String nom;
  private String prenom;
  private String dateNais;
  private Adresse adresse;

  public Personne(String nom, String prenom, String dateNais, Adresse adresse) {
    this.nom = nom;
    this.prenom = prenom;
    this.dateNais = dateNais;
    this.adresse = adresse;
  }

  public Personne() {
  }

  public Long getId() {
    return id;
  }

  // Attention le setter est requis par Hibernate

  public void setId(Long id) {
    this.id = id;
  }

  public Adresse getAdresse() {
    return adresse;
  }

  public void setAdresse(Adresse adresse) {
    this.adresse = adresse;
  }

  //

  // getter et setter sur les autres champs de la classe

  //


  @Override
  public String toString() {
    return this.id + " : " + this.nom + " " + this.prenom;
  }

}

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
  <class name="fr.jmdoudoux.dej.hibernate.Personne" table="Personne">
    <id name="id" column="id">
      <generator class="increment" />
    </id>
    <property name="nom" column="Nom" />
    <property name="prenom" column="Prenom" />
    <property name="dateNais" column="DateNais" />
    <one-to-one name="adresse" class="fr.jmdoudoux.dej.hibernate.Adresse" 
      cascade="save-update" />
  </class>
</hibernate-mapping>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
  <class name="fr.jmdoudoux.dej.hibernate.Adresse" table="Adresse">

    <id name="id" column="Id">
      <generator class="foreign">
        <param name="property">personne</param>
      </generator>
    </id>
    <property name="ligne1" column="ligne1_adr" />
    <property name="ligne2" column="ligne2_adr" />
    <property name="cp" column="cp_adr" />
    <property name="ville" column="ville_adr" />
    <property name="ligne3" column="ligne3_adr" />
    <one-to-one name="personne" class="fr.jmdoudoux.dej.hibernate.Personne"
      constrained="true" />
  </class>
</hibernate-mapping>

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
    <property name="connection.url">jdbc:mysql://localhost/mabdd</property>
    <property name="connection.username">root</property>
    <property name="connection.password"></property>
    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="transaction.factory_class">
org.hibernate.transaction.JDBCTransactionFactory</property>   
    <property name="current_session_context_class">thread</property>
    <property name="hibernate.show_sql">true</property>
    <mapping resource="com/jmdoudoux/test/hibernate/Personne.hbm.xml"></mapping>
    <mapping resource="com/jmdoudoux/test/hibernate/Adresse.hbm.xml"></mapping>

</session-factory>
</hibernate-configuration>

package fr.jmdoudoux.dej.hibernate;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class TestHibernate11 {

  public static void main(String args[]) {
    SessionFactory sessionFactory = new Configuration().configure()
                                                       .buildSessionFactory();
    Transaction transaction = null;
    int index = 3;

    Session session = sessionFactory.openSession();

    try {
      transaction = session.beginTransaction();

      Adresse adresse = new Adresse("ligne1_" + index, "ligne2_" + index, "cp_"
          + index, "ville" + index, "ligne3_" + index);
      Personne personne = new Personne("nom" + index,
                                       "prenom_" + index,
                                       null,
                                       adresse);
      adresse.setPersonne(personne);

      session.save(personne);
      transaction.commit();

      System.out.println("La nouvelle personne a ete enregistree");

    } catch (Exception e) {
      transaction.rollback();
      e.printStackTrace();
    } finally {
      session.close();
    }

    sessionFactory.close();
  }
}

mysql> select * from personne;
+----+------+----------+----------+
| Id | Nom  | Prenom   | DateNais |
+----+------+----------+----------+
|  1 | nom3 | prenom_3 | NULL     |
+----+------+----------+----------+
1 row in set (0.00 sec)

mysql> select * from adresse;
+----+------------+------------+--------+-----------+------------+
| id | ligne1_adr | ligne2_adr | cp_adr | ville_adr | ligne3_adr |
+----+------------+------------+--------+-----------+------------+
|  1 | ligne1_3   | ligne2_3   | cp_3   | ville3    | ligne3_3   |
+----+------------+------------+--------+-----------+------------+
1 row in set (0.00 sec)

package fr.jmdoudoux.dej.hibernate;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.OneToOne;
import javax.persistence.PrimaryKeyJoinColumn;
import javax.persistence.Table;

@Entity
@Table(name = "personne")
public class Personne {

  @Id
  @GeneratedValue
  @Column(name = "Id")
  private Long id;

  @Column(name = "Nom")
  private String nom;

  @Column(name = "Prenom")
  private String prenom;

  @Column(name = "DateNais")
  private String dateNais;

  @OneToOne(cascade = CascadeType.ALL)
  @PrimaryKeyJoinColumn
  private Adresse adresse;

  public Personne(String nom, String prenom, String dateNais, Adresse adresse) {
    this.nom = nom;
    this.prenom = prenom;
    this.dateNais = dateNais;
    this.adresse = adresse;
  }

  public Personne() {
  }

  public Long getId() {
    return id;
  }

  public Adresse getAdresse() {
    return adresse;
  }

  public void setAdresse(Adresse adresse) {
    this.adresse = adresse;
  }

  //

  // getter et setter sur les autres champs de la classe

  //


  @Override
  public String toString() {
    return this.id + " : " + this.nom + " " + this.prenom;
  }

}

package fr.jmdoudoux.dej.hibernate;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.OneToOne;
import javax.persistence.Table;

import org.hibernate.annotations.Parameter;

@Entity
@Table(name = "adresse")
public class Adresse {

  @Id
  @GeneratedValue(generator = "adresseGenerator")
  @org.hibernate.annotations.GenericGenerator(name = "adresseGenerator", 
    strategy = "foreign", parameters = @Parameter(name = "property", value = "personne"))
  @Column(name = "id")
  private Long id;

  @Column(name = "ligne1_adr", nullable = false)
  private String ligne1;

  @Column(name = "ligne2_adr")
  private String ligne2;

  @Column(name = "cp_adr")
  private String cp;

  @Column(name = "ville_adr")
  private String ville;

  @Column(name = "ligne3_adr")
  private String ligne3;

  @OneToOne(mappedBy = "adresse")
  private Personne personne;

  public Adresse(String ligne1, String ligne2, String cp, String ville,
      String ligne3) {
    super();
    this.ligne1 = ligne1;
    this.ligne2 = ligne2;
    this.cp = cp;
    this.ville = ville;
    this.ligne3 = ligne3;
  }

  public Adresse() {
  }

  public Long getId() {
    return id;
  }

  public Personne getPersonne() {
    return personne;
  }

  public void setPersonne(Personne personne) {
    this.personne = personne;
  }

  //

  // getter et setter sur les autres champs de la classe

  //


}

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
    <property name="connection.url">jdbc:mysql://localhost/mabdd</property>
    <property name="connection.username">root</property>
    <property name="connection.password"></property>
    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="transaction.factory_class">
org.hibernate.transaction.JDBCTransactionFactory</property> 
    <property name="current_session_context_class">thread</property>
    <property name="hibernate.show_sql">true</property>
    <mapping class="fr.jmdoudoux.dej.hibernate.Personne"></mapping>
    <mapping class="fr.jmdoudoux.dej.hibernate.Adresse"></mapping>

</session-factory>
</hibernate-configuration>

package fr.jmdoudoux.dej.hibernate;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;

public class TestHibernate10 {

  public static void main(String args[]) {
    SessionFactory sessionFactory = new AnnotationConfiguration().configure()
                                                                 .buildSessionFactory();
    Transaction transaction = null;
    int index = 2;

    Session session = sessionFactory.openSession();

    try {
      transaction = session.beginTransaction();

      Adresse adresse = new Adresse("ligne1_" + index, "ligne2_" + index, "cp_"
          + index, "ville" + index, "ligne3_" + index);
      Personne personne = new Personne("nom" + index,
                                       "prenom_" + index,
                                       null,
                                       adresse);
      adresse.setPersonne(personne);

      session.save(personne);
      transaction.commit();

      System.out.println("La nouvelle personne a ete enregistree");

    } catch (Exception e) {
      transaction.rollback();
      e.printStackTrace();
    } finally {
      session.close();
    }

    sessionFactory.close();
  }
}

mysql> select * from adresse;
+----+------------+------------+--------+-----------+------------+
| id | ligne1_adr | ligne2_adr | cp_adr | ville_adr | ligne3_adr |
+----+------------+------------+--------+-----------+------------+
|  3 | ligne1_1   | ligne2_1   | cp_1   | ville1    | ligne3_1   |
+----+------------+------------+--------+-----------+------------+
1 row in set (0.00 sec)

mysql> select * from personne;
+----+------+----------+----------+
| Id | Nom  | Prenom   | DateNais |
+----+------+----------+----------+
|  3 | nom1 | prenom_1 | NULL     |
+----+------+----------+----------+
1 row in set (0.00 sec)

mysql> desc personne;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| Id         | int(11)      |      | PRI | NULL    | auto_increment |
| Nom        | varchar(255) |      |     |         |                |
| Prenom     | varchar(255) |      |     |         |                |
| DateNais   | date         | YES  |     | NULL    |                |
| adresse_id | int(11)      |      |     | 0       |                |
+------------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

CREATE TABLE `personne` (
  `Id` int(11) NOT NULL auto_increment,
  `Nom` varchar(255) NOT NULL default '',
  `Prenom` varchar(255) NOT NULL default '',
  `DateNais` date default NULL,
  `adresse_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

mysql> desc adresse;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| id         | bigint(20)  |      | PRI | NULL    | auto_increment |
| ligne1_adr | varchar(80) |      |     |         |                |
| ligne2_adr | varchar(80) | YES  |     | NULL    |                |
| cp_adr     | varchar(5)  | YES  |     | NULL    |                |
| ville_adr  | varchar(80) | YES  |     | NULL    |                |
| ligne3_adr | varchar(80) | YES  |     | NULL    |                |
+------------+-------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)

CREATE TABLE `adresse` (
  `id` bigint(20) NOT NULL auto_increment,
  `ligne1_adr` varchar(80) NOT NULL default '',
  `ligne2_adr` varchar(80) default NULL,
  `cp_adr` varchar(5) default NULL,
  `ville_adr` varchar(80) default NULL,
  `ligne3_adr` varchar(80) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

package fr.jmdoudoux.dej.hibernate;

public class Personne {

  private Long id;
  private String nom;
  private String prenom;
  private String dateNais;
  private Adresse adresse;

  public Personne(String nom, String prenom, String dateNais, Adresse adresse) {
    this.nom = nom;
    this.prenom = prenom;
    this.dateNais = dateNais;
    this.adresse = adresse;
  }

  public Personne() {
  }

  public Long getId() {
    return id;
  }

  // Attention le setter est requis par Hibernate

  public void setId(Long id) {
    this.id = id;
  }

  public Adresse getAdresse() {
    return adresse;
  }

  public void setAdresse(Adresse adresse) {
    this.adresse = adresse;
  }

  //

  // getter et setter sur les autres champs de la classe

  //


  @Override
  public String toString() {
    return this.id + " : " + this.nom + " " + this.prenom;
  }

}

package fr.jmdoudoux.dej.hibernate;
public class Adresse {
  private Long id;
  private String ligne1;
  private String ligne2;
  private String cp;
  private String ville;
  private String ligne3;

  public Adresse(String ligne1, String ligne2, String cp, String ville, String ligne3) {
    super();
    this.ligne1 = ligne1;
    this.ligne2 = ligne2;
    this.cp = cp;
    this.ville = ville;
    this.ligne3 = ligne3;
  }
  
  public Adresse() {
  }
  
  public Long getId() {
    return id;
  }
  
  // setter requis par Hibernate

  public void setId(Long id) {
    this.id = id;
  }

  //

  // getter et setter sur les autres champs de la classe

  //


}

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
  <class name="fr.jmdoudoux.dej.hibernate.Personne" table="Personne">
    <id name="id" column="Id">
       <generator class="increment" />
    </id>
    <property name="nom" column="Nom" />
    <property name="prenom" column="Prenom" />
    <property name="dateNais" column="DateNais" />
    <many-to-one name="adresse" class="fr.jmdoudoux.dej.hibernate.Adresse"
        column="adresse_id" cascade="all" unique="true" />
  </class>
</hibernate-mapping>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
  <class name="fr.jmdoudoux.dej.hibernate.Adresse" table="Adresse">
    <id name="id">
      <generator class="increment" />
    </id>
    <property name="ligne1" column="ligne1_adr" />
    <property name="ligne2" column="ligne2_adr" />
    <property name="cp" column="cp_adr" />
    <property name="ville" column="ville_adr" />
    <property name="ligne3" column="ligne3_adr" />
  </class>
</hibernate-mapping>

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
    <property name="connection.url">jdbc:mysql://localhost/mabdd</property>
    <property name="connection.username">root</property>
    <property name="connection.password"></property>
    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="transaction.factory_class">
org.hibernate.transaction.JDBCTransactionFactory</property>
    <property name="current_session_context_class">thread</property>
    <property name="hibernate.show_sql">true</property>
    <mapping resource="com/jmdoudoux/test/hibernate/Personne.hbm.xml"></mapping>
    <mapping resource="com/jmdoudoux/test/hibernate/Adresse.hbm.xml"></mapping>

</session-factory>
</hibernate-configuration>

package fr.jmdoudoux.dej.hibernate;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class TestHibernate12 {

  public static void main(String args[]) {
    SessionFactory sessionFactory = new Configuration().configure()
                                                       .buildSessionFactory();
    Transaction transaction = null;
    int index = 4;

    Session session = sessionFactory.openSession();

    try {
      transaction = session.beginTransaction();

      Adresse adresse = new Adresse("ligne1_" + index, "ligne2_" + index, "cp_"
          + index, "ville" + index, "ligne3_" + index);
      Personne personne = new Personne("nom_" + index,
                                       "prenom_" + index,
                                       null,
                                       adresse);

      session.save(personne);
      transaction.commit();

      System.out.println("La nouvelle personne a ete enregistree");

    } catch (Exception e) {
      transaction.rollback();
      e.printStackTrace();
    } finally {
      session.close();
    }

    sessionFactory.close();
  }
}

mysql> select * from personne;
+----+-------+----------+----------+------------+
| Id | Nom   | Prenom   | DateNais | adresse_id |
+----+-------+----------+----------+------------+
|  1 | nom_4 | prenom_4 | NULL     |          8 |
+----+-------+----------+----------+------------+
1 row in set (0.82 sec)

mysql> select * from adresse;
+----+------------+------------+--------+-----------+------------+
| id | ligne1_adr | ligne2_adr | cp_adr | ville_adr | ligne3_adr |
+----+------------+------------+--------+-----------+------------+
|  8 | ligne1_4   | ligne2_4   | cp_4   | ville4    | ligne3_4   |
+----+------------+------------+--------+-----------+------------+
1 row in set (0.00 sec)

package fr.jmdoudoux.dej.hibernate;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.OneToOne;
import javax.persistence.Table;

@Entity
@Table(name = "personne")
public class Personne {

  @Id
  @GeneratedValue
  @Column(name = "Id")
  private Long id;

  @Column(name = "Nom")
  private String nom;

  @Column(name = "Prenom")
  private String prenom;

  @Column(name = "DateNais")
  private String dateNais;

  @OneToOne(cascade = CascadeType.ALL)
  @JoinColumn(name = "adresse_id")
  private Adresse adresse;

  public Personne(String nom, String prenom, String dateNais, Adresse adresse) {
    this.nom = nom;
    this.prenom = prenom;
    this.dateNais = dateNais;
    this.adresse = adresse;
  }

  public Personne() {
  }

  public Long getId() {
    return id;
  }

  public Adresse getAdresse() {
    return adresse;
  }

  public void setAdresse(Adresse adresse) {
    this.adresse = adresse;
  }

  //

  // getter et setter sur les autres champs de la classe

  //


  @Override
  public String toString() {
    return this.id + " : " + this.nom + " " + this.prenom;
  }
}

package fr.jmdoudoux.dej.hibernate;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "adresse")
public class Adresse {

  @Id
  @GeneratedValue
  @Column(name = "id")
  private Long id;

  @Column(name = "ligne1_adr", nullable = false)
  private String ligne1;

  @Column(name = "ligne2_adr")
  private String ligne2;

  @Column(name = "cp_adr")
  private String cp;

  @Column(name = "ville_adr")
  private String ville;

  @Column(name = "ligne3_adr")
  private String ligne3;

  public Adresse(String ligne1, String ligne2, String cp, String ville,
      String ligne3) {
    super();
    this.ligne1 = ligne1;
    this.ligne2 = ligne2;
    this.cp = cp;
    this.ville = ville;
    this.ligne3 = ligne3;
  }

  public Adresse() {
  }

  public Long getId() {
    return id;
  }

  //

  // getter et setter sur les autres champs de la classe

  //


}

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
    <property name="connection.url">jdbc:mysql://localhost/mabdd</property>
    <property name="connection.username">root</property>
    <property name="connection.password"></property>
    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="transaction.factory_class">
org.hibernate.transaction.JDBCTransactionFactory</property>   
    <property name="current_session_context_class">thread</property>
    <property name="hibernate.show_sql">true</property>
    <mapping class="fr.jmdoudoux.dej.hibernate.Personne"></mapping>
    <mapping class="fr.jmdoudoux.dej.hibernate.Adresse"></mapping>

</session-factory>
</hibernate-configuration>

package fr.jmdoudoux.dej.hibernate;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;

public class TestHibernate14 {

  public static void main(String args[]) {
    SessionFactory sessionFactory = new AnnotationConfiguration().configure()
                                                                 .buildSessionFactory();
    Transaction transaction = null;
    int index = 5;

    Session session = sessionFactory.openSession();

    try {
      transaction = session.beginTransaction();

      Adresse adresse = new Adresse("ligne1_" + index, "ligne2_" + index, "cp_"
          + index, "ville" + index, "ligne3_" + index);
      Personne personne = new Personne("nom" + index,
                                       "prenom_" + index,
                                       null,
                                       adresse);
      session.save(personne);
      transaction.commit();

      System.out.println("La nouvelle personne a ete enregistree");

    } catch (Exception e) {
      transaction.rollback();
      e.printStackTrace();
    } finally {
      session.close();
    }

    sessionFactory.close();
  }
}

mysql> select * from adresse;
+----+------------+------------+--------+-----------+------------+
| id | ligne1_adr | ligne2_adr | cp_adr | ville_adr | ligne3_adr |
+----+------------+------------+--------+-----------+------------+
| 10 | ligne1_5   | ligne2_5   | cp_5   | ville5    | ligne3_5   |
+----+------------+------------+--------+-----------+------------+
1 row in set (0.00 sec)

mysql> select * from personne;
+----+-------+----------+----------+------------+
| Id | Nom   | Prenom   | DateNais | adresse_id |
+----+-------+----------+----------+------------+
|  8 | nom5  | prenom_5 | NULL     |         10 |
+----+-------+----------+----------+------------+
1 row in set (0.00 sec)

package fr.jmdoudoux.dej.hibernate;
      
import java.math.BigDecimal;
import java.util.List; 
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
import fr.jmdoudoux.dej.hibernate.entity.Compte;
import fr.jmdoudoux.dej.hibernate.entity.CompteCourant;
import fr.jmdoudoux.dej.hibernate.entity.CompteEpargne;

public class TestHibernate {

  private static SessionFactory sessionFactory = null;

  public static void main(String[] args) {
    try {
      Configuration hibernateConfig = new Configuration().configure();
      ServiceRegistry serviceRegistry = new ServiceRegistryBuilder()
          .applySettings(hibernateConfig.getProperties())
          .buildServiceRegistry();
      sessionFactory = hibernateConfig.buildSessionFactory(serviceRegistry);
      creerComptes();
      rechercherChaqueCompte();
      rechercherTousLesComptes();
      rechercheComptesPolymorphiques();
    } catch (Throwable ex) {
      ex.printStackTrace();
    } finally {
      sessionFactory.close();
    }
  }
  
  public static Transaction creerComptes() {
    Session session = sessionFactory.openSession();
    Transaction tx = null;
    try {
      Compte compte = new Compte();
      compte.setNumero("000012345000");
      compte.setSolde(BigDecimal.ZERO);
      CompteCourant compteCourant = new CompteCourant();
      compteCourant.setNumero("000012345010");
      compteCourant.setSolde(new BigDecimal("1200"));
      compteCourant.setDecouvert(2000);
      CompteEpargne compteEpargne = new CompteEpargne();
      compteEpargne.setNumero("000012345020");
      compteEpargne.setSolde(new BigDecimal(8000));
      compteEpargne.setTaux(new BigDecimal("2.10"));
      
      tx = session.beginTransaction();
      session.save(compte);
      session.save(compteCourant);
      session.save(compteEpargne);
      tx.commit();
    } catch (RuntimeException e) {
      try {
        tx.rollback();
      } catch (RuntimeException rbe) {
        rbe.printStackTrace();
      }
      throw e;
    } finally {
      if (session != null)
        session.close();
    }
    return tx;
  }
  
  public static void rechercherChaqueCompte() {
    Session session = sessionFactory.openSession();
    Transaction tx = null;
    try {
      tx = session.beginTransaction();
      System.out.println("Recherche d'un compte");
      Compte compte = (Compte) session.load(Compte.class, new Integer(1));
      System.out.println(compte);
      System.out.println();
      System.out.println("Recherche d'un compte courant");
      CompteCourant compteCourant = (CompteCourant) session.load(
          CompteCourant.class, new Integer(2));
      System.out.println(compteCourant);
      System.out.println();
      System.out.println("Recherche polymorphique d'un compte");
      compte = (Compte) session.load(Compte.class, new Integer(3));
      System.out.println(compte);
      System.out.println();
      tx.commit();
    } catch (RuntimeException e) {
      try {
        tx.rollback();
      } catch (RuntimeException rbe) {
        rbe.printStackTrace();
      }
      throw e;
    } finally {
      if (session != null)
        session.close();
    }
  }
  
  public static void rechercherTousLesComptes() {
    Session session = sessionFactory.openSession();
    Transaction tx = null;
    System.out.println("Recherche de tous les comptes");
    try {
      tx = session.beginTransaction();
      Query query = session.createQuery("from Compte");
      List<Compte> comptes = query.list();
      for (Compte compte : comptes) {
        System.out.println(compte);
      }
      System.out.println();
      tx.commit();
    } catch (RuntimeException e) {
      try {
        tx.rollback();
      } catch (RuntimeException rbe) {
        rbe.printStackTrace();
      }
      throw e;
    } finally {
      if (session != null)
        session.close();
    }
  }
  
  public static void rechercheComptesPolymorphiques() {
    Session session = sessionFactory.openSession();
    Transaction tx = null;
    System.out.println("Recherche polymorphique de comptes");
    try {
      tx = session.beginTransaction();
      Query query = session
          .createQuery("select c from Compte c where c.numero like :numero");
      query.setParameter("numero", "000012345%");
      List<Compte> comptes = query.list();
      for (Compte compte : comptes) {
        System.out.println(compte);
      }
      tx.commit();
    } catch (RuntimeException e) {
      try {
        tx.rollback();
      } catch (RuntimeException rbe) {
        rbe.printStackTrace();
      }
      throw e;
    } finally {
      if (session != null)
        session.close();
    }
    System.out.println();
  }
}

package fr.jmdoudoux.dej.hibernate.entity;

import java.math.BigDecimal;

public class Compte {
  protected int        id;
  protected String     numero;
  protected BigDecimal solde;
  
  public int getId() {
    return id;
  }
  
  public void setId(int id) {
    this.id = id;
  }
  
  public String getNumero() {
    return numero;
  }
  
  public void setNumero(String numero) {
    this.numero = numero;
  }
  
  public BigDecimal getSolde() {
    return solde;
  }
  
  public void setSolde(BigDecimal solde) {
    this.solde = solde;
  }
  
  @Override
  public String toString() {
    return super.toString() + " [id=" + id + ", numero=" + numero + ", solde="
        + solde + "]";
  }
} 

package fr.jmdoudoux.dej.hibernate.entity;
      
public class CompteCourant extends Compte {
  protected int decouvert;
  
  public int getDecouvert() {
    return decouvert;
  }
  
  public void setDecouvert(int decouvert) {
    this.decouvert = decouvert;
  }
  
  @Override
  public String toString() {
    return this.getClass().getName() + "@" + System.identityHashCode(this)
        + "CompteCourant [id=" + id + ", numero=" + numero + ", solde=" + solde
        + ", decouvert=" + decouvert + "]";
  }
}

package fr.jmdoudoux.dej.hibernate.entity;
      
import java.math.BigDecimal;

public class CompteEpargne extends Compte {
  protected BigDecimal taux;
  
  public BigDecimal getTaux() {
    return taux;
  }
  
  public void setTaux(BigDecimal taux) {
    this.taux = taux;
  }
  
  @Override
  public String toString() {
    return this.getClass().getName() + "@" + System.identityHashCode(this)
        + "CompteEpargne [ id=" + id + ", numero=" + numero + ", solde="
        + solde + ", taux=" + taux + "]";
  }
}

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration SYSTEM 
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <!-- Database connection settings -->
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3307/mabdd</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.connection.password">root</property>
    <property name="hibernate.connection.pool_size">1</property>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
    <property name="hibernate.current_session_context_class">thread</property>
    <!-- Cache de second niveau désactivé  -->
    <property name="hibernate.cache.provider_class">
      org.hibernate.cache.internal.NoCacheProvider</property>
    <!-- Afficher les requêtes SQL exécutées sur la sortie standard -->
    <property name="hibernate.show_sql">true</property>
    
    <property name="hbm2ddl.auto">create</property> 
    
    <mapping resource="Compte.hbm.xml"/>
  </session-factory>
</hibernate-configuration>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
 "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
  <class name="fr.jmdoudoux.dej.hibernate.entity.Compte"
    table="compte" discriminator-value="Compte">
    <id name="id" column="id" type="int" >
      <generator class="native" />
    </id>
    <discriminator column="DTYPE" type="string" />
        
    <property name="numero" column="numero" type="string" />
    <property name="solde" column="solde" type="big_decimal" />
    <subclass name="fr.jmdoudoux.dej.hibernate.entity.CompteCourant"
      discriminator-value="CompteCourant">
      <property name="decouvert" column="decouvert" type="int"/>
    </subclass>
    <subclass name="fr.jmdoudoux.dej.hibernate.entity.CompteEpargne"
      discriminator-value="CompteEpargne">
      <property name="taux" column="taux" type="big_decimal"/>
    </subclass>      
  </class>
</hibernate-mapping>

2015-02-23 23:18:53.650 INFO   [main]:org.hibernate.annotations.common.Version - HCANN000001: 
Hibernate Commons Annotations {4.0.1.Final}
2015-02-23 23:18:53.663 INFO   [main]:org.hibernate.Version - HHH000412: Hibernate Core {4.1.
4.Final}
2015-02-23 23:18:53.665 INFO   [main]:org.hibernate.cfg.Environment - HHH000206: hibernate.
properties not found
2015-02-23 23:18:53.666 INFO   [main]:org.hibernate.cfg.Environment - HHH000021: Bytecode 
provider name : javassist
2015-02-23 23:18:53.700 INFO   [main]:org.hibernate.cfg.Configuration - HHH000043: 
Configuring from resource: /hibernate.cfg.xml
2015-02-23 23:18:53.700 INFO   [main]:org.hibernate.cfg.Configuration - HHH000040: 
Configuration resource: /hibernate.cfg.xml
2015-02-23 23:18:53.753 INFO   [main]:org.hibernate.cfg.Configuration - HHH000221: Reading 
mappings from resource: Compte.hbm.xml
2015-02-23 23:18:53.823 INFO   [main]:org.hibernate.cfg.Configuration - HHH000041: Configured 
SessionFactory: null
2015-02-23 23:18:53.926 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000402: Using Hibernate built-in connection pool (not 
for production use!)
2015-02-23 23:18:53.941 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000115: Hibernate connection pool size: 1
2015-02-23 23:18:53.941 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000006: Autocommit mode: false
2015-02-23 23:18:53.942 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000401: using driver [com.mysql.jdbc.Driver] at URL [
jdbc:mysql://localhost:3307/mabdd]
2015-02-23 23:18:53.942 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000046: Connection properties: {user=root, password=
****}
2015-02-23 23:18:54.340 INFO   [main]:org.hibernate.dialect.Dialect - HHH000400: Using 
dialect: org.hibernate.dialect.MySQL5Dialect
2015-02-23 23:18:54.361 INFO   [main]:org.hibernate.engine.transaction.internal.
TransactionFactoryInitiator - HHH000399: Using default transaction strategy (direct JDBC 
transactions)
2015-02-23 23:18:54.366 INFO   [main]:org.hibernate.hql.internal.ast.
ASTQueryTranslatorFactory - HHH000397: Using ASTQueryTranslatorFactory
2015-02-23 23:18:54.617 INFO     [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000227: 
Running hbm2ddl schema export
Hibernate: drop table if exists compte
Hibernate: create table compte (id integer not null auto_increment, DTYPE varchar(255) not 
null, numero varchar(255), solde decimal(19,2), decouvert integer, taux decimal(19,2), primary 
key (id))
2015-02-23 23:18:54.707 INFO     [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000230: 
Schema export complete
Hibernate: insert into compte (numero, solde, DTYPE) values (?, ?, 'Compte')
Hibernate: insert into compte (numero, solde, decouvert, DTYPE) values (?, ?, ?, '
CompteCourant')
Hibernate: insert into compte (numero, solde, taux, DTYPE) values (?, ?, ?, 'CompteEpargne')
Recherche d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_.decouvert as decouvert0_0_, compte0_.taux as taux0_0_, compte0_.DTYPE as 
DTYPE0_0_ from compte compte0_ where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.Compte@3c3daf [id=1, numero=000012345000, solde=0.00]

Recherche d'un compte courant
Hibernate: select comptecour0_.id as id0_0_, comptecour0_.numero as numero0_0_, comptecour0_.
solde as solde0_0_, comptecour0_.decouvert as decouvert0_0_ from compte comptecour0_ where 
comptecour0_.id=? and comptecour0_.DTYPE='CompteCourant'
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@26380823CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]

Recherche polymorphique d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_.decouvert as decouvert0_0_, compte0_.taux as taux0_0_, compte0_.DTYPE as 
DTYPE0_0_ from compte compte0_ where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@641293CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

Recherche de tous les comptes
Hibernate: select compte0_.id as id0_, compte0_.numero as numero0_, compte0_.solde as solde0_, 
compte0_.decouvert as decouvert0_, compte0_.taux as taux0_, compte0_.DTYPE as DTYPE0_ from 
compte compte0_
fr.jmdoudoux.dej.hibernate.entity.Compte@1c458a5 [id=1, numero=000012345000, solde=0.00]
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@953079CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@12941261CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

Recherche polymorphique de comptes
Hibernate: select compte0_.id as id0_, compte0_.numero as numero0_, compte0_.solde as solde0_, 
compte0_.decouvert as decouvert0_, compte0_.taux as taux0_, compte0_.DTYPE as DTYPE0_ from 
compte compte0_ where compte0_.numero like ?
fr.jmdoudoux.dej.hibernate.entity.Compte@4cb73c [id=1, numero=000012345000, solde=0.00]
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@9557173CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@975425CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

mysql> select * from compte;
+----+---------------+--------------+---------+-----------+------+
| id | DTYPE         | numero       | solde   | decouvert | taux |
+----+---------------+--------------+---------+-----------+------+
|  1 | Compte        | 000012345000 |    0.00 |      NULL | NULL |
|  2 | CompteCourant | 000012345010 | 1200.00 |      2000 | NULL |
|  3 | CompteEpargne | 000012345020 | 8000.00 |      NULL | 2.10 |
+----+---------------+--------------+---------+-----------+------+
3 rows in set (0.00 sec)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
 "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="fr.jmdoudoux.dej.hibernate.entity.Compte" table="compte" >
        <id name="id" column="id" type="int" >
            <generator class="native" />
        </id>
        <property name="numero" column="numero" type="string" />
        <property name="solde" column="solde" type="big_decimal" />
        <joined-subclass name="fr.jmdoudoux.dej.hibernate.entity.CompteCourant" 
            table="compte_courant">
            <key column="id"/>
            <property name="decouvert" column="decouvert" type="int"/>
        </joined-subclass>
        <joined-subclass name="fr.jmdoudoux.dej.hibernate.entity.CompteEpargne"
            table="compte_epargne">
            <key column="id"/>
            <property name="taux" column="taux" type="big_decimal"/>
        </joined-subclass>      
    </class>
</hibernate-mapping>

2015-02-11 22:34:44.154 INFO   [main]:org.hibernate.annotations.common.Version - HCANN000001: 
Hibernate Commons Annotations {4.0.1.Final}
2015-02-11 22:34:44.172 INFO   [main]:org.hibernate.Version - HHH000412: Hibernate Core {4.1.
4.Final}
2015-02-11 22:34:44.174 INFO   [main]:org.hibernate.cfg.Environment - HHH000206: hibernate.
properties not found
2015-02-11 22:34:44.175 INFO   [main]:org.hibernate.cfg.Environment - HHH000021: Bytecode 
provider name : javassist
2015-02-11 22:34:44.211 INFO   [main]:org.hibernate.cfg.Configuration - HHH000043: 
Configuring from resource: /hibernate.cfg.xml
2015-02-11 22:34:44.211 INFO   [main]:org.hibernate.cfg.Configuration - HHH000040: 
Configuration resource: /hibernate.cfg.xml
2015-02-11 22:34:44.297 INFO   [main]:org.hibernate.cfg.Configuration - HHH000221: Reading 
mappings from resource: Compte.hbm.xml
2015-02-11 22:34:44.366 INFO   [main]:org.hibernate.cfg.Configuration - HHH000041: Configured 
SessionFactory: null
2015-02-11 22:34:44.475 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000402: Using Hibernate built-in connection pool (not 
for production use!)
2015-02-11 22:34:44.482 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000115: Hibernate connection pool size: 1
2015-02-11 22:34:44.483 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000006: Autocommit mode: false
2015-02-11 22:34:44.483 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000401: using driver [com.mysql.jdbc.Driver] at URL [
jdbc:mysql://localhost:3307/mabdd]
2015-02-11 22:34:44.485 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000046: Connection properties: {user=root, password=
****}
2015-02-11 22:34:44.842 INFO   [main]:org.hibernate.dialect.Dialect - HHH000400: Using 
dialect: org.hibernate.dialect.MySQL5Dialect
2015-02-11 22:34:44.870 INFO   [main]:org.hibernate.engine.transaction.internal.
TransactionFactoryInitiator - HHH000399: Using default transaction strategy (direct JDBC 
transactions)
2015-02-11 22:34:44.874 INFO   [main]:org.hibernate.hql.internal.ast.
ASTQueryTranslatorFactory - HHH000397: Using ASTQueryTranslatorFactory
2015-02-11 22:34:45.100 INFO   [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000227: 
Running hbm2ddl schema export
Hibernate: alter table compte_courant drop foreign key FK2435FDBF9CCD1BB4
2015-02-11 22:34:45.106 ERROR  [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000389: 
Unsuccessful: alter table compte_courant drop foreign key FK2435FDBF9CCD1BB4
2015-02-11 22:34:45.106 ERROR  [main]:org.hibernate.tool.hbm2ddl.SchemaExport - Table 'mabdd.
compte_courant' doesn't exist
Hibernate: alter table compte_epargne drop foreign key FK8E9D8D439CCD1BB4
2015-02-11 22:34:45.107 ERROR  [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000389: 
Unsuccessful: alter table compte_epargne drop foreign key FK8E9D8D439CCD1BB4
2015-02-11 22:34:45.107 ERROR  [main]:org.hibernate.tool.hbm2ddl.SchemaExport - Table 'mabdd.
compte_epargne' doesn't exist
Hibernate: drop table if exists compte
Hibernate: drop table if exists compte_courant
Hibernate: drop table if exists compte_epargne
Hibernate: create table compte (id integer not null auto_increment, numero varchar(255), solde 
decimal(19,2), primary key (id))
Hibernate: create table compte_courant (id integer not null, decouvert integer, primary key (
id))
Hibernate: create table compte_epargne (id integer not null, taux decimal(19,2), primary key (
id))
Hibernate: alter table compte_courant add index FK2435FDBF9CCD1BB4 (id), add constraint 
FK2435FDBF9CCD1BB4 foreign key (id) references compte (id)
Hibernate: alter table compte_epargne add index FK8E9D8D439CCD1BB4 (id), add constraint 
FK8E9D8D439CCD1BB4 foreign key (id) references compte (id)
2015-02-11 22:34:45.189 INFO     [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000230: 
Schema export complete
Hibernate: insert into compte (numero, solde) values (?, ?)
Hibernate: insert into compte (numero, solde) values (?, ?)
Hibernate: insert into compte_courant (decouvert, id) values (?, ?)
Hibernate: insert into compte (numero, solde) values (?, ?)
Hibernate: insert into compte_epargne (taux, id) values (?, ?)
Recherche d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_1_.decouvert as decouvert1_0_, compte0_2_.taux as taux2_0_, case when 
compte0_1_.id is not null then 1 when compte0_2_.id is not null then 2 when compte0_.id is not 
null then 0 end as clazz_0_ from compte compte0_ left outer join compte_courant compte0_1_ on 
compte0_.id=compte0_1_.id left outer join compte_epargne compte0_2_ on compte0_.id=compte0_2_.
id where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.Compte@e2ecb3 [id=1, numero=000012345000, solde=0.00]

Recherche d'un compte courant
Hibernate: select comptecour0_.id as id0_0_, comptecour0_1_.numero as numero0_0_, 
comptecour0_1_.solde as solde0_0_, comptecour0_.decouvert as decouvert1_0_ from compte_courant 
comptecour0_ inner join compte comptecour0_1_ on comptecour0_.id=comptecour0_1_.id where 
comptecour0_.id=?
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@1972965CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]

Recherche polymorphique d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_1_.decouvert as decouvert1_0_, compte0_2_.taux as taux2_0_, case when 
compte0_1_.id is not null then 1 when compte0_2_.id is not null then 2 when compte0_.id is not 
null then 0 end as clazz_0_ from compte compte0_ left outer join compte_courant compte0_1_ on 
compte0_.id=compte0_1_.id left outer join compte_epargne compte0_2_ on compte0_.id=compte0_2_.
id where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@32800355CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

Recherche de tous les comptes
Hibernate: select compte0_.id as id0_, compte0_.numero as numero0_, compte0_.solde as solde0_, 
compte0_1_.decouvert as decouvert1_, compte0_2_.taux as taux2_, case when compte0_1_.id is not 
null then 1 when compte0_2_.id is not null then 2 when compte0_.id is not null then 0 end as 
clazz_ from compte compte0_ left outer join compte_courant compte0_1_ on compte0_.id=
compte0_1_.id left outer join compte_epargne compte0_2_ on compte0_.id=compte0_2_.id
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@2473102CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@21374993CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]
fr.jmdoudoux.dej.hibernate.entity.Compte@f08a49 [id=1, numero=000012345000, solde=0.00]

Recherche polymorphique de comptes
Hibernate: select compte0_.id as id0_, compte0_.numero as numero0_, compte0_.solde as solde0_, 
compte0_1_.decouvert as decouvert1_, compte0_2_.taux as taux2_, case when compte0_1_.id is not 
null then 1 when compte0_2_.id is not null then 2 when compte0_.id is not null then 0 end as 
clazz_ from compte compte0_ left outer join compte_courant compte0_1_ on compte0_.id=
compte0_1_.id left outer join compte_epargne compte0_2_ on compte0_.id=compte0_2_.id where 
compte0_.numero like ?
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@5917204CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@28671960CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]
fr.jmdoudoux.dej.hibernate.entity.Compte@ad3eb5 [id=1, numero=000012345000, solde=0.00]

mysql> select * from compte;
+----+--------------+---------+
| id | numero       | solde   |
+----+--------------+---------+
|  1 | 000012345000 |    0.00 |
|  2 | 000012345010 | 1200.00 |
|  3 | 000012345020 | 8000.00 |
+----+--------------+---------+
3 rows in set (0.00 sec)
mysql> select * from compte_courant;
+----+-----------+
| id | decouvert |
+----+-----------+
|  2 |      2000 |
+----+-----------+
1 row in set (0.00 sec)
mysql> select * from compte_epargne;
+----+------+
| id | taux |
+----+------+
|  3 | 2.10 |
+----+------+
1 row in set (0.00 sec)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
 "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
  <class name="fr.jmdoudoux.dej.hibernate.entity.Compte"
    table="compte" >
    <id name="id" column="id" type="int" >
      <generator class="increment" />
    </id>
    <property name="numero" column="numero" type="string" />
    <property name="solde" column="solde" type="big_decimal" />
    <union-subclass name="fr.jmdoudoux.dej.hibernate.entity.CompteCourant"
      table="compte_courant">
      <property name="decouvert" column="decouvert" type="int"/>
    </union-subclass>
    <union-subclass name="fr.jmdoudoux.dej.hibernate.entity.CompteEpargne"
      table="compte_epargne">
      <property name="taux" column="taux" type="big_decimal"/>
    </union-subclass>      
  </class>
</hibernate-mapping>

2015-02-11 22:37:45.178 INFO   [main]:org.hibernate.annotations.common.Version - HCANN000001: 
Hibernate Commons Annotations {4.0.1.Final}
2015-02-11 22:37:45.194 INFO   [main]:org.hibernate.Version - HHH000412: Hibernate Core {4.1.
4.Final}
2015-02-11 22:37:45.194 INFO   [main]:org.hibernate.cfg.Environment - HHH000206: hibernate.
properties not found
2015-02-11 22:37:45.194 INFO   [main]:org.hibernate.cfg.Environment - HHH000021: Bytecode 
provider name : javassist
2015-02-11 22:37:45.225 INFO   [main]:org.hibernate.cfg.Configuration - HHH000043: 
Configuring from resource: /hibernate.cfg.xml
2015-02-11 22:37:45.225 INFO   [main]:org.hibernate.cfg.Configuration - HHH000040: 
Configuration resource: /hibernate.cfg.xml
2015-02-11 22:37:45.272 INFO   [main]:org.hibernate.cfg.Configuration - HHH000221: Reading 
mappings from resource: Compte.hbm.xml
2015-02-11 22:37:45.319 INFO   [main]:org.hibernate.cfg.Configuration - HHH000041: Configured 
SessionFactory: null
2015-02-11 22:37:45.443 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000402: Using Hibernate built-in connection pool (not 
for production use!)
2015-02-11 22:37:45.443 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000115: Hibernate connection pool size: 1
2015-02-11 22:37:45.443 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000006: Autocommit mode: false
2015-02-11 22:37:45.443 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000401: using driver [com.mysql.jdbc.Driver] at URL [
jdbc:mysql://localhost:3307/mabdd]
2015-02-11 22:37:45.459 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000046: Connection properties: {user=root, password=
****}
2015-02-11 22:37:45.787 INFO   [main]:org.hibernate.dialect.Dialect - HHH000400: Using 
dialect: org.hibernate.dialect.MySQL5Dialect
2015-02-11 22:37:45.803 INFO   [main]:org.hibernate.engine.transaction.internal.
TransactionFactoryInitiator - HHH000399: Using default transaction strategy (direct JDBC 
transactions)
2015-02-11 22:37:45.803 INFO   [main]:org.hibernate.hql.internal.ast.
ASTQueryTranslatorFactory - HHH000397: Using ASTQueryTranslatorFactory
2015-02-11 22:37:46.014 INFO   [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000227: 
Running hbm2ddl schema export
Hibernate: drop table if exists compte
Hibernate: drop table if exists compte_courant
Hibernate: drop table if exists compte_epargne
Hibernate: create table compte (id integer not null, numero varchar(255), solde decimal(19,2), 
primary key (id))
Hibernate: create table compte_courant (id integer not null, numero varchar(255), solde 
decimal(19,2), decouvert integer, primary key (id))
Hibernate: create table compte_epargne (id integer not null, numero varchar(255), solde 
decimal(19,2), taux decimal(19,2), primary key (id))
2015-02-11 22:37:46.046 INFO   [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000230: 
Schema export complete
Hibernate: select max(ids_.id) from ( select id from compte_courant union select id from 
compte union select id from compte_epargne ) ids_
Hibernate: insert into compte (numero, solde, id) values (?, ?, ?)
Hibernate: insert into compte_courant (numero, solde, decouvert, id) values (?, ?, ?, ?)
Hibernate: insert into compte_epargne (numero, solde, taux, id) values (?, ?, ?, ?)
Recherche d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_.decouvert as decouvert1_0_, compte0_.taux as taux2_0_, compte0_.clazz_ as 
clazz_0_ from ( select id, numero, solde, null as decouvert, null as taux, 0 as clazz_ from 
compte union select id, numero, solde, decouvert, null as taux, 1 as clazz_ from 
compte_courant union select id, numero, solde, null as decouvert, taux, 2 as clazz_ from 
compte_epargne ) compte0_ where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.Compte@2c5b4e [id=1, numero=000012345000, solde=0.00]

Recherche d'un compte courant
Hibernate: select comptecour0_.id as id0_0_, comptecour0_.numero as numero0_0_, comptecour0_.
solde as solde0_0_, comptecour0_.decouvert as decouvert1_0_ from compte_courant comptecour0_ 
where comptecour0_.id=?
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@21999623CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]

Recherche polymorphique d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_.decouvert as decouvert1_0_, compte0_.taux as taux2_0_, compte0_.clazz_ as 
clazz_0_ from ( select id, numero, solde, null as decouvert, null as taux, 0 as clazz_ from 
compte union select id, numero, solde, decouvert, null as taux, 1 as clazz_ from 
compte_courant union select id, numero, solde, null as decouvert, taux, 2 as clazz_ from 
compte_epargne ) compte0_ where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@7659203CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

Recherche de tous les comptes
Hibernate: select compte0_.id as id0_, compte0_.numero as numero0_, compte0_.solde as solde0_, 
compte0_.decouvert as decouvert1_, compte0_.taux as taux2_, compte0_.clazz_ as clazz_ from ( 
select id, numero, solde, null as decouvert, null as taux, 0 as clazz_ from compte union 
select id, numero, solde, decouvert, null as taux, 1 as clazz_ from compte_courant union 
select id, numero, solde, null as decouvert, taux, 2 as clazz_ from compte_epargne ) compte0_
fr.jmdoudoux.dej.hibernate.entity.Compte@12a81c9 [id=1, numero=000012345000, solde=0.00]
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@24930042CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@5027644CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

Recherche polymorphique de comptes
Hibernate: select compte0_.id as id0_, compte0_.numero as numero0_, compte0_.solde as solde0_, 
compte0_.decouvert as decouvert1_, compte0_.taux as taux2_, compte0_.clazz_ as clazz_ from ( 
select id, numero, solde, null as decouvert, null as taux, 0 as clazz_ from compte union 
select id, numero, solde, decouvert, null as taux, 1 as clazz_ from compte_courant union 
select id, numero, solde, null as decouvert, taux, 2 as clazz_ from compte_epargne ) compte0_ 
where compte0_.numero like ?
fr.jmdoudoux.dej.hibernate.entity.Compte@1a93ff1 [id=1, numero=000012345000, solde=0.00]
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@10814140CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@12935409CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

mysql> select * from compte;
+----+--------------+---------+
| id | numero       | solde   |
+----+--------------+---------+
|  1 | 000012345000 |    0.00 |
|  2 | 000012345010 | 1200.00 |
|  3 | 000012345020 | 8000.00 |
|  4 | 000012345000 |    0.00 |
+----+--------------+---------+
4 rows in set (0.00 sec)
mysql> select * from compte_courant;
+----+--------------+---------+-----------+
| id | numero       | solde   | decouvert |
+----+--------------+---------+-----------+
|  5 | 000012345010 | 1200.00 |      2000 |
+----+--------------+---------+-----------+
1 row in set (0.00 sec)
mysql> select * from compte_epargne;
+----+--------------+---------+------+
| id | numero       | solde   | taux |
+----+--------------+---------+------+
|  6 | 000012345020 | 8000.00 | 2.10 |
+----+--------------+---------+------+
1 row in set (0.00 sec)

       <id name="id" column="id" type="int" >
           <generator class="native"/>
        </id>

org.hibernate.MappingException: Cannot use identity column key generation with <union-subclass>
mapping for: fr.jmdoudoux.dej.hibernate.entity.CompteEpargne
  at org.hibernate.persister.entity.UnionSubclassEntityPersister.<init>(
  UnionSubclassEntityPersister.java:93)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:
  57)
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImp
  l.java:45)
  at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
  at org.hibernate.persister.internal.PersisterFactoryImpl.create(PersisterFactoryImpl.java:
  163)
  at org.hibernate.persister.internal.PersisterFactoryImpl.createEntityPersister(
  PersisterFactoryImpl.java:135)
  at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:386)
  at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1744)
  at fr.jmdoudoux.dej.hibernate.TestHibernate.main(TestHibernate.java:27)
Exception in thread "main" java.lang.NullPointerException
  at fr.jmdoudoux.dej.hibernate.TestHibernate.main(TestHibernate.java:54)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
 "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
  <class name="fr.jmdoudoux.dej.hibernate.entity.Compte"
    table="compte" discriminator-value="Compte">
    <id name="id" column="id" type="int" >
      <generator class="native" />
    </id>
    <discriminator column="DTYPE" type="string" />
        
    <property name="numero" column="numero" type="string" />
    <property name="solde" column="solde" type="big_decimal" />
    <subclass name="fr.jmdoudoux.dej.hibernate.entity.CompteCourant"
      discriminator-value="CompteCourant">
      <join table="compte_courant"> 
        <key column="compte_courant_id" />
        <property name="decouvert" column="decouvert" type="int"/>
      </join>
    </subclass>
    <subclass name="fr.jmdoudoux.dej.hibernate.entity.CompteEpargne"
      discriminator-value="CompteEpargne">
      <join table="compte_epargne"> 
        <key column="compte_epargne_id" />
        <property name="taux" column="taux" type="big_decimal"/>
      </join>
    </subclass>      
  </class>
</hibernate-mapping>

2015-02-03 21:59:56.856 INFO   [main]:org.hibernate.annotations.common.Version - HCANN000001: 
Hibernate Commons Annotations {4.0.1.Final}
2015-02-03 21:59:56.864 INFO   [main]:org.hibernate.Version - HHH000412: Hibernate Core {4.1.
4.Final}
2015-02-03 21:59:56.866 INFO   [main]:org.hibernate.cfg.Environment - HHH000206: hibernate.
properties not found
2015-02-03 21:59:56.868 INFO   [main]:org.hibernate.cfg.Environment - HHH000021: Bytecode 
provider name : javassist
2015-02-03 21:59:56.895 INFO   [main]:org.hibernate.cfg.Configuration - HHH000043: 
Configuring from resource: /hibernate.cfg.xml
2015-02-03 21:59:56.895 INFO   [main]:org.hibernate.cfg.Configuration - HHH000040: 
Configuration resource: /hibernate.cfg.xml
2015-02-03 21:59:56.943 INFO   [main]:org.hibernate.cfg.Configuration - HHH000221: Reading 
mappings from resource: Compte.hbm.xml
2015-02-03 21:59:57.000 INFO   [main]:org.hibernate.cfg.Configuration - HHH000041: Configured 
SessionFactory: null
2015-02-03 21:59:57.104 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000402: Using Hibernate built-in connection pool (not
for production use!)
2015-02-03 21:59:57.115 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000115: Hibernate connection pool size: 1
2015-02-03 21:59:57.116 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000006: Autocommit mode: false
2015-02-03 21:59:57.116 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000401: using driver [com.mysql.jdbc.Driver] at URL 
[jdbc:mysql://localhost:3307/mabdd]
2015-02-03 21:59:57.117 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000046: Connection properties: {user=root, password=
****}
2015-02-03 21:59:57.530 INFO   [main]:org.hibernate.dialect.Dialect - HHH000400: Using 
dialect: org.hibernate.dialect.MySQL5Dialect
2015-02-03 21:59:57.552 INFO   [main]:org.hibernate.engine.transaction.internal.
TransactionFactoryInitiator - HHH000399: Using default transaction strategy (direct JDBC 
transactions)
2015-02-03 21:59:57.557 INFO   [main]:org.hibernate.hql.internal.ast.
ASTQueryTranslatorFactory - HHH000397: Using ASTQueryTranslatorFactory
2015-02-03 21:59:57.897 INFO   [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000227: 
Running hbm2ddl schema export
Hibernate: alter table compte_courant drop foreign key FK2435FDBFBBF1A400
2015-02-03 21:59:57.915 ERROR  [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000389: 
Unsuccessful: alter table compte_courant drop foreign key FK2435FDBFBBF1A400
2015-02-03 21:59:57.915 ERROR  [main]:org.hibernate.tool.hbm2ddl.SchemaExport - Table 
'mabdd.compte_courant' doesn't exist
Hibernate: alter table compte_epargne drop foreign key FK8E9D8D438FCF4580
2015-02-03 21:59:57.917 ERROR  [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000389: 
Unsuccessful: alter table compte_epargne drop foreign key FK8E9D8D438FCF4580
2015-02-03 21:59:57.917 ERROR  [main]:org.hibernate.tool.hbm2ddl.SchemaExport - Table 'mabdd.
compte_epargne' doesn't exist
Hibernate: drop table if exists compte
Hibernate: drop table if exists compte_courant
Hibernate: drop table if exists compte_epargne
Hibernate: create table compte (id integer not null auto_increment, DTYPE varchar(255) not 
null, numero varchar(255), solde decimal(19,2), primary key (id))
Hibernate: create table compte_courant (compte_courant_id integer not null, decouvert integer
, primary key (compte_courant_id))
Hibernate: create table compte_epargne (compte_epargne_id integer not null, taux decimal(19,2)
, primary key (compte_epargne_id))
Hibernate: alter table compte_courant add index FK2435FDBFBBF1A400 (compte_courant_id), add 
constraint FK2435FDBFBBF1A400 foreign key (compte_courant_id) references compte (id)
Hibernate: alter table compte_epargne add index FK8E9D8D438FCF4580 (compte_epargne_id), add 
constraint FK8E9D8D438FCF4580 foreign key (compte_epargne_id) references compte (id)
2015-02-03 21:59:58.088 INFO     [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000230: 
Schema export complete
Hibernate: insert into compte (numero, solde, DTYPE) values (?, ?, 'Compte')
Hibernate: insert into compte (numero, solde, DTYPE) values (?, ?, 'CompteCourant')
Hibernate: insert into compte_courant (decouvert, compte_courant_id) values (?, ?)
Hibernate: insert into compte (numero, solde, DTYPE) values (?, ?, 'CompteEpargne')
Hibernate: insert into compte_epargne (taux, compte_epargne_id) values (?, ?)

CREATE TABLE `compte` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `DTYPE` varchar(255) NOT NULL,
  `numero` varchar(255) DEFAULT NULL,
  `solde` decimal(19,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

CREATE TABLE `compte_courant` (
  `compte_courant_id` int(11) NOT NULL,
  `decouvert` int(11) DEFAULT NULL,
  PRIMARY KEY (`compte_courant_id`),
  KEY `FK2435FDBFBBF1A400` (`compte_courant_id`),
  CONSTRAINT `FK2435FDBFBBF1A400` FOREIGN KEY (`compte_courant_id`) REFERENCES `compte` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `compte_epargne` (
  `compte_epargne_id` int(11) NOT NULL,
  `taux` decimal(19,2) DEFAULT NULL,
  PRIMARY KEY (`compte_epargne_id`),
  KEY `FK8E9D8D438FCF4580` (`compte_epargne_id`),
  CONSTRAINT `FK8E9D8D438FCF4580` FOREIGN KEY (`compte_epargne_id`) REFERENCES `compte` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

mysql> select * from compte;
+----+---------------+--------------+---------+
| id | DTYPE         | numero       | solde   |
+----+---------------+--------------+---------+
|  1 | Compte        | 000012345000 |    0.00 |
|  2 | CompteCourant | 000012345010 | 1200.00 |
|  3 | CompteEpargne | 000012345020 | 8000.00 |
+----+---------------+--------------+---------+
3 rows in set (0.00 sec)
mysql> select * from compte_courant;
+-------------------+-----------+
| compte_courant_id | decouvert |
+-------------------+-----------+
|                 2 |      2000 |
+-------------------+-----------+
1 row in set (0.00 sec)
mysql> select * from compte_epargne;
+-------------------+------+
| compte_epargne_id | taux |
+-------------------+------+
|                 3 | 2.10 |
+-------------------+------+
1 row in set (0.00 sec)

Recherche d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_1_.decouvert as decouvert1_0_, compte0_2_.taux as taux2_0_, compte0_.DTYPE 
as DTYPE0_0_ from compte compte0_ left outer join compte_courant compte0_1_ on compte0_.id=
compte0_1_.compte_courant_id left outer join compte_epargne compte0_2_ on compte0_.id=
compte0_2_.compte_epargne_id where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.Compte@422ddc [id=1, numero=000012345000, solde=0.00]

Recherche d'un compte courant
Hibernate: select comptecour0_.id as id0_0_, comptecour0_.numero as numero0_0_, comptecour0_.
solde as solde0_0_, comptecour0_1_.decouvert as decouvert1_0_ from compte comptecour0_ inner 
join compte_courant comptecour0_1_ on comptecour0_.id=comptecour0_1_.compte_courant_id where 
comptecour0_.id=? and comptecour0_.DTYPE='CompteCourant'
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@32800355CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]

Recherche polymorphique d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_1_.decouvert as decouvert1_0_, compte0_2_.taux as taux2_0_, compte0_.DTYPE 
as DTYPE0_0_ from compte compte0_ left outer join compte_courant compte0_1_ on compte0_.id=
compte0_1_.compte_courant_id left outer join compte_epargne compte0_2_ on compte0_.id=
compte0_2_.compte_epargne_id where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@29827422CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

Recherche polymorphique de comptes
Hibernate: select compte0_.id as id0_, compte0_.numero as numero0_, compte0_.solde as solde0_, 
compte0_1_.decouvert as decouvert1_, compte0_2_.taux as taux2_, compte0_.DTYPE as DTYPE0_ from 
compte compte0_ left outer join compte_courant compte0_1_ on compte0_.id=compte0_1_.
compte_courant_id left outer join compte_epargne compte0_2_ on compte0_.id=compte0_2_.
compte_epargne_id where compte0_.numero like ?
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@27737342CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@31801703CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]
fr.jmdoudoux.dej.hibernate.entity.Compte@28e5a7 [id=1, numero=000012345000, solde=0.00]

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
 "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
  <class name="fr.jmdoudoux.dej.hibernate.entity.Compte"
    table="compte" discriminator-value="Compte">
    <id name="id" column="id" type="int" >
      <generator class="native" />
    </id>
    <discriminator column="DTYPE" type="string" />
        
    <property name="numero" column="numero" type="string" />
    <property name="solde" column="solde" type="big_decimal" />
    <subclass name="fr.jmdoudoux.dej.hibernate.entity.CompteCourant"
      discriminator-value="CompteCourant">
      <join table="compte_courant" fetch="select">
         <key column="compte_courant_id" />
         <property name="decouvert" column="decouvert" type="int"/>
      </join>
    </subclass>
    <subclass name="fr.jmdoudoux.dej.hibernate.entity.CompteEpargne"
      discriminator-value="CompteEpargne">
      <join table="compte_epargne" fetch="select">
        <key column="compte_epargne_id" />
        <property name="taux" column="taux" type="big_decimal"/>
      </join>
    </subclass>      
  </class>
</hibernate-mapping>

Recherche d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_.DTYPE as DTYPE0_0_ from compte compte0_ where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.Compte@e15c54 [id=1, numero=000012345000, solde=0.00]

Recherche d'un compte courant
Hibernate: select comptecour0_.id as id0_0_, comptecour0_.numero as numero0_0_, comptecour0_.
solde as solde0_0_, comptecour0_1_.decouvert as decouvert1_0_ from compte comptecour0_ inner 
join compte_courant comptecour0_1_ on comptecour0_.id=comptecour0_1_.compte_courant_id where 
comptecour0_.id=? and comptecour0_.DTYPE='CompteCourant'
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@24177821CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]

Recherche polymorphique d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_.DTYPE as DTYPE0_0_ from compte compte0_ where compte0_.id=?
Hibernate: select compte_2_.taux as taux2_ from compte_epargne compte_2_ where compte_2_.
compte_epargne_id=?
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@11010466CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

Recherche polymorphique de comptes
Hibernate: select compte0_.id as id0_, compte0_.numero as numero0_, compte0_.solde as solde0_, 
compte0_.DTYPE as DTYPE0_ from compte compte0_ where compte0_.numero like ?
Hibernate: select compte_1_.decouvert as decouvert1_ from compte_courant compte_1_ where 
compte_1_.compte_courant_id=?
Hibernate: select compte_2_.taux as taux2_ from compte_epargne compte_2_ where compte_2_.
compte_epargne_id=?
fr.jmdoudoux.dej.hibernate.entity.Compte@476e01 [id=1, numero=000012345000, solde=0.00]
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@11305489CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@15939468CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration SYSTEM 
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <!-- Database connection settings -->
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3307/mabdd</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.connection.password">root</property>
    <property name="hibernate.connection.pool_size">1</property>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
    <property name="hibernate.current_session_context_class">thread</property>
    <!-- Cache de second niveau désactivé  -->
    <property name="hibernate.cache.provider_class">
      org.hibernate.cache.internal.NoCacheProvider</property>
    <!-- Afficher les requêtes SQL exécutées sur la sortie standard -->
    <property name="hibernate.show_sql">true</property>
    <property name="hbm2ddl.auto">create</property>
    <mapping class="fr.jmdoudoux.dej.hibernate.entity.Compte"/>
    <mapping class="fr.jmdoudoux.dej.hibernate.entity.CompteCourant"/>
    <mapping class="fr.jmdoudoux.dej.hibernate.entity.CompteEpargne"/>
  </session-factory>
</hibernate-configuration>

package fr.jmdoudoux.dej.hibernate.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;

@Entity
@Table(name = "compte_courant")
public class CompteCourant extends Compte {
  
  @Column(name = "decouvert")
  private int decouvert;
  
  public int getDecouvert() {
    return decouvert;
  }
  
  public void setDecouvert(int decouvert) {
    this.decouvert = decouvert;
  }
  
  @Override
  public String toString() {
    return this.getClass().getName() + "@" + System.identityHashCode(this)
        + "CompteCourant [id=" + id + ", numero=" + numero + ", solde=" + solde
        + ", decouvert=" + decouvert + "]";
  }
}

package fr.jmdoudoux.dej.hibernate.entity;
      
import java.math.BigDecimal;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;

@Entity
@Table(name = "compte_epargne")
public class CompteEpargne extends Compte {
  @Column(name = "taux")
  private BigDecimal taux;
  
  public BigDecimal getTaux() {
    return taux;
  }
  
  public void setTaux(BigDecimal taux) {
    this.taux = taux;
  }
  
  @Override
  public String toString() {
    return this.getClass().getName() + "@" + System.identityHashCode(this)
        + "CompteEpargne [ id=" + id + ", numero=" + numero + ", solde="
        + solde + ", taux=" + taux + "]";
  }
}

package fr.jmdoudoux.dej.hibernate.entity;
      
import java.math.BigDecimal;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Inheritance;
import javax.persistence.InheritanceType;
import javax.persistence.Table;

@Entity
@Table(name = "compte")
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
public class Compte {
  
  @Id
  @GeneratedValue(strategy = GenerationType.TABLE)
  @Column(name = "id")
  protected int        id;
  
  @Column(name = "numero")
  protected String     numero;
  
  @Column(name = "solde")
  protected BigDecimal solde;
  
  public int getId() {
    return id;
  }
  
  public void setId(int id) {
    this.id = id;
  }
  
  public String getNumero() {
    return numero;
  }
  
  public void setNumero(String numero) {
    this.numero = numero;
  }
  
  public BigDecimal getSolde() {
    return solde;
  }
  
  public void setSolde(BigDecimal solde) {
    this.solde = solde;
  }
  
  @Override
  public String toString() {
    return super.toString() + " [id=" + id + ", numero=" + numero + ", solde="
        + solde + "]";
  }
}

2015-03-03 23:00:59.778 INFO   [main]:org.hibernate.annotations.common.Version - HCANN000001: 
Hibernate Commons Annotations {4.0.1.Final}
2015-03-03 23:00:59.786 INFO   [main]:org.hibernate.Version - HHH000412: Hibernate Core {4.1.
4.Final}
2015-03-03 23:00:59.788 INFO   [main]:org.hibernate.cfg.Environment - HHH000206: hibernate.
properties not found
2015-03-03 23:00:59.790 INFO   [main]:org.hibernate.cfg.Environment - HHH000021: Bytecode 
provider name : javassist
2015-03-03 23:00:59.818 INFO   [main]:org.hibernate.cfg.Configuration - HHH000043: 
Configuring from resource: /hibernate.cfg.xml
2015-03-03 23:00:59.818 INFO   [main]:org.hibernate.cfg.Configuration - HHH000040: 
Configuration resource: /hibernate.cfg.xml
2015-03-03 23:00:59.874 INFO   [main]:org.hibernate.cfg.Configuration - HHH000041: Configured 
SessionFactory: null
2015-03-03 23:01:00.042 WARN   [main]:org.hibernate.cfg.AnnotationBinder - HHH000139: Illegal 
use of @Table in a subclass of a SINGLE_TABLE hierarchy: fr.jmdoudoux.dej.hibernate.entity.
CompteCourant
2015-03-03 23:01:00.043 WARN   [main]:org.hibernate.cfg.AnnotationBinder - HHH000139: Illegal 
use of @Table in a subclass of a SINGLE_TABLE hierarchy: fr.jmdoudoux.dej.hibernate.entity.
CompteEpargne
2015-03-03 23:01:00.056 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000402: Using Hibernate built-in connection pool (not 
for production use!)
2015-03-03 23:01:00.063 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000115: Hibernate connection pool size: 1
2015-03-03 23:01:00.063 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000006: Autocommit mode: false
2015-03-03 23:01:00.064 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000401: using driver [com.mysql.jdbc.Driver] at URL [
jdbc:mysql://localhost:3307/mabdd]
2015-03-03 23:01:00.064 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000046: Connection properties: {user=root, password=
****}
2015-03-03 23:01:00.367 INFO   [main]:org.hibernate.dialect.Dialect - HHH000400: Using 
dialect: org.hibernate.dialect.MySQL5Dialect
2015-03-03 23:01:00.397 INFO   [main]:org.hibernate.engine.transaction.internal.
TransactionFactoryInitiator - HHH000399: Using default transaction strategy (direct JDBC 
transactions)
2015-03-03 23:01:00.402 INFO   [main]:org.hibernate.hql.internal.ast.
ASTQueryTranslatorFactory - HHH000397: Using ASTQueryTranslatorFactory
2015-03-03 23:01:00.671 INFO   [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000227: 
Running hbm2ddl schema export
Hibernate: drop table if exists compte
Hibernate: drop table if exists hibernate_sequences
Hibernate: create table compte (DTYPE varchar(31) not null, id integer not null, numero 
varchar(255), solde decimal(19,2), decouvert integer, taux decimal(19,2), primary key (id))
Hibernate: create table hibernate_sequences ( sequence_name varchar(255),  
sequence_next_hi_value integer ) 
2015-03-03 23:01:00.722 INFO     [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000230: 
Schema export complete
Hibernate: select sequence_next_hi_value from hibernate_sequences where sequence_name = '
compte' for update
Hibernate: insert into hibernate_sequences(sequence_name, sequence_next_hi_value) values('
compte', ?)
Hibernate: update hibernate_sequences set sequence_next_hi_value = ? where 
sequence_next_hi_value = ? and sequence_name = 'compte'
Hibernate: insert into compte (numero, solde, DTYPE, id) values (?, ?, 'Compte', ?)
Hibernate: insert into compte (numero, solde, decouvert, DTYPE, id) values (?, ?, ?, '
CompteCourant', ?)
Hibernate: insert into compte (numero, solde, taux, DTYPE, id) values (?, ?, ?, 'CompteEpargne'
, ?)
Recherche d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_.decouvert as decouvert0_0_, compte0_.taux as taux0_0_, compte0_.DTYPE as 
DTYPE0_0_ from compte compte0_ where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.Compte@af908f [id=1, numero=000012345000, solde=0.00]

Recherche d'un compte courant
Hibernate: select comptecour0_.id as id0_0_, comptecour0_.numero as numero0_0_, comptecour0_.
solde as solde0_0_, comptecour0_.decouvert as decouvert0_0_ from compte comptecour0_ where 
comptecour0_.id=? and comptecour0_.DTYPE='CompteCourant'
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@27723440CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]

Recherche polymorphique d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_.decouvert as decouvert0_0_, compte0_.taux as taux0_0_, compte0_.DTYPE as 
DTYPE0_0_ from compte compte0_ where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@20700084CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

Recherche de tous les comptes
Hibernate: select compte0_.id as id0_, compte0_.numero as numero0_, compte0_.solde as solde0_, 
compte0_.decouvert as decouvert0_, compte0_.taux as taux0_, compte0_.DTYPE as DTYPE0_ from 
compte compte0_
fr.jmdoudoux.dej.hibernate.entity.Compte@164fc53 [id=1, numero=000012345000, solde=0.00]
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@13942651CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@23542324CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

Recherche polymorphique de comptes
Hibernate: select compte0_.id as id0_, compte0_.numero as numero0_, compte0_.solde as solde0_, 
compte0_.decouvert as decouvert0_, compte0_.taux as taux0_, compte0_.DTYPE as DTYPE0_ from 
compte compte0_ where compte0_.numero like ?
fr.jmdoudoux.dej.hibernate.entity.Compte@6ca594 [id=1, numero=000012345000, solde=0.00]
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@15384254CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@4681268CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

mysql> select * from compte;
+---------------+----+--------------+---------+-----------+------+
| DTYPE         | id | numero       | solde   | decouvert | taux |
+---------------+----+--------------+---------+-----------+------+
| Compte        |  1 | 000012345000 |    0.00 |      NULL | NULL |
| CompteCourant |  2 | 000012345010 | 1200.00 |      2000 | NULL |
| CompteEpargne |  3 | 000012345020 | 8000.00 |      NULL | 2.10 |
+---------------+----+--------------+---------+-----------+------+
3 rows in set (0.00 sec)

package fr.jmdoudoux.dej.hibernate.entity;
      
import java.math.BigDecimal;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Inheritance;
import javax.persistence.InheritanceType;
import javax.persistence.Table;

@Entity
@Table(name = "compte")
@Inheritance(strategy = InheritanceType.TABLE_PER_CLASS)
public class Compte {
  @Id
  @GeneratedValue(strategy = GenerationType.TABLE)
  @Column(name = "id")
  protected int        id;
  
  @Column(name = "numero")
  protected String     numero;
  
  @Column(name = "solde")
  protected BigDecimal solde;
  
  public int getId() {
    return id;
  }
  
  public void setId(int id) {
    this.id = id;
  }
  
  public String getNumero() {
    return numero;
  }
  
  public void setNumero(String numero) {
    this.numero = numero;
  }
  
  public BigDecimal getSolde() {
    return solde;
  }
  
  public void setSolde(BigDecimal solde) {
    this.solde = solde;
  }
  
  @Override
  public String toString() {
    return super.toString() + " [id=" + id + ", numero=" + numero + ", solde="
        + solde + "]";
  }
}

package fr.jmdoudoux.dej.hibernate.entity;
      
import javax.persistence.AttributeOverride;
import javax.persistence.AttributeOverrides;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;

@Entity
@Table(name = "compte_courant")
@AttributeOverrides({
    @AttributeOverride(name = "id", column = @Column(name = "id")),
    @AttributeOverride(name = "numero", column = @Column(name = "numero")),
    @AttributeOverride(name = "solde", column = @Column(name = "solde")) })
public class CompteCourant extends Compte {
  @Column(name = "decouvert")
  private int decouvert;
  
  public int getDecouvert() {
    return decouvert;
  }
  
  public void setDecouvert(int decouvert) {
    this.decouvert = decouvert;
  }
  
  @Override
  public String toString() {
    return this.getClass().getName() + "@" + System.identityHashCode(this)
        + "CompteCourant [id=" + id + ", numero=" + numero + ", solde=" + solde
        + ", decouvert=" + decouvert + "]";
  }
}

package fr.jmdoudoux.dej.hibernate.entity;
      
import java.math.BigDecimal;
import javax.persistence.AttributeOverride;
import javax.persistence.AttributeOverrides;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;

@Entity
@Table(name = "compte_epargne")
@AttributeOverrides({
    @AttributeOverride(name = "id", column = @Column(name = "id")),
    @AttributeOverride(name = "numero", column = @Column(name = "numero")),
    @AttributeOverride(name = "solde", column = @Column(name = "solde")) })
public class CompteEpargne extends Compte {
  @Column(name = "taux")
  private BigDecimal taux;
  
  public BigDecimal getTaux() {
    return taux;
  }
  
  public void setTaux(BigDecimal taux) {
    this.taux = taux;
  }
  
  @Override
  public String toString() {
    return this.getClass().getName() + "@" + System.identityHashCode(this)
        + "CompteEpargne [ id=" + id + ", numero=" + numero + ", solde="
        + solde + ", taux=" + taux + "]";
  }
}

2015-03-03 23:18:12.766 INFO   [main]:org.hibernate.annotations.common.Version - HCANN000001: 
Hibernate Commons Annotations {4.0.1.Final}
2015-03-03 23:18:12.776 INFO   [main]:org.hibernate.Version - HHH000412: Hibernate Core {4.1.
4.Final}
2015-03-03 23:18:12.779 INFO   [main]:org.hibernate.cfg.Environment - HHH000206: hibernate.
properties not found
2015-03-03 23:18:12.780 INFO   [main]:org.hibernate.cfg.Environment - HHH000021: Bytecode 
provider name : javassist
2015-03-03 23:18:12.814 INFO   [main]:org.hibernate.cfg.Configuration - HHH000043: 
Configuring from resource: /hibernate.cfg.xml
2015-03-03 23:18:12.814 INFO   [main]:org.hibernate.cfg.Configuration - HHH000040: 
Configuration resource: /hibernate.cfg.xml
2015-03-03 23:18:12.891 INFO   [main]:org.hibernate.cfg.Configuration - HHH000041: Configured 
SessionFactory: null
2015-03-03 23:18:13.080 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000402: Using Hibernate built-in connection pool (not 
for production use!)
2015-03-03 23:18:13.087 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000115: Hibernate connection pool size: 1
2015-03-03 23:18:13.088 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000006: Autocommit mode: false
2015-03-03 23:18:13.088 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000401: using driver [com.mysql.jdbc.Driver] at URL [
jdbc:mysql://localhost:3307/mabdd]
2015-03-03 23:18:13.089 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000046: Connection properties: {user=root, password=
****}
2015-03-03 23:18:13.392 INFO   [main]:org.hibernate.dialect.Dialect - HHH000400: Using 
dialect: org.hibernate.dialect.MySQL5Dialect
2015-03-03 23:18:13.424 INFO   [main]:org.hibernate.engine.transaction.internal.
TransactionFactoryInitiator - HHH000399: Using default transaction strategy (direct JDBC 
transactions)
2015-03-03 23:18:13.428 INFO   [main]:org.hibernate.hql.internal.ast.
ASTQueryTranslatorFactory - HHH000397: Using ASTQueryTranslatorFactory
2015-03-03 23:18:13.736 INFO   [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000227: 
Running hbm2ddl schema export
Hibernate: drop table if exists compte
Hibernate: drop table if exists compte_courant
Hibernate: drop table if exists compte_epargne
Hibernate: drop table if exists hibernate_sequences
Hibernate: create table compte (id integer not null, numero varchar(255), solde decimal(19,2), 
primary key (id))
Hibernate: create table compte_courant (id integer not null, numero varchar(255), solde 
decimal(19,2), decouvert integer, primary key (id))
Hibernate: create table compte_epargne (id integer not null, numero varchar(255), solde 
decimal(19,2), taux decimal(19,2), primary key (id))
Hibernate: create table hibernate_sequences ( sequence_name varchar(255),  
sequence_next_hi_value integer ) 
2015-03-03 23:18:13.843 INFO     [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000230: 
Schema export complete
Hibernate: select sequence_next_hi_value from hibernate_sequences where sequence_name = '
compte' for update
Hibernate: insert into hibernate_sequences(sequence_name, sequence_next_hi_value) values('
compte', ?)
Hibernate: update hibernate_sequences set sequence_next_hi_value = ? where 
sequence_next_hi_value = ? and sequence_name = 'compte'
Hibernate: insert into compte (numero, solde, id) values (?, ?, ?)
Hibernate: insert into compte_courant (numero, solde, decouvert, id) values (?, ?, ?, ?)
Hibernate: insert into compte_epargne (numero, solde, taux, id) values (?, ?, ?, ?)
Recherche d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_.decouvert as decouvert1_0_, compte0_.taux as taux2_0_, compte0_.clazz_ as 
clazz_0_ from ( select id, numero, solde, null as decouvert, null as taux, 0 as clazz_ from 
compte union select id, numero, solde, decouvert, null as taux, 1 as clazz_ from 
compte_courant union select id, numero, solde, null as decouvert, taux, 2 as clazz_ from 
compte_epargne ) compte0_ where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.Compte@198f6dd [id=1, numero=000012345000, solde=0.00]

Recherche d'un compte courant
Hibernate: select comptecour0_.id as id0_0_, comptecour0_.numero as numero0_0_, comptecour0_.
solde as solde0_0_, comptecour0_.decouvert as decouvert1_0_ from compte_courant comptecour0_ 
where comptecour0_.id=?
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@3316864CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]

Recherche polymorphique d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_.decouvert as decouvert1_0_, compte0_.taux as taux2_0_, compte0_.clazz_ as 
clazz_0_ from ( select id, numero, solde, null as decouvert, null as taux, 0 as clazz_ from 
compte union select id, numero, solde, decouvert, null as taux, 1 as clazz_ from 
compte_courant union select id, numero, solde, null as decouvert, taux, 2 as clazz_ from 
compte_epargne ) compte0_ where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@20376252CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

Recherche de tous les comptes
Hibernate: select compte0_.id as id0_, compte0_.numero as numero0_, compte0_.solde as solde0_, 
compte0_.decouvert as decouvert1_, compte0_.taux as taux2_, compte0_.clazz_ as clazz_ from ( 
select id, numero, solde, null as decouvert, null as taux, 0 as clazz_ from compte union 
select id, numero, solde, decouvert, null as taux, 1 as clazz_ from compte_courant union 
select id, numero, solde, null as decouvert, taux, 2 as clazz_ from compte_epargne ) compte0_
fr.jmdoudoux.dej.hibernate.entity.Compte@165d7a2 [id=1, numero=000012345000, solde=0.00]
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@30230592CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@4358252CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

Recherche polymorphique de comptes
Hibernate: select compte0_.id as id0_, compte0_.numero as numero0_, compte0_.solde as solde0_, 
compte0_.decouvert as decouvert1_, compte0_.taux as taux2_, compte0_.clazz_ as clazz_ from ( 
select id, numero, solde, null as decouvert, null as taux, 0 as clazz_ from compte union 
select id, numero, solde, decouvert, null as taux, 1 as clazz_ from compte_courant union 
select id, numero, solde, null as decouvert, taux, 2 as clazz_ from compte_epargne ) compte0_ 
where compte0_.numero like ?
fr.jmdoudoux.dej.hibernate.entity.Compte@129d5bf [id=1, numero=000012345000, solde=0.00]
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@26225329CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@11121275CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 73
Server version: 5.6.15 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates.
Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mabdd
Database changed
mysql> select * from compte;
+----+--------------+-------+
| id | numero       | solde |
+----+--------------+-------+
|  1 | 000012345000 |  0.00 |
+----+--------------+-------+
1 row in set (0.02 sec)
mysql> select * from compte_courant;
+----+--------------+---------+-----------+
| id | numero       | solde   | decouvert |
+----+--------------+---------+-----------+
|  2 | 000012345010 | 1200.00 |      2000 |
+----+--------------+---------+-----------+
1 row in set (0.00 sec)
mysql> select * from compte_epargne;
+----+--------------+---------+------+
| id | numero       | solde   | taux |
+----+--------------+---------+------+
|  3 | 000012345020 | 8000.00 | 2.10 |
+----+--------------+---------+------+
1 row in set (0.00 sec)
mysql>

package fr.jmdoudoux.dej.hibernate.entity;

import java.math.BigDecimal;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Inheritance;
import javax.persistence.InheritanceType;
import javax.persistence.Table;

@Entity
@Table(name = "compte")
@Inheritance(strategy =
InheritanceType.JOINED)
public class Compte {
  @Id
  @GeneratedValue
  @Column(name = "id")
  protected int        id;

  @Column(name = "numero")
  protected String     numero;

  @Column(name = "solde")
  protected BigDecimal solde;

  public int getId() {
    return id;
  }

  public void setId(int id) {
    this.id = id;
  }

  public String getNumero() {
    return numero;
  }

  public void setNumero(String numero) {
    this.numero = numero;
  }

  public BigDecimal getSolde() {
    return solde;
  }
  
  public void setSolde(BigDecimal solde) {
    this.solde = solde;
  }

  @Override
  public String toString() {
    return super.toString() + " [id="+ id + ", numero=" + numero + ", solde="
        + solde + "]";
  }
}

package fr.jmdoudoux.dej.hibernate.entity;
      
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.PrimaryKeyJoinColumn;
import javax.persistence.Table;

@Entity
@Table(name = "compte_courant")
@PrimaryKeyJoinColumn(name = "id")
public class CompteCourant extends Compte {
  @Column(name = "decouvert")
  private int decouvert;
  
  public int getDecouvert() {
    return decouvert;
  }
  
  public void setDecouvert(int decouvert){
    this.decouvert = decouvert;
  }
  
  @Override
  public String toString() {
    return this.getClass().getName() + "@" + System.identityHashCode(this)
        + "CompteCourant [id=" + id + ", numero=" + numero + ", solde=" + solde
        + ", decouvert=" + decouvert + "]";
  }
}

package fr.jmdoudoux.dej.hibernate.entity;

import java.math.BigDecimal;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.PrimaryKeyJoinColumn;
import javax.persistence.Table;

@Entity
@Table(name = "compte_epargne")
@PrimaryKeyJoinColumn(name = "id")
public class CompteEpargne extends Compte {
  @Column(name = "taux")
  private BigDecimal taux;

  public BigDecimal getTaux() {
    return taux;
  }

  public void setTaux(BigDecimal taux) {
    this.taux = taux;
  }
  
  @Override
  public String toString() {
    return this.getClass().getName() + "@" + System.identityHashCode(this)
        + "CompteEpargne [ id=" + id + ", numero=" + numero + ", solde="
        + solde + ", taux=" + taux + "]";
  }
}

2015-03-05 21:04:07.364 INFO   [main]:org.hibernate.annotations.common.Version - HCANN000001: 
Hibernate Commons Annotations {4.0.1.Final}
2015-03-05 21:04:07.373 INFO   [main]:org.hibernate.Version - HHH000412: Hibernate Core {4.1.
4.Final}
2015-03-05 21:04:07.375 INFO   [main]:org.hibernate.cfg.Environment - HHH000206: hibernate.
properties not found
2015-03-05 21:04:07.377 INFO   [main]:org.hibernate.cfg.Environment - HHH000021: Bytecode 
provider name : javassist
2015-03-05 21:04:07.405 INFO   [main]:org.hibernate.cfg.Configuration - HHH000043: 
Configuring from resource: /hibernate.cfg.xml
2015-03-05 21:04:07.405 INFO   [main]:org.hibernate.cfg.Configuration - HHH000040: 
Configuration resource: /hibernate.cfg.xml
2015-03-05 21:04:07.463 INFO   [main]:org.hibernate.cfg.Configuration - HHH000041: Configured 
SessionFactory: null
2015-03-05 21:04:07.641 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000402: Using Hibernate built-in connection pool (not 
for production use!)
2015-03-05 21:04:07.648 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000115: Hibernate connection pool size: 1
2015-03-05 21:04:07.648 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000006: Autocommit mode: false
2015-03-05 21:04:07.649 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000401: using driver [com.mysql.jdbc.Driver] at URL [
jdbc:mysql://localhost:3307/mabdd]
2015-03-05 21:04:07.649 INFO   [main]:org.hibernate.service.jdbc.connections.internal.
DriverManagerConnectionProviderImpl - HHH000046: Connection properties: {user=root, password=
****}
2015-03-05 21:04:07.955 INFO   [main]:org.hibernate.dialect.Dialect - HHH000400: Using 
dialect: org.hibernate.dialect.MySQL5Dialect
2015-03-05 21:04:07.983 INFO   [main]:org.hibernate.engine.transaction.internal.
TransactionFactoryInitiator - HHH000399: Using default transaction strategy (direct JDBC 
transactions)
2015-03-05 21:04:07.988 INFO   [main]:org.hibernate.hql.internal.ast.
ASTQueryTranslatorFactory - HHH000397: Using ASTQueryTranslatorFactory
2015-03-05 21:04:08.211 INFO   [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000227: 
Running hbm2ddl schema export
Hibernate: alter table compte_courant drop foreign key FK2435FDBF9CCD1BB4
Hibernate: alter table compte_epargne drop foreign key FK8E9D8D439CCD1BB4
Hibernate: drop table if exists compte
Hibernate: drop table if exists compte_courant
Hibernate: drop table if exists compte_epargne
Hibernate: create table compte (id integer not null auto_increment, numero varchar(255), solde 
decimal(19,2), primary key (id))
Hibernate: create table compte_courant (decouvert integer, id integer not null, primary key (
id))
Hibernate: create table compte_epargne (taux decimal(19,2), id integer not null, primary key (
id))
Hibernate: alter table compte_courant add index FK2435FDBF9CCD1BB4 (id), add constraint 
FK2435FDBF9CCD1BB4 foreign key (id) references compte (id)
Hibernate: alter table compte_epargne add index FK8E9D8D439CCD1BB4 (id), add constraint 
FK8E9D8D439CCD1BB4 foreign key (id) references compte (id)
2015-03-05 21:04:08.315 INFO     [main]:org.hibernate.tool.hbm2ddl.SchemaExport - HHH000230: 
Schema export complete
Hibernate: insert into compte (numero, solde) values (?, ?)
Hibernate: insert into compte (numero, solde) values (?, ?)
Hibernate: insert into compte_courant (decouvert, id) values (?, ?)
Hibernate: insert into compte (numero, solde) values (?, ?)
Hibernate: insert into compte_epargne (taux, id) values (?, ?)
Recherche d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_1_.decouvert as decouvert1_0_, compte0_2_.taux as taux2_0_, case when 
compte0_1_.id is not null then 1 when compte0_2_.id is not null then 2 when compte0_.id is not 
null then 0 end as clazz_0_ from compte compte0_ left outer join compte_courant compte0_1_ on 
compte0_.id=compte0_1_.id left outer join compte_epargne compte0_2_ on compte0_.id=compte0_2_.
id where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.Compte@24ad9b [id=1, numero=000012345000, solde=0.00]

Recherche d'un compte courant
Hibernate: select comptecour0_.id as id0_0_, comptecour0_1_.numero as numero0_0_, 
comptecour0_1_.solde as solde0_0_, comptecour0_.decouvert as decouvert1_0_ from compte_courant 
comptecour0_ inner join compte comptecour0_1_ on comptecour0_.id=comptecour0_1_.id where 
comptecour0_.id=?
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@29984851CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]

Recherche polymorphique d'un compte
Hibernate: select compte0_.id as id0_0_, compte0_.numero as numero0_0_, compte0_.solde as 
solde0_0_, compte0_1_.decouvert as decouvert1_0_, compte0_2_.taux as taux2_0_, case when 
compte0_1_.id is not null then 1 when compte0_2_.id is not null then 2 when compte0_.id is not 
null then 0 end as clazz_0_ from compte compte0_ left outer join compte_courant compte0_1_ on 
compte0_.id=compte0_1_.id left outer join compte_epargne compte0_2_ on compte0_.id=compte0_2_.
id where compte0_.id=?
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@6285813CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]

Recherche de tous les comptes
Hibernate: select compte0_.id as id0_, compte0_.numero as numero0_, compte0_.solde as solde0_, 
compte0_1_.decouvert as decouvert1_, compte0_2_.taux as taux2_, case when compte0_1_.id is not 
null then 1 when compte0_2_.id is not null then 2 when compte0_.id is not null then 0 end as 
clazz_ from compte compte0_ left outer join compte_courant compte0_1_ on compte0_.id=
compte0_1_.id left outer join compte_epargne compte0_2_ on compte0_.id=compte0_2_.id
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@15462959CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@12544708CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]
fr.jmdoudoux.dej.hibernate.entity.Compte@fa8f2c [id=1, numero=000012345000, solde=0.00]

Recherche polymorphique de comptes
Hibernate: select compte0_.id as id0_, compte0_.numero as numero0_, compte0_.solde as solde0_, 
compte0_1_.decouvert as decouvert1_, compte0_2_.taux as taux2_, case when compte0_1_.id is not 
null then 1 when compte0_2_.id is not null then 2 when compte0_.id is not null then 0 end as 
clazz_ from compte compte0_ left outer join compte_courant compte0_1_ on compte0_.id=
compte0_1_.id left outer join compte_epargne compte0_2_ on compte0_.id=compte0_2_.id where 
compte0_.numero like ?
fr.jmdoudoux.dej.hibernate.entity.CompteCourant@9037617CompteCourant [id=2, numero=
000012345010, solde=1200.00, decouvert=2000]
fr.jmdoudoux.dej.hibernate.entity.CompteEpargne@27879211CompteEpargne [ id=3, numero=
000012345020, solde=8000.00, taux=2.10]
fr.jmdoudoux.dej.hibernate.entity.Compte@1a4654d [id=1, numero=000012345000, solde=0.00]

Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 82
Server version: 5.6.15 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use mabdd
Database changed
mysql> select * from compte;
+----+--------------+---------+
| id | numero       | solde   |
+----+--------------+---------+
|  1 | 000012345000 |    0.00 |
|  2 | 000012345010 | 1200.00 |
|  3 | 000012345020 | 8000.00 |
+----+--------------+---------+
3 rows in set (0.00 sec)
mysql> select * from compte_courant;
+-----------+----+
| decouvert | id |
+-----------+----+
|      2000 |  2 |
+-----------+----+
1 row in set (0.00 sec)
mysql> select * from compte_epargne;
+------+----+
| taux | id |
+------+----+
| 2.10 |  3 |
+------+----+
1 row in set (0.00 sec)
mysql>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate
Mapping DTD//EN" "http://hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="fr.jmdoudoux.dej.hibernatecache.entity.Pays"
       table="pays" >
        <id name="id" column="id" type="int" >
            <generator class="identity" />
        </id>
        <property name="codeIso" column="code_iso"
           not-null="true" type="string" />
        <property name="nom" not-null="true" type="string" />
        <many-to-one name="devise" column="FK_DEVISE"
           class="fr.jmdoudoux.dej.hibernatecache.entity.Devise" />
    </class>
</hibernate-mapping>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC  "-//Hibernate/Hibernate Mapping
DTD//EN" "http://hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="fr.jmdoudoux.dej.hibernatecache.entity.Devise"
      table="DEVISE" >
        <id name="id" column="ID" >
            <generator class="identity" />
        </id>
        <property name="code" column="CODE" />
        <property name="libelle" column="LIBELLE" />
        <set name="pays" >
           <key column="FK_DEVISE" />
           <one-to-many class="fr.jmdoudoux.dej.hibernatecache.entity.Pays"/>
        </set>
    </class>
</hibernate-mapping>

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration SYSTEM 
"http://hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <!-- Database connection settings -->
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/mabdd</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.connection.password"></property>
    <property name="hibernate.connection.pool_size">1</property>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hibernate.current_session_context_class">thread</property>
    <!-- Cache de second niveau désactivé  -->
    <property name="hibernate.cache.provider_class">
      org.hibernate.cache.internal.NoCacheProvider</property>
    <!-- Afficher les requêtes SQL exécutées sur la sortie standard -->
    <property name="hibernate.show_sql">true</property>
    <mapping resource="Pays.hbm.xml" />
    <mapping resource="Devise.hbm.xml" />
  </session-factory>
</hibernate-configuration>

  public static void lirePaysDeuxFois() throws Exception {
    Session session = sessionFactory.openSession();
    Transaction tx = null;
    try {
      tx = session.beginTransaction();
      Pays pays = (Pays) session.load(Pays.class, new Integer(4));
      System.out.println("pays : id=" + pays.getId() + " codeIso="
          + pays.getCodeIso() + " nom=" + pays.getNom());
      pays = (Pays) session.load(Pays.class, new Integer(4));
      System.out.println("pays : id=" + pays.getId() + " codeIso=" 
          + pays.getCodeIso() + " nom=" + pays.getNom());
      tx.commit();
    } catch (Exception e) {
      if (tx != null) {
        tx.rollback();
      }
      throw e;
    } finally {
      session.close();
    }
  }

Hibernate: select pays0_.id as
id0_0_, pays0_.code_iso as code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE
as FK4_0_0_ from pays pays0_ where pays0_.id=?
pays : id=4 codeIso=LU
nom=Luxembourg
pays : id=4 codeIso=LU
nom=Luxembourg

    <property name="hibernate.cache.provider_class">
org.hibernate.cache.internal.NoCacheProvider</property>

    <property name="hibernate.cache.region.factory_class">
org.hibernate.cache.internal.NoCachingRegionFactory</property>

<property name="hibernate.cache.provider_class">
org.hibernate.cache.EhCacheProvider</property>

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration SYSTEM 
"http://hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <!-- ... -->
    <!-- Cache de second niveau activé avec ehcache  -->
    <!-- property name="hibernate.cache.provider_class">
      org.hibernate.cache.internal.NoCacheProvider</property-->
    <property name="hibernate.cache.region.factory_class">
      org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory</property>
    <!-- ... -->
  </session-factory>
</hibernate-configuration>

<?xml version="1.0" encoding="UTF-8"?>
<ehcache>
      <diskStore path="C:\temp\cache" />
      <defaultCache maxElementsInMemory="100" eternal="false"
            timeToIdleSeconds="120" timeToLiveSeconds="120" overflowToDisk="true" />
</ehcache>

WARN    
[main]:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory -
HHH020003: Could not find a specific ehcache configuration for cache named
[fr.jmdoudoux.dej.hibernatecache.entity.Pays]; using defaults.

<?xml version="1.0" encoding="UTF-8"?>
<ehcache>
      <diskStore path="C:\temp\cache" />
      <defaultCache maxElementsInMemory ="100" eternal="false"
            timeToIdleSeconds="120" timeToLiveSeconds="120" overflowToDisk="true" />
      <cache name="fr.jmdoudoux.dej.hibernatecache.entity.Pays"
            maxElementsInMemory="250" eternal="true" overflowToDisk="false" />
      <cache name="fr.jmdoudoux.dej.hibernatecache.entity.Section"
            maxElementsInMemory="100" eternal="false" timeToIdleSeconds="300"
            timeToLiveSeconds="600" overflowToDisk="true" />
</ehcache>

WARN    
[main]:org.hibernate.cache.ehcache.internal.strategy.EhcacheAccessStrategyFactoryImpl
- HHH020007: read-only cache configured for mutable entity
[fr.jmdoudoux.dej.hibernatecache.entity.Pays]

WARN    
[main]:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory -
HHH020003: Could not find a specific ehcache configuration for cache named
[fr.jmdoudoux.dej.hibernatecache.entity.Devise.pays]; using defaults.

INFO     [main]:org.hibernate.cache.spi.UpdateTimestampsCache
- HHH000250: Starting update timestamps cache at region:
org.hibernate.cache.spi.UpdateTimestampsCache
WARN    
[main]:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory -
HHH020003: Could not find a specific ehcache configuration for cache named
[org.hibernate.cache.spi.UpdateTimestampsCache]; using defaults.
INFO    
[main]:org.hibernate.cache.internal.StandardQueryCache - HHH000248:
Starting query cache at region: org.hibernate.cache.internal.StandardQueryCache
WARN    
[main]:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory -
HHH020003: Could not find a specific ehcache configuration for cache named
[org.hibernate.cache.internal.StandardQueryCache]; using defaults.

<cache name="org.hibernate.cache.StandardQueryCache"
maxEntriesLocalHeap="50" eternal="false" timeToLiveSeconds="300"
overflowToDisk="true"/>

<cache name="org.hibernate.cache.UpdateTimestampsCache"
maxEntriesLocalHeap="500" eternal="true" overflowToDisk="true"/>

<cache name="query.paysPourUneMonnaie" maxEntriesLocalHeap="20"
eternal="false" timeToLiveSeconds="3600" overflowToDisk="true"/>

<property name="hibernate.transaction.jta.platform"
value="org.hibernate.service.jta.platform.internal.SunOneJtaPlatform" /> 

HHH000427:
Using deprecated org.hibernate.transaction.TransactionManagerLookup strategy
[hibernate.transaction.manager_lookup_class], use newer
org.hibernate.service.jta.platform.spi.JtaPlatform strategy instead
[hibernate.transaction.jta.platform]

package fr.jmdoudoux.dej.hibernatecache;

import java.util.Set;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import fr.jmdoudoux.dej.hibernatecache.entity.Devise;
import fr.jmdoudoux.dej.hibernatecache.entity.Pays;

public class TestHibernateCache {
  private static SessionFactory sessionFactory = null;
  public static void main(String[] args) {
    try {
      sessionFactory = new Configuration().configure().buildSessionFactory();
      for (int i = 0; i < 3; i++) {
        lirePays();
      }
    } catch (Throwable ex){
      System.err.println("Erreur durant les traitements" + ex);
    } finally {
      sessionFactory.close();
    }
  }

  public static void lirePays() throws Exception {
    Session session = sessionFactory.openSession();
    Transaction tx = null;
    try {
      tx = session.beginTransaction();
      Pays pays = (Pays) session.load(Pays.class, new Integer(4));
      System.out.println("pays : id=" + pays.getId() + "codeIso="
          + pays.getCodeIso() + " nom=" + pays.getNom());
      tx.commit();
    } catch (Exception e) {
      if (tx != null) {
        tx.rollback();
      }
      throw e;
    } finally {
      session.close();
    }
  }  
}

Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
pays : id=4 codeIso=LU nom=Luxembourg
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
pays : id=4 codeIso=LU nom=Luxembourg
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
pays : id=4 codeIso=LU nom=Luxembourg

<cache usage="transactional|read-write|nonstrict-read-write|read-only"
region="nom_de_la_region" include="all|non-lazy" />

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate
Mapping DTD//EN"
 "http://hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="fr.jmdoudoux.dej.hibernatecache.entity.Pays" table="pays" >
        <cache usage="read-only"/>
        <id name="id" column="id" type="int" >
            <generator class="identity" />
        </id>
        <property name="codeIso" column="code_iso" not-null="true" type="string" />
        <property name="nom" not-null="true" type="string" />
        <many-to-one name="devise" column="FK_DEVISE"
           class="fr.jmdoudoux.dej.hibernatecache.entity.Devise" />
    </class>
</hibernate-mapping>

Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
pays : id=4 codeIso=LU nom=Luxembourg
pays : id=4 codeIso=LU nom=Luxembourg
pays : id=4 codeIso=LU nom=Luxembourg

package fr.jmdoudoux.dej.hibernatecache.entity;

import java.io.Serializable;
import javax.persistence.Basic;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
import org.hibernate.annotations.Cache;
import org.hibernate.annotations.CacheConcurrencyStrategy;

@Entity
@Table(name = "PAYS")
@Cache(usage = CacheConcurrencyStrategy.READ_WRITE)
public class Pays implements Serializable {
  private static final long serialVersionUID = 1L;

  @Id
  private int               id;

  @Column(name = "code_iso")
  private String            codeIso;

  @Basic
  private String            nom;

  @ManyToOne(cascade = { CascadeType.PERSIST, CascadeType.MERGE })
  @JoinColumn(name = "FK_DEVISE")
  private Devise            devise;

  public Pays() {
  }

  // getters et setters

  
  @Override
  public String toString() {
    return "Pays [id=" + id + ", codeIso=" + codeIso + ", nom=" + nom
        + ", devise=" + devise + ", getClass()=" + getClass() + ", hashCode()="
        + hashCode() + ", toString()=" + super.toString() + "]";
  }
}

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration SYSTEM 
"http://hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <!-- Database connection settings -->
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/mabdd</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.connection.password"></property>
    <property name="hibernate.connection.pool_size">1</property>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hibernate.current_session_context_class">thread</property>
    <!-- Cache de second niveau désactivé  -->
    <!-- property name="hibernate.cache.provider_class">
      org.hibernate.cache.internal.NoCacheProvider</property-->
    <property name="hibernate.cache.region.factory_class">
      org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory</property>
    <property name="hibernate.generate_statistics">true</property>
    <property name="hibernate.cache.use_structured_entries">true</property>
    <!-- Afficher les requêtes SQL exécutées sur la sortie standard -->
    <property name="hibernate.show_sql">true</property>
    <mapping resource="Pays.hbm.xml" />
    <mapping resource="Devise.hbm.xml" />
    <class-cache class="fr.jmdoudoux.dej.hibernatecache.entity.Pays" usage="read-only"/>
    </session-factory>
</hibernate-configuration>

  public static void lireEtModifierPays() throws Exception {
    Session session1 = sessionFactory.openSession();
    Session session2 = null;
    Transaction tx = null;
    try {
      tx = session1.beginTransaction();
      Pays pays = (Pays) session1.load(Pays.class, new Integer(99));
      System.out.println("session1 pays : id=" + pays.getId() + " codeIso="
          + pays.getCodeIso() + " nom=" + pays.getNom());
      pays.setNom(pays.getNom() + " modifie");
      tx.commit();
      session2 = sessionFactory.openSession();
      tx = session2.beginTransaction();
      pays = (Pays) session2.load(Pays.class, new Integer(99));
      System.out.println("session2 pays : id=" + pays.getId() +" codeIso="
          + pays.getCodeIso() + " nom=" + pays.getNom());
      tx.commit();
    } catch (Exception e) {
      if (tx != null) {
        tx.rollback();
      }
      throw e;
    } finally {
      if (session2 != null)
        session2.close();
      if (session1 != null)
        session1.close();
    }
  }

Hibernate: select pays0_.id as
id0_0_, pays0_.code_iso as code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE
as FK4_0_0_ from pays pays0_ where pays0_.id=?
session1 pays : id=99 codeIso=XXX nom=test
Hibernate: update pays set
code_iso=?, nom=?, FK_DEVISE=? where id=?
session2 pays : id=99 codeIso=XXX nom=test modifie
2012-08-28 22:40:01.982 INFO    
[main]:org.hibernate.stat.internal.ConcurrentStatisticsImpl - HHH000239:
Second level cache puts: 2
2012-08-28 22:40:01.998 INFO    
[main]:org.hibernate.stat.internal.ConcurrentStatisticsImpl - HHH000237:
Second level cache hits: 1
2012-08-28 22:40:01.998
INFO    
[main]:org.hibernate.stat.internal.ConcurrentStatisticsImpl - HHH000238:
Second level cache misses: 1

  public static void lireEtModifierPays() throws Exception {
    Session session1 = sessionFactory.openSession();
    Session session2 = sessionFactory.openSession();
    Transaction tx = null;
    try {
      tx = session1.beginTransaction();
      Pays pays = (Pays) session1.load(Pays.class, new Integer(99));
      System.out.println("session1 pays : id=" + pays.getId() + " codeIso="
          + pays.getCodeIso() + " nom=" + pays.getNom());
      pays.setNom(pays.getNom() + " modifie");
      tx.commit();
      tx = session2.beginTransaction();
      pays = (Pays) session2.load(Pays.class, new Integer(99));
      System.out.println("session2 pays : id=" + pays.getId() + " codeIso="
          + pays.getCodeIso() + " nom=" + pays.getNom());
      tx.commit();
    } catch (Exception e) {
      if (tx != null) {
        tx.rollback();
      }
      throw e;
    } finally {
      if (session2 != null)
        session2.close();
      if (session1 != null)
        session1.close();
    }
  }

Hibernate: select pays0_.id as
id0_0_, pays0_.code_iso as code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE
as FK4_0_0_ from pays pays0_ where pays0_.id=?
2012-08-19 21:55:51.721 INFO     
session1 pays : id=99 codeIso=XXX nom=test modifie
Hibernate: update pays set
code_iso=?, nom=?, FK_DEVISE=? where id=?
Hibernate: select pays0_.id as
id0_0_, pays0_.code_iso as code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE
as FK4_0_0_ from pays pays0_ where pays0_.id=?
session2 pays : id=99 codeIso=XXX nom=test modifie modifie

Hibernate: select pays0_.id as
id0_0_, pays0_.code_iso as code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE
as FK4_0_0_ from pays pays0_ where pays0_.id=?
session1 pays : id=99 codeIso=XXXtest nom=test modifie
Hibernate: update pays set
code_iso=?, nom=?, FK_DEVISE=? where id=?
Hibernate: select pays0_.id as
id0_0_, pays0_.code_iso as code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE
as FK4_0_0_ from pays pays0_ where pays0_.id=?
session2 pays : id=99 codeIso=XXXtest nom=test modifie
2012-08-28 22:43:53.960 INFO     [main]:org.hibernate.stat.internal.ConcurrentStatisticsImpl
- HHH000239: Second level cache puts: 2
2012-08-28 22:43:53.960 INFO    
[main]:org.hibernate.stat.internal.ConcurrentStatisticsImpl - HHH000237:
Second level cache hits: 0
2012-08-28 22:43:53.960
INFO     [main]:org.hibernate.stat.internal.ConcurrentStatisticsImpl
- HHH000238: Second level cache misses: 2

package fr.jmdoudoux.dej.hibernatecache;

import java.util.Set;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import fr.jmdoudoux.dej.hibernatecache.entity.Devise;
import fr.jmdoudoux.dej.hibernatecache.entity.Pays;

public class TestHibernateCache {
  private static SessionFactory sessionFactory = null;
  public static void main(String[] args) {
    try {
      sessionFactory = new Configuration().configure().buildSessionFactory();
      for (int i = 0; i < 3; i++) {
        // lirePays();

        listerPaysEuro();
      }
    } catch (Throwable ex) {
      System.err.println("Erreur durant les traitements" + ex);
    } finally {
      sessionFactory.close();
    }
  }

  public static void listerPaysEuro() throws Exception {
    Session session = sessionFactory.openSession();
    Transaction tx = null;
    try {
      tx = session.beginTransaction();
      Devise deviseEur = (Devise) session.load(Devise.class, new Integer(1));
      System.out.println("Devise : id=" + deviseEur.getId() + " code="
          + deviseEur.getCode() + " libelle=" + deviseEur.getLibelle());
      Set<Pays> paysEur = deviseEur.getPays();
      for (Pays pays : paysEur) {
        System.out.println("  pays : id=" + pays.getId() + " codeIso="
            + pays.getCodeIso() + " nom=" + pays.getNom());
      }
      tx.commit();
    } catch (Exception e) {
      if (tx != null) {
        tx.rollback();
      }
      throw e;
    } finally {
      session.close();
    }
  }
}

Hibernate: select devise0_.ID as ID1_0_, devise0_.CODE as
CODE1_0_, devise0_.LIBELLE as LIBELLE1_0_ from DEVISE devise0_ where
devise0_.ID=?
Devise : id=1 code=EUR libelle=Euro
Hibernate: select pays0_.FK_DEVISE as FK4_1_1_, pays0_.id as id1_,
pays0_.id as id0_0_, pays0_.code_iso as code2_0_0_, pays0_.nom as nom0_0_,
pays0_.FK_DEVISE as FK4_0_0_ from pays pays0_ where pays0_.FK_DEVISE=?
  pays : id=4 codeIso=LU nom=Luxembourg
  pays : id=3 codeIso=I nom=Italie
  pays : id=2 codeIso=D nom=Allemagne
  pays : id=1 codeIso=FR nom=France
Hibernate: select devise0_.ID as ID1_0_, devise0_.CODE as
CODE1_0_, devise0_.LIBELLE as LIBELLE1_0_ from DEVISE devise0_ where
devise0_.ID=?
Devise : id=1 code=EUR libelle=Euro
Hibernate: select pays0_.FK_DEVISE as FK4_1_1_, pays0_.id as id1_,
pays0_.id as id0_0_, pays0_.code_iso as code2_0_0_, pays0_.nom as nom0_0_,
pays0_.FK_DEVISE as FK4_0_0_ from pays pays0_ where pays0_.FK_DEVISE=?
  pays : id=2 codeIso=D nom=Allemagne
  pays : id=3 codeIso=I nom=Italie
  pays : id=4 codeIso=LU nom=Luxembourg
  pays : id=1 codeIso=FR nom=France
Hibernate: select devise0_.ID as ID1_0_, devise0_.CODE as
CODE1_0_, devise0_.LIBELLE as LIBELLE1_0_ from DEVISE devise0_ where
devise0_.ID=?
Devise : id=1 code=EUR libelle=Euro
Hibernate: select pays0_.FK_DEVISE as FK4_1_1_, pays0_.id as id1_,
pays0_.id as id0_0_, pays0_.code_iso as code2_0_0_, pays0_.nom as nom0_0_,
pays0_.FK_DEVISE as FK4_0_0_ from pays pays0_ where pays0_.FK_DEVISE=?
  pays : id=2 codeIso=D nom=Allemagne
  pays : id=1 codeIso=FR nom=France
  pays : id=4 codeIso=LU nom=Luxembourg
  pays : id=3 codeIso=I nom=Italie

<class name="Devise" table="DEVISE">
   <cache usage="read-only"/>
   <id name="id" column="ID">
     <generator class="identity"/>
   </id>
   <property name="code" column="CODE"/>
   <property name="libelle" column="LIBELLE"/>
   <set name="pays">
     <cache usage="read-only"/>
     <key column="FK_DEVISE"/>
     <one-to-many class="Pays"/>
   </set>
 </class>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate
Mapping DTD//EN" "http://hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
    <class name="fr.jmdoudoux.dej.hibernatecache.entity.Pays"
      table="pays" >
        <cache usage="read-only"/>
        <id name="id" column="id" type="int" >
            <generator class="identity" />
        </id>
        <property name="codeIso" column="code_iso"
            not-null="true" type="string" />
        <property name="nom" not-null="true" type="string" />
        <many-to-one name="devise" column="FK_DEVISE"
           class="fr.jmdoudoux.dej.hibernatecache.entity.Devise" />
    </class>
</hibernate-mapping>

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration SYSTEM 
"http://hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <!-- Database connection settings -->
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/mabdd</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.connection.password"></property>
    <property name="hibernate.connection.pool_size">1</property>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hibernate.current_session_context_class">thread</property>
    <!-- Cache de second niveau désactivé  -->
    <!-- property name="hibernate.cache.provider_class">
      org.hibernate.cache.internal.NoCacheProvider</property-->
    <property name="hibernate.cache.region.factory_class">
      org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory</property>
    <property name="hibernate.generate_statistics">true</property>
    <property name="hibernate.cache.use_structured_entries">true</property>
    <!-- Afficher les requêtes SQL exécutées sur la sortie standard -->
    <property name="hibernate.show_sql">true</property>
    <mapping resource="Pays.hbm.xml" />
    <mapping resource="Devise.hbm.xml" />
    <class-cache class="fr.jmdoudoux.dej.hibernatecache.entity.Pays" usage="read-only"/>
    <class-cache class="fr.jmdoudoux.dej.hibernatecache.entity.Devise" usage="read-only" />
    <collection-cache collection="fr.jmdoudoux.dej.hibernatecache.entity.Devise.pays" 
      usage="read-only"/>
    </session-factory>
</hibernate-configuration>

package fr.jmdoudoux.dej.hibernatecache.entity;

import java.io.Serializable;
import java.util.Set;
import javax.persistence.Basic;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import org.hibernate.annotations.Cache;
import org.hibernate.annotations.CacheConcurrencyStrategy;

@Entity
@Table(name = "DEVISE")
@Cache(usage = CacheConcurrencyStrategy.READ_ONLY)
public class Devise implements Serializable {
  private static final long serialVersionUID = 1L;
  
  @Id
  private int               id;

  @Basic
  private String            code;

  @Basic
  private String            libelle;

  @OneToMany(mappedBy = "devise")
  @Cache(usage = CacheConcurrencyStrategy.READ_ONLY)
  private Set<Pays>         pays;

  public Devise() {
  }

  // getters et setters

}

Hibernate: select devise0_.ID as ID1_0_, devise0_.CODE as CODE1_0_,
devise0_.LIBELLE as LIBELLE1_0_ from DEVISE devise0_ where devise0_.ID=?
Devise : id=1 code=EUR libelle=Euro
Hibernate: select pays0_.FK_DEVISE as FK4_1_1_, pays0_.id as id1_,
pays0_.id as id0_0_, pays0_.code_iso as code2_0_0_, pays0_.nom as nom0_0_,
pays0_.FK_DEVISE as FK4_0_0_ from pays pays0_ where pays0_.FK_DEVISE=?
  pays : id=3 codeIso=I nom=Italie
  pays : id=1 codeIso=FR nom=France
  pays : id=2 codeIso=D nom=Allemagne
  pays : id=4 codeIso=LU nom=Luxembourg
Devise : id=1 code=EUR libelle=Euro
  pays : id=3 codeIso=I nom=Italie
  pays : id=2 codeIso=D nom=Allemagne
  pays : id=4 codeIso=LU nom=Luxembourg
  pays : id=1 codeIso=FR nom=France
Devise : id=1 code=EUR libelle=Euro
  pays : id=4 codeIso=LU nom=Luxembourg
  pays : id=1 codeIso=FR nom=France
  pays : id=2 codeIso=D nom=Allemagne
  pays : id=3 codeIso=I nom=Italie

Hibernate: select devise0_.ID as ID1_0_, devise0_.CODE as
CODE1_0_, devise0_.LIBELLE as LIBELLE1_0_ from DEVISE devise0_ where
devise0_.ID=?
Devise : id=1 code=EUR libelle=Euro
Hibernate: select pays0_.FK_DEVISE as FK4_1_1_, pays0_.id as id1_,
pays0_.id as id0_0_, pays0_.code_iso as code2_0_0_, pays0_.nom as nom0_0_,
pays0_.FK_DEVISE as FK4_0_0_ from pays pays0_ where pays0_.FK_DEVISE=?
  pays : id=4 codeIso=LU nom=Luxembourg
  pays : id=2 codeIso=D nom=Allemagne
  pays : id=3 codeIso=I nom=Italie
  pays : id=1 codeIso=FR nom=France
Devise : id=1 code=EUR libelle=Euro
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
  pays : id=3 codeIso=I nom=Italie
  pays : id=4 codeIso=LU nom=Luxembourg
  pays : id=2 codeIso=D nom=Allemagne
  pays : id=1 codeIso=FR nom=France
Devise : id=1 code=EUR libelle=Euro
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
  pays : id=4 codeIso=LU nom=Luxembourg
  pays : id=1 codeIso=FR nom=France
  pays : id=3 codeIso=I nom=Italie
  pays : id=2 codeIso=D nom=Allemagne

Hibernate: select devise0_.ID as ID1_0_, devise0_.CODE as
CODE1_0_, devise0_.LIBELLE as LIBELLE1_0_ from DEVISE devise0_ where
devise0_.ID=?
Devise : id=1 code=EUR libelle=Euro
Hibernate: select pays0_.FK_DEVISE as FK4_1_1_, pays0_.id as id1_,
pays0_.id as id0_0_, pays0_.code_iso as code2_0_0_, pays0_.nom as nom0_0_,
pays0_.FK_DEVISE as FK4_0_0_ from pays pays0_ where pays0_.FK_DEVISE=?
  pays : id=4 codeIso=LU nom=Luxembourg
  pays : id=1 codeIso=FR nom=France
  pays : id=2 codeIso=D nom=Allemagne
  pays : id=3 codeIso=I nom=Italie
Hibernate: select devise0_.ID as ID1_0_, devise0_.CODE as
CODE1_0_, devise0_.LIBELLE as LIBELLE1_0_ from DEVISE devise0_ where
devise0_.ID=?
Devise : id=1 code=EUR libelle=Euro
  pays : id=3 codeIso=I nom=Italie
  pays : id=1 codeIso=FR nom=France
  pays : id=4 codeIso=LU nom=Luxembourg
  pays : id=2 codeIso=D nom=Allemagne
Hibernate: select devise0_.ID as ID1_0_, devise0_.CODE as
CODE1_0_, devise0_.LIBELLE as LIBELLE1_0_ from DEVISE devise0_ where
devise0_.ID=?
Devise : id=1 code=EUR libelle=Euro
  pays : id=3 codeIso=I nom=Italie
  pays : id=2 codeIso=D nom=Allemagne
  pays : id=4 codeIso=LU nom=Luxembourg
  pays : id=1 codeIso=FR nom=France

Hibernate: select devise0_.ID as ID1_0_, devise0_.CODE as
CODE1_0_, devise0_.LIBELLE as LIBELLE1_0_ from DEVISE devise0_ where
devise0_.ID=?
Devise : id=1 code=EUR libelle=Euro
Hibernate: select pays0_.FK_DEVISE as FK4_1_1_, pays0_.id as id1_,
pays0_.id as id0_0_, pays0_.code_iso as code2_0_0_, pays0_.nom as nom0_0_,
pays0_.FK_DEVISE as FK4_0_0_ from pays pays0_ where pays0_.FK_DEVISE=?
  pays : id=2 codeIso=D nom=Allemagne
  pays : id=3 codeIso=I nom=Italie
  pays : id=1 codeIso=FR nom=France
  pays : id=4 codeIso=LU nom=Luxembourg
Hibernate: select devise0_.ID as ID1_0_, devise0_.CODE as
CODE1_0_, devise0_.LIBELLE as LIBELLE1_0_ from DEVISE devise0_ where
devise0_.ID=?
Devise : id=1 code=EUR libelle=Euro
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays pays0_
where pays0_.id=?
  pays : id=4 codeIso=LU nom=Luxembourg
  pays : id=1 codeIso=FR nom=France
  pays : id=3 codeIso=I nom=Italie
  pays : id=2 codeIso=D nom=Allemagne
Hibernate: select devise0_.ID as ID1_0_, devise0_.CODE as
CODE1_0_, devise0_.LIBELLE as LIBELLE1_0_ from DEVISE devise0_ where
devise0_.ID=?
Devise : id=1 code=EUR libelle=Euro
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
  pays : id=3 codeIso=I nom=Italie
  pays : id=1 codeIso=FR nom=France
  pays : id=4 codeIso=LU nom=Luxembourg
  pays : id=2 codeIso=D nom=Allemagne

package fr.jmdoudoux.dej.hibernatecache;

import java.util.List;
import java.util.Set;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import fr.jmdoudoux.dej.hibernatecache.entity.Devise;
import fr.jmdoudoux.dej.hibernatecache.entity.Pays;

public class TestHibernateCache {
  private static SessionFactory sessionFactory = null;

  public static void main(String[] args) {
    try {
      sessionFactory = new Configuration().configure().buildSessionFactory();
      for (int i = 0; i < 3; i++) {
        listerTousPays();
      }
    } catch (Throwable ex) {
      System.err.println("Erreur durant les traitements" + ex);
    } finally {
      sessionFactory.close();
    }
  }

  public static void listerTousPays() throws Exception {
    Session session = sessionFactory.openSession();
    Transaction tx = null;
    try {
      tx = session.beginTransaction();
      List<Pays> listPays = session.createCriteria(Pays.class).list();
      for (Pays pays : listPays) {
        System.out.println("pays : id=" + pays.getId() + " codeIso="
            + pays.getCodeIso() + " nom=" + pays.getNom());
      }
      tx.commit();
    } catch (Exception e) {
      if (tx != null) {
        tx.rollback();
      }
      throw e;
    } finally {
      session.close();
    }
  }
}

Hibernate: select this_.id as id0_0_, this_.code_iso as
code2_0_0_, this_.nom as nom0_0_, this_.FK_DEVISE as FK4_0_0_ from pays this_
pays : id=1 codeIso=FR nom=France
pays : id=2 codeIso=D nom=Allemagne
pays : id=3 codeIso=I nom=Italie
pays : id=4 codeIso=LU nom=Luxembourg
pays : id=5 codeIso=GB nom=Grande Bretagne
pays : id=6 codeIso=US nom=Etats Unis
pays : id=7 codeIso=JA nom=Japon
Hibernate: select this_.id as id0_0_, this_.code_iso as
code2_0_0_, this_.nom as nom0_0_, this_.FK_DEVISE as FK4_0_0_ from pays this_
pays : id=1 codeIso=FR nom=France
pays : id=2 codeIso=D nom=Allemagne
pays : id=3 codeIso=I nom=Italie
pays : id=4 codeIso=LU nom=Luxembourg
pays : id=5 codeIso=GB nom=Grande Bretagne
pays : id=6 codeIso=US nom=Etats Unis
pays : id=7 codeIso=JA nom=Japon
Hibernate: select this_.id as id0_0_, this_.code_iso as code2_0_0_,
this_.nom as nom0_0_, this_.FK_DEVISE as FK4_0_0_ from pays this_
pays : id=1 codeIso=FR nom=France
pays : id=2 codeIso=D nom=Allemagne
pays : id=3 codeIso=I nom=Italie
pays : id=4 codeIso=LU nom=Luxembourg
pays : id=5 codeIso=GB nom=Grande Bretagne
pays : id=6 codeIso=US nom=Etats Unis
pays : id=7 codeIso=JA nom=Japon\n

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration SYSTEM 
"http://hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <!-- ...  -->
    <!-- Cache de second niveau activé avec ehcache  -->
    <property name="hibernate.cache.region.factory_class">
      org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory</property>
    <!-- Activation du cache des requêtes  -->
    <property name="hibernate.cache.use_query_cache">true</property>
    <!-- ...  -->
  </session-factory>
</hibernate-configuration>

  public static void listerTousPays() throws Exception {
    Session session = sessionFactory.openSession();
    Transaction tx = null;
    try {
      tx = session.beginTransaction();
      List<Pays> listPays = session.createCriteria(Pays.class)
        .setCacheable(true).list();
      for (Pays pays : listPays) {
        System.out.println("pays : id=" + pays.getId() + " codeIso="
            + pays.getCodeIso() + " nom=" + pays.getNom());
      }
      tx.commit();
    } catch (Exception e) {
      if (tx != null) {
        tx.rollback();
      }
      throw e;
    } finally {
      session.close();
    }
  }

Hibernate: select pays0_.id as id0_, pays0_.code_iso as code2_0_,
pays0_.nom as nom0_, pays0_.FK_DEVISE as FK4_0_ from pays pays0_
pays : id=1 codeIso=FR nom=France
pays : id=2 codeIso=D nom=Allemagne
pays : id=3 codeIso=I nom=Italie
pays : id=4 codeIso=LU nom=Luxembourg
pays : id=5 codeIso=GB nom=Grande Bretagne
pays : id=6 codeIso=US nom=Etats Unis
pays : id=7 codeIso=JA nom=Japon
pays : id=1 codeIso=FR nom=France
pays : id=2 codeIso=D nom=Allemagne
pays : id=3 codeIso=I nom=Italie
pays : id=4 codeIso=LU nom=Luxembourg
pays : id=5 codeIso=GB nom=Grande Bretagne
pays : id=6 codeIso=US nom=Etats Unis
pays : id=7 codeIso=JA nom=Japon
pays : id=1 codeIso=FR nom=France
pays : id=2 codeIso=D nom=Allemagne
pays : id=3 codeIso=I nom=Italie
pays : id=4 codeIso=LU nom=Luxembourg
pays : id=5 codeIso=GB nom=Grande Bretagne
pays : id=6 codeIso=US nom=Etats Unis
pays : id=7 codeIso=JA nom=Japon\n

  public static void listerTousPays() throws Exception {
    Session session = sessionFactory.openSession();
    Transaction tx = null;
    try {
      tx = session.beginTransaction();
      Query query = session.createQuery("from Pays").setCacheable(true);
      List<Pays> listPays = query.list();
      for (Pays pays : listPays) {
        System.out.println("pays : id=" + pays.getId() + " codeIso="
            + pays.getCodeIso() + " nom=" + pays.getNom());
      }
      tx.commit();
    } catch (Exception e) {
      if (tx != null) {
        tx.rollback();
      }
      throw e;
    } finally {
      session.close();
    }
  }

Hibernate:
select pays0_.id as id0_, pays0_.code_iso as code2_0_, pays0_.nom as nom0_,
pays0_.FK_DEVISE as FK4_0_ from pays pays0_
pays : id=1 codeIso=FR nom=France
pays : id=2 codeIso=D nom=Allemagne
pays : id=3 codeIso=I nom=Italie
pays : id=4 codeIso=LU nom=Luxembourg
pays : id=5 codeIso=GB nom=Grande Bretagne
pays : id=6 codeIso=US nom=Etats Unis
pays : id=7 codeIso=JA nom=Japon
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
pays : id=1 codeIso=FR nom=France
pays : id=2 codeIso=D nom=Allemagne
pays : id=3 codeIso=I nom=Italie
pays : id=4 codeIso=LU nom=Luxembourg
pays : id=5 codeIso=GB nom=Grande Bretagne
pays : id=6 codeIso=US nom=Etats Unis
pays : id=7 codeIso=JA nom=Japon
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
Hibernate: select pays0_.id as id0_0_, pays0_.code_iso as
code2_0_0_, pays0_.nom as nom0_0_, pays0_.FK_DEVISE as FK4_0_0_ from pays
pays0_ where pays0_.id=?
pays : id=1 codeIso=FR nom=France
pays : id=2 codeIso=D nom=Allemagne
pays : id=3 codeIso=I nom=Italie
pays : id=4 codeIso=LU nom=Luxembourg
pays : id=5 codeIso=GB nom=Grande Bretagne
pays : id=6 codeIso=US nom=Etats Unis
pays : id=7 codeIso=JA nom=Japon\n

      Query query = session.createQuery("from Pays").setCacheable(true)
        .setCacheRegion("query.pays");
      List<Pays> listPays = query.list();

Map<String, CollectionMetadata> collectionMetadatas = 
  sessionFactory.getAllCollectionMetadata();
for (String nom : collectionMetadatas.keySet()) {
  sessionFactory.evictCollection(nom);
}

Map<String, ClassMetadata> classMetadatas = sessionFactory.getAllClassMetadata();
for (String nom : classMetadatas.keySet()) {
  sessionFactory.evictEntity(nom);
}
     
sessionFactory.evictQueries();

Cache cache = sessionFactory.getCache();
     
System.out.println(cache.containsEntity(Pays.class, 2));
     
Cache.evictEntity(Pays.class,2);

  <logger name="org.hibernate.cache">
    <level value="DEBUG" />
  </logger>

<prop key="hibernate.generate_statistics">true</prop>\n

Statistics statistics = sessionFactory.getStatistics();
statistics.setStatisticsEnabled(true);