How to execute sql query from file in spring boot?

Question

I am running a spring boot application where I have to run SQL statements that I have written .sql file is saved in the resource directory.

I don't want to run the script on the application startup. I have scheduler which run every 5 hour which does this job

Here is how my folder structure looks like

How can I pick those SQL files in my service class and execute those statements written in the file?

I am very new in spring boot I have used spring data JPA but never have executed SQL statements from the file. How to use Spring JDBC to do that?

How can I load these files in-service classes and execute them?

Check this link How to run SQL scripts and get data on application startup? for more detail. — Harrison Phan
– Harrison Phan, Commented Apr 2, 2022 at 13:00
@HarrisonPhan I already have looked at all the example but I don't want to run on application startup — Learners
– Learners, Commented Apr 2, 2022 at 13:02
docs.spring.io/spring-framework/docs/current/javadoc-api/org/… — user14687465
– user14687465, Commented Apr 2, 2022 at 13:15

score 0 · Accepted Answer · 2022-04-02 13:33:38Z

0

Try this:

import org.springframework.jdbc.datasource.init.ScriptUtils;
import org.springframework.core.io.ClassPathResource;

ScriptUtils.executeSqlScript(connection, new ClassPathResource("sql/info/newInfo.sql"));

Reference.

edited Apr 2, 2022 at 13:33

answered Apr 2, 2022 at 13:21

user14687465

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

3 Comments

Learners Over a year ago

How can i use this entityManager.createNativeQuery("sql2").executeUpdate();

user14687465 Over a year ago

@Learners Use it according to where you found it from, if it doesn't work, try to fix it, if it doesn't get fixed, try something else. As simple as that :D

Learners Over a year ago

I was more looking to use Spring Data JPA to execute those queries present inside the SQL file. As there are multiple queries present inside that SQL file

Collectives™ on Stack Overflow

How to execute sql query from file in spring boot?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related