2

When assign select JPA It gives an error as bellow. What is the issue?

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.finance.resources.StudentForBankStatement(s.admission_no,s.first' at line 1`

Query

@Query( value = "select NEW com.finance.resources.StudentForBankStatement(s.admission_no,s.first_name,s.last_name) from student s where branch_id = ?1", nativeQuery = true ) List<StudentForBankStatement> getStudentByClassIdBranchId( long branchId );

Helper Class

@Data @AllArgsConstructor @NoArgsConstructor public class StudentForBankStatement { private String AdmissionNo; private String firstName; private String lastName; }
Improve this question
2

1 Answer 1

Reset to default
2

In your query you have nativeQuery=true which this is not, thus the error. This should be JPQL. Fix your query to something like:

@Query( value = "select NEW com.finance.resources.StudentForBankStatement(s.admissionNo, s.firstName, s.lastName) from Student s where s.branchId = :1")
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.