How to read .sql file with Java

Question

How to read .sql file with Java

Navigation

#1 by (0 votes)

0

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

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

Or another way that will allow me to read the file be having to be fetched the script in the repository. Is this possible?

mysql java

asked by anonymous 09.08.2018 / 21:39

1 answer

Post upgrade upgrade error Android Studio Error adding Stored Procedure to the map in Crystal Reports

score 0 · Answer 1

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

I took advantage of Hibernate's tranformers to handle the information and transform into a Dto.