springboot java mysql syntax error at parameter

Question

I have this application, java spring boot and mysql db. When i try to run the following query, i get this error. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'email ='[email protected]'' at line 1

Does anyone know know why?

    @Query(value = "SELECT voucher_code FROM voucher INNER JOIN "
        + "offer ON offer.name = voucher.offer "
        + " email =:email", nativeQuery = true)
     List<Voucher> getVouchers(@Param("email") String email);

Shouldn't there be an "AND" before email =?

ahwayakchih
– ahwayakchih

2019-10-11 04:23:46 +00:00
Commented Oct 11, 2019 at 4:23 — ahwayakchih
– ahwayakchih, Commented Oct 11, 2019 at 4:23

Islingre · Accepted Answer · 2019-10-11 00:37:09Z

3

You are missing something between the two conditions offer.name = voucher.offer and email =:email, probably a WHERE, perhaps an AND/OR. I guess you wanted this:

@Query(value = "SELECT voucher_code FROM voucher INNER JOIN "
    + "offer ON offer.name = voucher.offer "
    + "WHERE email =:email", nativeQuery = true)
List<Voucher> getVouchers(@Param("email") String email);

answered Oct 11, 2019 at 0:37

Islingre

2,37810 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

springboot java mysql syntax error at parameter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related