Spring JPA @Param of filename for postgres COPY

Question

I have the following interface which is connected to a PostgreSQL database:

public interface ExampleDAO extends JpaRepository<Example, Integer>
{
    @Modifying
    @Query(value="COPY my_table FROM :filename CSV HEADER", nativeQuery=true)
    public int copyMyTable(@Param("filename") String filename);
}

But when I run it I get

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

I remove the @Param and hardcode the filename in and it works fine. The filename passed is:

copyMyTable("C:\\path\\to\\my\\file.csv");

I am totally at a loss on this one!

Jens Schauder · Accepted Answer · 2018-12-10 05:59:46Z

2

Judging from this thread Postgres doesn't support bind parameters in this kind of statement.

answered Dec 10, 2018 at 5:59

Jens Schauder

82.7k35 gold badges199 silver badges379 bronze badges

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

1 Comment

Kevin Orriss Over a year ago

Thank you for finding the clarity on this! I ended up reading the file in Java line by line and doing the inserts/updates via JPA save function, the file is less than 100 lines so performance is no issue.

Collectives™ on Stack Overflow

Spring JPA @Param of filename for postgres COPY

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related