Spring Data JPA @Query annotation, nativeQuery = true,

Question

I have problem with my @Repository:

@Repository
public interface RekvZmRepository extends CrudRepository<RekvalZamestn, RekvalZamestnPk> {
@Query(value = "SELECT z.* FROM rek_zm d INNER JOIN proj_a a ON d.id = a.prj_idcislo"
  + "                                   INNER JOIN proj_e e ON a.id = e.id"
  + "                                   INNER JOIN rekv_z z ON d.id = z.id"
  + "WHERE  d.id = ?1 AND a.id = ?2 AND e.id = ?3", nativeQuery = true)
public List<RekvalZamestn> getRekvOsOnDoh(Long dhzmrk, Long prj, Long prje);
}

When I run it, result is:

org.springframework.dao.InvalidDataAccessResourceUsageException: could not
extract ResultSet; SQL [n/a]; nested exception is
org.hibernate.exception.SQLGrammarException: could not extract ResultSet

When I run SQL it works, so for me it looks like problem is not with SQL but with my @Query.

dcsohl · Accepted Answer · 2016-04-05 17:44:44Z

3

Your query, in one-line format (condensing multiple spaces to one space for reasons of, erm, space), equates to

SELECT z.* FROM rek_zm d INNER JOIN proj_a a ON d.id = a.prj_idcislo INNER JOIN proj_e e ON a.id = e.id INNER JOIN rekv_z z ON d.id = z.idWHERE  d.id = ?1 AND a.id = ?2 AND e.id = ?3

If you concatenate all the strings in one line like this, it becomes obvious that you are missing a space before the WHERE clause.

answered Apr 5, 2016 at 17:44

dcsohl

7,4261 gold badge30 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

K139 · Accepted Answer · 2016-04-05 17:36:17Z

0

change SELECT z.* FROM to SELECT z FROM assuming RekvalZamestn class maps to table rekv_z.

answered Apr 5, 2016 at 17:36

K139

3,67915 silver badges17 bronze badges

1 Comment

1ac0 Over a year ago

yes, RekvalZamestn maps to table rekv_z but it's native query. changing z.* to only z doesn't works (tested now).

Collectives™ on Stack Overflow

Spring Data JPA @Query annotation, nativeQuery = true,

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related