java - 创建自定义查询方法时在 JPA 中创建查询异常

Question

JPA 存储库抛出自定义查询方法错误:

org.h2.jdbc.JdbcSQLException: Table "NBMRBANKDTLSENTITY" not found; SQL statement:
select NBMRBankDtlsEntity from NBMRBankDtlsEntity  where NBMRBankDtlsEntity.ipphId = ? [42102-191]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)

类别:

@Repository
public interface NBMRBankDtlsRepository extends JpaRepository<NBMRBankDtlsEntity, Long> {

    @Query(value ="select n from NBMRBankDtlsEntity n  where n.ipphId = :ipphId",nativeQuery = true)
    Optional<NBMRBankDtlsEntity> findByIPPHId(@Param("ipphId") Long ipphId);

}

Answer 1

错误消息告诉您:未找到表“NBMRBANKDTLSENTITY”。因此它可能不存在。要解决此问题，您必须通过脚本或通过 hibernates schema creation 手动创建表。功能。