CODEWITHSUNDEEP
sqloracle-databasehibernatejpa
Anke
Anke

Reputation: 8573

How can I execute a native SQL script in JPA/Hibernate?

I have a SQL script with database dump. How can I execute it using Hibernate's EntityManager?

I tried it this way:

EntityManager manager = getEntityManager(); 
Query q = manager.createNativeQuery(sqlScript);
q.executeUpdate();

but it works only when sqlScript contains a single SQL query, while I need to run multiple inserts and other complex stuff.

RDBMS: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

Upvotes: 46

Views: 58517

Answers (1)

hkutluay
hkutluay

Reputation: 6944

Wrap your query with begin end block. Like 

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

Upvotes: 71

Related Questions