QueryDSL排序不适用于Spring Data [英] QueryDSL sorting not working with Spring Data
问题描述
我目前在Spring Data Commons 1.9.1和Spring JPA 1.7.1中使用 JpaSort
。我需要使用QueryDSL,因为 JPA不允许定义空值的排序。
这是我的Repository
public interface DatasheetRepository extends JpaRepository< Datasheet,Long>,JpaSpecificationExecutor<数据库>
我在我的控制器中执行此操作:
页面<数据表> page = m_datasheetRepository.findAll(new PageRequest(pageNumber,pageSize,createSortForDatasheets()));
这就是我使用JPA的原因:
< pre
$首先对组件类型名称进行排序,然后对子类型名称
返回新的JpaSort(JpaSort。路径(Datasheet_.componentSubtype).dot(ComponentSubtype_.componentType).dot(ComponentType_.name))
.and(new JpaSort(JpaSort.path(Datasheet_.componentSubtype).dot(ComponentSubtype_.name)));
}
这就是我将它改为QueryDSL的原因:
private Sort createSortForDatasheets()
{
return new QSort(new OrderSpecifier<>(Order.ASC,QDatasheet.dat sheet (新的OrderSpecifier<>(Order.ASC,QDatasheet.datasheet.componentSubtype.name,OrderSpecifier.NullHandling.NullsLast));
}
然而,似乎没有东西被排序。我已经启用了DEBUG日志记录,并且我看到了这一点:
渲染标准查询 - >从数据表中选择generatedAlias0 as generatedAlias0 order by generatedAlias0.name asc,generatedAlias0.name asc
如果我更改它到:
private排序createSortForDatasheets()
{
返回新的QSort(QDatasheet.datasheet.name。降序());
}
然后按相反顺序排列我的数据表
这是我的数据表实体:
@实体
公共类数据表
{
// ------------------------------ FIELDS ------------------------------
@Id
@GeneratedValue
私人长ID;
@Column(unique = true)
私有字符串名称;
私有字符串描述;
@ManyToOne
私有ComponentSubtype componentSubtype;
@OneToMany(cascade = CascadeType.REMOVE)
private Set< DatasheetDocument>文件;
这就是ComponentSubtype:
<$
@GeneratedValue()
private long id; pre $ @Entity
public class ComponentSubtype
{
@Id
@GeneratedValue
私人字符串名称;
$ b @ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name =parent_id,insertable = false,updatable = false)
私有ComponentType componentType;
更新:
createSortForDatasheets
至此:
private Sort createSortForDatasheets()
{
return new QSort(new OrderSpecifier<>(Order.ASC,QComponentType.componentType.id,OrderSpecifier.NullHandling.NullsLast));
}
然后,记录显示:
呈现条件查询 - >从数据表中选择generatedAlias0 as generatedAlias0 order by generatedAlias0.id asc
注意数据表而不是ComponentType的id。
它看起来像Spring Data bug。我为它提出了一个问题 https://jira.spring.io/browse/DATACMNS-621
I am currently using JpaSort
with Spring Data commons 1.9.1 and Spring JPA 1.7.1. I need to use QueryDSL because JPA does not allow defining the sort for null values.
This is my Repository
public interface DatasheetRepository extends JpaRepository<Datasheet, Long>, JpaSpecificationExecutor<Datasheet>
I am doing this in my Controller:
Page<Datasheet> page = m_datasheetRepository.findAll( new PageRequest( pageNumber, pageSize, createSortForDatasheets() ) );
This is what I had with JPA:
private Sort createSortForDatasheets()
{
// First sort on the component type name, then on the subtype name
return new JpaSort( JpaSort.path( Datasheet_.componentSubtype ).dot( ComponentSubtype_.componentType ).dot( ComponentType_.name ) )
.and( new JpaSort( JpaSort.path( Datasheet_.componentSubtype ).dot( ComponentSubtype_.name ) ) );
}
This is what I have changed it to for QueryDSL:
private Sort createSortForDatasheets()
{
return new QSort( new OrderSpecifier<>( Order.ASC, QDatasheet.datasheet.componentSubtype.componentType.name,OrderSpecifier.NullHandling.NullsLast ) )
.and( new OrderSpecifier<>( Order.ASC, QDatasheet.datasheet.componentSubtype.name, OrderSpecifier.NullHandling.NullsLast ) );
}
However, nothing seems to get sorted. I have enabled DEBUG logging and I see this:
Rendered criteria query -> select generatedAlias0 from Datasheet as generatedAlias0 order by generatedAlias0.name asc, generatedAlias0.name asc
If I change it to:
private Sort createSortForDatasheets()
{
return new QSort(QDatasheet.datasheet.name.desc());
}
Then the sorting by the name of my "Datasheet" type in reverse order does work.
This is my "Datasheet" entity:
@Entity
public class Datasheet
{
// ------------------------------ FIELDS ------------------------------
@Id
@GeneratedValue
private long id;
@Column(unique = true)
private String name;
private String description;
@ManyToOne
private ComponentSubtype componentSubtype;
@OneToMany(cascade = CascadeType.REMOVE)
private Set<DatasheetDocument> documents;
And this is "ComponentSubtype":
@Entity
public class ComponentSubtype
{
@Id
@GeneratedValue()
private long id;
private String name;
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "parent_id",insertable=false,updatable=false)
private ComponentType componentType;
UPDATE:
If I change the createSortForDatasheets
to this:
private Sort createSortForDatasheets()
{
return new QSort( new OrderSpecifier<>( Order.ASC, QComponentType.componentType.id, OrderSpecifier.NullHandling.NullsLast ) );
}
Then, the logging shows:
Rendered criteria query -> select generatedAlias0 from Datasheet as generatedAlias0 order by generatedAlias0.id asc
Notice how the id of the "Datasheet" is used, and not the id of "ComponentType".
It looks like Spring Data bug. I filed an issue for it https://jira.spring.io/browse/DATACMNS-621
这篇关于QueryDSL排序不适用于Spring Data的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!