Вызов функции Postgresql из Java с использованием аннотации JDBI ⇐ JAVA
-
Anonymous
Вызов функции Postgresql из Java с использованием аннотации JDBI
IM trying to call postgre sql function from java but im getting @sqlcall methods may only return null or Outparameters at present
This Function return list with same id.
`CREATE FUNCTION get_student(id IN INT) AS $$ BEGIN return query select * from student where student_id=id; END; $$ LANGUAGE plpgsql```` java class `@SqlCall("{:result = call get_student(:studentId)}") @OutParameter(name="result",sqlType=Types.JAVA_OBJECT) OutParameters getStudents(@Bind("studentId") int id);` there could be duplicate students and im trying to get all the students with same id and im getting this error "@sqlcall methods may only return null or Outparameters at present" i tried using @sqlQuery but still facing the same issue.Can anyone help me.Thanks
Источник: https://stackoverflow.com/questions/780 ... annotation
IM trying to call postgre sql function from java but im getting @sqlcall methods may only return null or Outparameters at present
This Function return list with same id.
`CREATE FUNCTION get_student(id IN INT) AS $$ BEGIN return query select * from student where student_id=id; END; $$ LANGUAGE plpgsql```` java class `@SqlCall("{:result = call get_student(:studentId)}") @OutParameter(name="result",sqlType=Types.JAVA_OBJECT) OutParameters getStudents(@Bind("studentId") int id);` there could be duplicate students and im trying to get all the students with same id and im getting this error "@sqlcall methods may only return null or Outparameters at present" i tried using @sqlQuery but still facing the same issue.Can anyone help me.Thanks
Источник: https://stackoverflow.com/questions/780 ... annotation
