Discussion :

[thierryler]

Salut à tous,

J'ai une requête qui me permet de récupérer un ensemble d'éléments en base (JPA/Hibernate) :

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
 
public List<Content> findContentsOfChannelFetchTranslations(final String channelId, final LangEnum lang,final int first, final int pageSize) {
 
	final String sql = "SELECT c FROM ChannelContentAssociation aso " +
			" INNER JOIN aso.content c " +
			" LEFT JOIN FETCH c.translations ct  " +
			" WHERE aso.channelId = :channelId " +
			" AND ct.lang = :lang " +
			" ORDER BY c.pubDate DESC ";
 
	final List<Content> contents = em.createQuery(sql, Content.class) /**/
                        .setParameter("channelId", channelId) /**/
			.setParameter("lang", lang) /**/
                        .setFirstResult(first) /**/
			.setMaxResults(pageSize) /**/
			.getResultList();
 
	return contents;
}

Comme vous pouvez le voir, dans cette requête, je limite le nombre de résultats.

En parallèle, j'ai besoin de connaitre le nombre total d'éléments qui correspondent à mes critères (pour alimenter un paginator).

Instinctivement j'ai juste ajouté COUNT(c) et sa variante COUNT(c.id) par désespoir :

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
 
public Integer findNumberOfContentsByChannel(final String channelId, final LangEnum lang) {
	LOGGER.debug("findNumberOfContentsByChannel channelId {}", channelId);
 
	final String sql = "SELECT COUNT(c.id) FROM ChannelContentAssociation aso " +
			" INNER JOIN aso.content c " +
			" LEFT JOIN FETCH c.translations ct  " +
			" WHERE aso.channelId = :channelId " +
			" AND ct.lang = :lang " ;
 
	final Integer nb = em.createQuery(sql, Integer.class) /**/
                        .setParameter("channelId", channelId) /**/
			.setParameter("lang", lang) /**/
			.getSingleResult();
 
	return nb;

Mais je me mange une grosse exception :

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
 
18:11:09,599 DEBUG: com.masociete.extragroup.dao.ContentDao - findNumberOfContentsByChannel channelId 994a17cccd357110VgnVCM1000000100007f____
22 oct. 2012 18:11:09 org.apache.catalina.core.ApplicationDispatcher invoke
GRAVE: "Servlet.service()" pour la servlet Faces Servlet a lancé une exception
org.hibernate.QueryException: query specified join fetching, but the owner of the fetched association was not present in the select list [FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=ct,role=com.masociete.extragroup.model.content.Content.translations,tableName=CDC_CONTENT_TRANSLATIONS,tableAlias=translatio2_,origin=SIG_VIEW_CONTENT content1_,columns={content1_.KEYSTRING1 ,className=com.masociete.extragroup.model.content.ContentTranslation}}] [SELECT COUNT(c.id) FROM com.masociete.extragroup.model.content.ChannelContentAssociation aso  INNER JOIN aso.content c  LEFT JOIN FETCH c.translations ct   WHERE aso.channelId = :channelId  AND ct.lang = :lang ]
	at org.hibernate.hql.internal.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:204)
	at org.hibernate.hql.internal.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:861)
	at org.hibernate.hql.internal.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:651)
 
...
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)
22 oct. 2012 18:11:09 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() for servlet [default] in context with path [/C4ExtraGroupWeb] threw exception [Exception occurred while processing <channel2:#{prettyUrlManager.processChannel}> java.lang.IllegalArgumentException: org.hibernate.QueryException: query specified join fetching, but the owner of the fetched association was not present in the select list [FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=ct,role=com.masociete.extragroup.model.content.Content.translations,tableName=CDC_CONTENT_TRANSLATIONS,tableAlias=translatio2_,origin=SIG_VIEW_CONTENT content1_,columns={content1_.KEYSTRING1 ,className=com.masociete.extragroup.model.content.ContentTranslation}}] [SELECT COUNT(c.id) FROM com.masociete.extragroup.model.content.ChannelContentAssociation aso  INNER JOIN aso.content c  LEFT JOIN FETCH c.translations ct   WHERE aso.channelId = :channelId  AND ct.lang = :lang ]] with root cause
org.hibernate.QueryException: query specified join fetching, but the owner of the fetched association was not present in the select list [FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=ct,role=com.masociete.extragroup.model.content.Content.translations,tableName=CDC_CONTENT_TRANSLATIONS,tableAlias=translatio2_,origin=SIG_VIEW_CONTENT content1_,columns={content1_.KEYSTRING1 ,className=com.masociete.extragroup.model.content.ContentTranslation}}] [SELECT COUNT(c.id) FROM com.masociete.extragroup.model.content.ChannelContentAssociation aso  INNER JOIN aso.content c  LEFT JOIN FETCH c.translations ct   WHERE aso.channelId = :channelId  AND ct.lang = :lang ]
	at org.hibernate.hql.internal.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:204)
	at org.hibernate.hql.internal.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:861)
	at org.hibernate.hql.internal.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:651)
	at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:651)
...
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:662)
22 oct. 2012 18:11:32 org.apache.catalina.core.StandardServer await

Heu, j'avoue que je suis une buse en JPA : j'ai donc besoin d'aide...

Merci d'avance.

[thierryler]

En fait, il suffisait juste d'enlever le FETCH...