How to run SQL script using hibernate

Question

I have a requirement to load and run a sql-script (ReportData_pr.sql) which will create some procedures on start-up and run those procedures.

We are using Spring 4.0.2.RELEASE and hibernate 4.3.5.Final for development.

Is it possible to run the script file by using hibernate. If yes how to do that. If not is there any other work around to achieve my goal.

Thanks

Possible duplicate of stackoverflow.com/questions/14358425/… — OO7
– OO7, Commented Nov 12, 2014 at 5:27
Possible duplicate of How can I execute a native SQL script in JPA/Hibernate? — Gerold Broser
– Gerold Broser, Commented Mar 26, 2017 at 12:11

Aeseir · Accepted Answer · 2014-11-12 04:15:10Z

1

You can run your script using nativequery:

e.g.

EntityManager manager = getEntityManager(); 
Query q = manager.createNativeQuery("BEGIN"+sqlScript+"END;");
q.executeUpdate();

See if that helps

answered Nov 12, 2014 at 4:15

Aeseir

8,58213 gold badges63 silver badges126 bronze badges

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

1 Comment

It might help if you explain what the getEntityManager() method does.