存储库中按方法名称进行的 Spring 数据 JPA 查询无效.如何在涉及此类 AND 条件的情况下检索对象列表?

Question

我正在研究一个涉及休眠和 Spring Data JPA 的 Spring Boot 项目，我在尝试使用按方法名称样式查询实现查询时遇到了以下问题。

我试着详细解释我的情况：

我有一个名为TransactionStatusLog的主实体类：

@Entity
@Table(name = "transaction_status_log")
@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
@JsonIgnoreProperties({"hibernateLazyInitializer", "handler"})
public class TransactionStatusLog {

@Id
@Column(name = "id")
@GeneratedValue(strategy=GenerationType.IDENTITY)
private int id;

@Column(name = "reason")
private String reason;

@Column(name = "is_active")
Boolean isActive;

@Column(name = "created_at",columnDefinition="TIMESTAMP DEFAULT CURRENT_TIMESTAMP")
@Temporal(TemporalType.TIMESTAMP)
private Date createdAt;


@ManyToOne
@EqualsAndHashCode.Exclude          // Needed by Lombock in "Many To One" relathionship to avoid error
@JoinColumn(name = "transaction_id_fk", referencedColumnName = "id")
private TransactionLog transactionLog;


@ManyToOne
@EqualsAndHashCode.Exclude          // Needed by Lombock in "Many To One" relathionship to avoid error
@JoinColumn(name = "transaction_status_type_id_fk", referencedColumnName = "id")
private TransactionStatusType transactionStatusType;


// The admin that changes the status:
@OneToOne
@EqualsAndHashCode.Exclude          // Needed by Lombock in "Many To One" relathionship to avoid error
@JoinColumn(name = "user_id_fk", referencedColumnName = "id")
private User user;          

}

如您所见，它包含以下多对一关系：

@ManyToOne
@EqualsAndHashCode.Exclude          // Needed by Lombock in "Many To One" relathionship to avoid error
@JoinColumn(name = "transaction_id_fk", referencedColumnName = "id")
private TransactionLog transactionLog;

在事务日志实体类代码之后：

@Entity
@Table(name = "transaction")
@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
@JsonIgnoreProperties({"hibernateLazyInitializer", "handler"})
public class TransactionLog implements Serializable {
@Id
@Column(name = "id")
@GeneratedValue(strategy=GenerationType.IDENTITY)
private int id;
@ManyToOne
@EqualsAndHashCode.Exclude          // Needed by Lombock in "Many To One" relathionship to avoid error
@JoinColumn(name = "source_user_fk", referencedColumnName = "id")
//@JsonManagedReference(value = "sourceUser")
private User sourceUser;
@ManyToOne
@EqualsAndHashCode.Exclude          // Needed by Lombock in "Many To One" relathionship to avoid error
@JoinColumn(name = "destination_user_fk", referencedColumnName = "id")
private User destinationUser;
@ManyToOne
@EqualsAndHashCode.Exclude          // Needed by Lombock in "Many To One" relathionship to avoid error
@JoinColumn(name = "source_wallet_fk", referencedColumnName = "id")
private Wallet sourceWallet;
@ManyToOne
@EqualsAndHashCode.Exclude          // Needed by Lombock in "Many To One" relathionship to avoid error
@JoinColumn(name = "destination_wallet_fk", referencedColumnName = "id")
private Wallet destinationWallet;
@Column(name = "notes")
private String notes;

@Column(name = "timestamp",columnDefinition="TIMESTAMP DEFAULT CURRENT_TIMESTAMP")
@Temporal(TemporalType.TIMESTAMP)
private Date timestamp;

@Column(name = "amount")
private BigDecimal amount;

@ManyToOne
@EqualsAndHashCode.Exclude          // Needed by Lombock in "Many To One" relathionship to avoid error
@JoinColumn(name = "log_type_fk", referencedColumnName = "id")
//@Column(name = "log_type_fk")
private LogType logType;

@ManyToOne
@EqualsAndHashCode.Exclude          // Needed by Lombock in "Many To One" relathionship to avoid error
@JoinColumn(name = "fk_network", referencedColumnName = "id")
private Network network;
@ManyToOne
@EqualsAndHashCode.Exclude          // Needed by Lombock in "Many To One" relathionship to avoid error
@JoinColumn(name = "fk_chain", referencedColumnName = "id")
private Chain chain;
}

然后我有这个存储库接口，它适用于我的主TransactionStatusLog实体类。

public interface TransactionStatusLogRepository extends JpaRepository<TransactionStatusLog, Integer>, JpaSpecificationExecutor {
TransactionStatusLog findById(String id);

List<TransactionStatusLog> findByTransactionLog_Id(Integer transactionId);

List<TransactionStatusLog> findByIsActiveAndTransactionLog_Id(Integer transactionId);

我创建了最后一个方法定义：

List<TransactionStatusLog> findByIsActiveAndTransactionLog_Id(Integer transactionId);

尝试实现以下查询：查找所有具有的事务状态日志：

值

• 为 true的布尔值为活动字段
• 并具有具有特定 ID 值的事务日志(第二个实体类)。

最后，我创建了这个 JUnit 测试方法来测试这个存储库查询：

@Test
@Order(3)
@Transactional
public void findByIsActiveAndTransactionLog_IdTest() {
List<TransactionStatusLog> result = this.transactionStatusLogRepository.findByIsActiveAndTransactionLog_Id(37);

assertTrue(result.size() == 1, "The result contains 1 tactive transaction status changes related to the transaction having ID: 37");
}

问题是运行这个测试方法(它没有启动，因为似乎我的 Spring Data JPA 按名称方法定义查询是错误的)我在堆栈跟踪中获得了此异常：

Caused by: org.springframework.data.repository.query.QueryCreationException: Could not create query for public abstract java.util.List com.easydefi.users.repository.TransactionStatusLogRepository.findByIsActiveAndTransactionLog_Id(java.lang.Integer)! Reason: Failed to create query for method public abstract java.util.List 

我的代码出了什么问题？我该如何尝试修复它？(如果按名称查询方法对于这样的用例来说太复杂，则也使用 JPQL)

Answer 1

List<TransactionStatusLog> findByIsActiveAndTransactionLog_Id(Integer transactionId); 

应接受两个参数。一个用于isActive，一个用于transactionLogId.

正确的形式是：

List<TransactionStatusLog> findByIsActiveAndTransactionLog_Id(boolean isActive, Integer transactionId); 

然后致电：

List<TransactionStatusLog> result = transactionStatusLogRepository.findByIsActiveAndTransactionLog_Id(true, 37);

Answer 2

您可以通过添加"True"并删除下划线重试吗？应该看起来像->

List<TransactionStatusLog> result = this.transactionStatusLogRepository.findByIsActiveTrueAndTransactionLogId(37);