How to read . sql file with Java

Question

I have a complex query in Mysql with sub-select and joins.

I would like to read this script through a file .sql using the language of JPA/Hibernate (JPQL or HQL), for example getSession().createQuery(arquivo.sql);.

Or another way that allows me to read the document to be failed in the repository. This is possible?

Answer 1

String sqlString = path_to_file;
String sql = IOUtils.toString(new FileInputStream(sqlString), "UTF-8");
getSession().createSQLQuery(sql);

I took it and applied it Tranformers hibernate to process the information and turn it into a Dto.