java – 使用Date参数时的Spring Data JPA日期“之间”查询问题

在我的应用程序中,我使用Spring Data和hibernate作为JPA提供程序来持久化和读取数据.

我有顶级实体类：

@Entity
@Getter @Setter
@Table(name = "operation")
@Inheritance(strategy = InheritanCEType.JOINED)
@EqualsAndHashCode(of = {"operationId"})
public abstract class Operation implements serializable {
    public static final int OPERATION_ID_LENGTH = 20;

    @Id
    @column(name = "operation_id",length = OPERATION_ID_LENGTH,nullable = false,columnDeFinition = "char")
    private String operationId;

    @column(name = "operation_type_code")
    @Getter(AccessLevel.NONE)
    @Setter(AccessLevel.NONE)
    private String operationTypeCode;

    @Temporal(TemporalType.timestamp)
    @column(name = "begin_timestamp",nullable = falsE)
    private Date begintimestamp = new Date();

    @Temporal(TemporalType.timestamp)
    @column(name = "end_timestamp")
    private Date endtimestamp;

    @column(name = "operation_number",length = 6,columnDeFinition = "char")
    private String operationnumber;


    @Enumerated(EnumType.StriNG)
    @column(name = "operation_status",length = 32,nullable = falsE)
    private OperationStatus status;

    @manyToOne(optional = falsE)
    @Joincolumn(name = "user_id")
    private User user;

    @manyToOne
    @Joincolumn(name = "terminal_id")
    private Terminal terminal;


    @column(name = "Training_mode",nullable = falsE)
    private Boolean TrainingMode;
}

对于继承的类,我有相应的存储库：

public interface ConcreteOperationRepository extends JpaRepository@H_674_15@deviceid = :deviceid AND o.TrainingMode = :TrainingMode")
    Collectiondeviceid") String deviceid,@Param("TrainingMode") Boolean TrainingModE);
}

我用以下方法进行集成测试：

@transactional
@Test
public void shouldFindoperationByPeriodAndStatusAndWorkstationId() {
    Date from = new Date(Calendar.geTinstance().getTime().getTime());
    List< countrowsforeachtype;="" i++)="" {="" concreteoperationrepository.save(createconcreteoperation(status,terminalid,string.valueof(++id)));="" }="" }="" }="" date="" to="new" date(calendar.getinstance().gettime().gettime());="" for="" (string="" terminalid="" :="" terminalids)="" {="" for="" (operationstatus="" status="" :="" typeforuse)="" {="">

但是由于结果为空而我使用MysqL数据库时此测试失败(但是当我切换到HsqlDB时通过)

此外,如果我在测试开始时将延迟“Thread.sleep(1000)”延迟一秒,就在第一行之后,则此测试通过.

当我从Hibernate日志执行sql时,它给了我正确的结果.我的代码出了什么问题？