0

I use @query to Insert X,Y to Geometry in PostgreSQL.

@Modifying
@Query(value = " insert into mypoints (name,geom) values (:name,SRID=4326;POINT(:x :y))", nativeQuery = true)
@Transactional
void addSPCTY(@Param("name") String ten,@Param("x") String x,@Param("y") String y);

Right now it ends up with an error

Error in Java: org.postgresql.util.PSQLException: ERROR: syntax error near ;

Taras
  • 32,823
  • 4
  • 66
  • 137

0 Answers0