Creating query exception in JPA while creting custom query method

Question

JPA repository throwing Error for custom query method:

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)

Class :

@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);

}

score 0 · Answer 1 · answered Apr 29 '20 at 07:25

0

The error message tells you: Table "NBMRBANKDTLSENTITY" not found. Therefore it probably doesn't exist. To fix this you'll have to create the table, manually through a script or through hibernates schema creation feature.

answered Apr 29 '20 at 07:25

Jens Schauder

77,657
34
181
348

score 0 · Accepted Answer · answered Apr 30 '20 at 06:37

I am already creating a table also inserting the record, After that only i am calling this custom query method.

I have found the issue as i am using nativeQuery = true so it is expecting normal sql query to query DB directly not the java query which is creating issue. Now after changing below it works fine ,

@Query(value = "SELECT * from NB_MR_BANK_DTLS WHERE IPPH_ID = :ipphId",nativeQuery = true)

For java query we can use directly as it internally converts to SQL while querying the DB,

@Query(value = "select p from NBMRBankDtlsEntity p WHERE p.ipphId = :ipphId")

Creating query exception in JPA while creting custom query method

2 Answers2