Clé composite : souci mapping

**VanFanel** · 27/07/2010, 11h34

Hello,

Je débute sur Hibernate, et le projet a un schéma de base complexe

Env.
Base Mysql
Développement sous Eclipse avec Spring, Hibernate

J'ai l'erreur suivante : FATAL (ThesaurusTreeDaoImpl.java:64) Erreur lors du chargement du site 1
java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: ThesaurusTree is not mapped [SELECT tt FROM ThesaurusTree tt WHERE tt.id.site.id = :siteId]

Auriez vous une petite idée de la cause ?? Merci par avance.

1°) Définition du modèle
Classe pour la clé composite

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
 
package com.leguide.thesaurus.tree.model;
...
 
@Embeddable
public class ThesaurusTreePK implements Serializable{
 
	private static final long serialVersionUID = 179022443765548126L;
 
	private Integer idThesaurus;
	private Site site;
 
	@Column(name = "id_thesaurus", nullable = false)	
	public Integer getIdThesaurus() {
		return idThesaurus;
	}
	public void setIdThesaurus(Integer idThesaurus) {
		this.idThesaurus = idThesaurus;
	}
 
 
	@ManyToOne(targetEntity=Site.class)
	@JoinColumn(name = "id_site")
	public Site getSite() {
		return site;
	}
 
	public void setSite(Site site) {
		this.site = site;
	}
 
    @Override
    public boolean equals(Object obj)
    {
 
    	if (this == obj) return true;
    	if ( !(obj instanceof ThesaurusTreePK) ) return false;
    	final ThesaurusTreePK other = (ThesaurusTreePK) obj;
    	if ( !other.getIdThesaurus().equals( getIdThesaurus() ) ) return false;
    	if ( !other.getSite().equals( getSite() ) ) return false;
    	return true;
    }
 
    @Override
    public int hashCode() {
        return super.hashCode();
      }
}

Classe permettant le mapping de la table

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
 
package com.leguide.thesaurus.tree.model;
 
import java.io.Serializable;
 
...
 
@Entity
@Table(name = "lgintegration.tb_thesaurus_tree")
public class ThesaurusTree implements Serializable{
 
	private static final long serialVersionUID = 2839355101257449961L;
 
	@EmbeddedId
	private ThesaurusTreePK id;
 
	private Short left_interval;
	private Short right_interval;
	...
 
	@Id
	@AttributeOverrides( {
		@AttributeOverride(name="idThesaurus", 
		  column=@Column(name="id_thesaurus") ),
		@AttributeOverride(name="site", 
		  column=@Column(name="id_site"))
		})
    public ThesaurusTreePK getThesaurusTreePK() {
		return this.id;
	}
 
    public void setThesaurusTreePK(ThesaurusTreePK thesaurusTreePK) {
		this.id = thesaurusTreePK;
	}
 
	@Column(name = "tht_left_interval")	
	public Short getLeft_interval() {
		return left_interval;
	}
 
	public void setLeft_interval(Short leftInterval) {
		left_interval = leftInterval;
	}
 
	@Column(name = "tht_right_interval")	
	public Short getRight_interval() {
		return right_interval;
	}
 
	public void setRight_interval(Short rightInterval) {
		right_interval = rightInterval;
	}
 
	...
}

Classe "Site" utilisé dans la classe de définition de la clé composite

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
 
package com.leguide.thesaurus.tree.model;
 
...
 
@Entity
@Table(name = "lgintegration.tb_site")
public class Site implements Serializable{
 
	private static final long serialVersionUID = 6685004289144296548L;
 
	private Integer id;
	private String name;
	private String url;
	private String locale;
	private Boolean partner;	
 
	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	@Column(name = "id_site", unique = true, nullable = false)	
	public Integer getId() {
		return id;
	}
 
	public void setId(Integer id) {
		this.id = id;
	}
 
	@Column(name = "tsi_name")
	public String getName() {
		return name;
	}
 
	public void setName(String name) {
		this.name = name;
	}
 
	@Column(name = "tsi_url")
	public String getUrl() {
		return url;
	}
 
	public void setUrl(String url) {
		this.url = url;
	}
 
	@Column(name = "tsi_locale")
	public String getLocale() {
		return locale;
	}
 
	public void setLocale(String locale) {
		this.locale = locale;
	}
 
	@Column(name = "tsi_is_partner")
	public Boolean getPartner() {
		return partner;
	}
 
	public void setPartner(Boolean partner) {
		this.partner = partner;
	}
}

2°) Utilisation

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 
package com.leguide.thesaurus.tree.dao.impl;
 
...
 
@Repository("thesaurusTreeDao")
public class ThesaurusTreeDaoImpl implements ThesaurusTreeDao {
 
	private static final Log logger = LogFactory.getLog(TreeDaoImpl.class);
 
	@PersistenceContext(type=PersistenceContextType.EXTENDED,unitName="tree")
	private EntityManager entityManager;
 
