spring boot, jpa, custom query(LOAD), upload csv to mysql

Question

is it possible?? that

public interface TestRepository extends JpaRepository<Test, Long> {
    @Query("LOAD DATA LOCAL FILE ?1 INTO ......")
    public void loadCsv(String filePath);
}

because I have to move a lot of data(1M~ rows) to mysql table.

I found some ways for moving data and I am sure LOAD query is fastest. if any guys have any way for solving this problem, please give me advice!

thanks. :)

I also got the same issue. I tried doing the following: @Query (value="LOAD DATA LOCAL INFILE 'C:/Users/tester/Documents/transaction_data.txt' INTO TABLE tbl_fin FIELDS TERMINATED BY ',' IGNORE 1 LINES", nativeQuery = true) public void bulkLoadData(); However I get the following error. java.sql.SQLException: ResultSet is from UPDATE. No Data. Looking this error up on google, forums have said that this is because the query is not returning data and it should be placed in a stored procedur but MySQL does not allow LOAD DATA commands in a stored procedure. Any thoughts? — rm12345
– rm12345, Commented Mar 12, 2018 at 14:19
@Krish you can see my solution on the following link: stackoverflow.com/questions/49209785/… — rm12345
– rm12345, Commented Apr 23, 2019 at 21:30

nikli · Accepted Answer · 2020-06-25 07:16:10Z

0

We need to pass the location of the file on DB server for below query, not the application server. @Query("LOAD DATA LOCAL FILE ?1 INTO ......")

edited Jun 25, 2020 at 7:16

nikli

2,3893 gold badges25 silver badges42 bronze badges

answered Jun 25, 2020 at 5:11

yasin syed

11 bronze badge

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

1 Comment

Yunnosch Over a year ago

This is too short. Please elaborate how this solves the problem described in the question at the top of this page.

Collectives™ on Stack Overflow

spring boot, jpa, custom query(LOAD), upload csv to mysql

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related