	@SuppressWarnings("unchecked")
	public List<ThesaurusTree> getThesaurusTree(Integer siteId) throws ThesaurusTreeException{
		try {
			Query treeQuery = entityManager.createQuery("SELECT tt FROM ThesaurusTree tt WHERE tt.id.site.id = :siteId");
			treeQuery.setParameter("siteId", siteId);
			List<ThesaurusTree> treeList = treeQuery.getResultList();
			if ( treeList.size() == 0 ) {
				logger.warn("Le site "+siteId+" n'existe pas.");
				throw new ThesaurusTreeException();
			}
			return treeList;	
		} catch (Throwable e) {
			logger.fatal("Erreur lors du chargement du site "+siteId+" ",e);
			throw new ThesaurusTreeException(e);	
		}
	}
}

3°) Service exposé

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
package com.leguide.thesaurus.tree.services.impl;
 
@Service("thesaurusTreeServices")
public class ThesaurusTreeServiceImpl implements ThesaurusTreeServices{
 
	@Autowired
	protected ThesaurusTreeDao thesaurusTreeDao;
 
	public List<Site> getSiteList() throws ThesaurusTreeException {
		return this.thesaurusTreeDao.getSiteList();
	}
 
	public List<ThesaurusTree> getThesaurusTree(Integer siteId) throws ThesaurusTreeException{
		return this.thesaurusTreeDao.getThesaurusTree(siteId);
	}
}

4°) Fichier de test

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
package com.leguide.thesaurus.tree.dao;

import org.junit.Test;
import org.junit.runner.RunWith;
..
import com.leguide.thesaurus.tree.services.ThesaurusTreeServices;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(value = "/leguideThesaurusTreeContext.xml")

public class ThesaurusTreeDaoTest {

@Autowired
public ThesaurusTreeServices thesaurusTreeServices;

@Test
public void getSiteList(){
  int nb = 0;
  int nb2 = 0;		
  Site elem;
  Thesaurus elTh;
		
  try 
   {
/*
   List<Site> laListe = thesaurusTreeServices.getSiteList();
   nb = laListe.size();
   System.out.println("NB site(s) : "+ nb + "\n");
   Iterator i = laListe.iterator();
   while(i.hasNext()){
	elem = (Site)i.next();
	System.out.println( elem.getId()+ " ->" + elem.getName() + "|" + elem.getUrl()+ "|" + elem.getPartner());
  }
*/


  List<ThesaurusTree> thesTreeListe = thesaurusTreeServices.getThesaurusTree(1); 
   nb2 = thesTreeListe.size();
  System.out.println("NB element(s) : "+ nb2 + "\n");
  Iterator j = thesTreeListe.iterator();
  while(j.hasNext()){
    elTh = (Thesaurus)j.next();
    System.out.println( elTh.getId()+ " ->" + elTh.getComment() + "(" + elTh.getCreatDate()+ "," + elTh.getUpdDate()+ ")");
  }
}
 catch (Throwable e) {}
}

}

Annexe
Fichier persistence_tree.xml

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
<?xml version="1.0" encoding="UTF-8"?>
<persistence>
  <persistence-unit name="tree" transaction-type="RESOURCE_LOCAL">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <properties>
      <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver" />
      <property name="hibernate.connection.username" value="xxx" />
      <property name="hibernate.connection.password" value="yyy" />
      <property name="hibernate.connection.url" value="jdbc:mysql://host/schema" />
      <property name="hibernate.dialect" value="org.hibernate.dialect.InformixDialect"/>
      <property name="hibernate.cache.provider_class" value="org.hibernate.cache.NoCacheProvider"/>
      <property name="hibernate.showsql" value="true"/>
      <property name="current_session_context_class" value="thread"/>
      <property name="hibernate.transaction.factory_class" value="org.hibernate.transaction.JDBCTransactionFactory"/>
      <property name="hibernate.cache.use_second_level_cache" value="false"/>
    </properties>
  </persistence-unit>
</persistence>

Fichier de conf.

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
 
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:jee="http://www.springframework.org/schema/jee"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
           http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-3.0.xsd
           http://www.springframework.org/schema/tx 
           http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
           http://www.springframework.org/schema/jee 
           http://www.springframework.org/schema/jee/spring-jee-2.5.xsd">
 
	<context:annotation-config />
	<context:component-scan base-package="com.leguide.thesaurus" />
 
	<tx:annotation-driven transaction-manager="transactionManagerTree"/>
 
	<bean id="entityManagerFactoryTree" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
		<property name="persistenceUnitName" value="tree"/>
		<property name="persistenceUnitManager" ref="persistenceUnitManager"/>
		<property name="jpaVendorAdapter">
			<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
				<property name="database" value="MYSQL" />
				<property name="showSql" value="true" />
				<property name="databasePlatform" value="org.hibernate.dialect.MySQL5Dialect" />
				<property name="generateDdl" value="false" />
			</bean>
		</property>
		<property name="jpaPropertyMap">
			<map>
				<entry key="hibernate.cache.provider_class" value="org.hibernate.cache.EhCacheProvider"/>
				<entry key="hibernate.cache.use_query_cache" value="false"/>
				<entry key="hibernate.cache.use_second_level_cache" value="false"/>
				<entry key="hibernate.archive.autodetection" value="class, hbm" />
				<entry key="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect" />
			</map>
		</property>
	</bean>
 
	<bean id="transactionManagerTree" class="org.springframework.orm.jpa.JpaTransactionManager">
		<property name="entityManagerFactory" ref="entityManagerFactoryTree"/>
	</bean>
 
</beans>

Clé composite : souci mapping

Hibernate Java

Mode arborescent

Discussions similaires

Partager

Partager