I have a Java application which runs MySQL queries in Hibernate.

I am now trying to execute the following MySQL query in hibernate which uses user-defined variables.
I have overcome the issue surrounding ':=' assignments, by adding two backslashes. The compiler is no longer complaining about this, but when I try to execute this query from within my application, it displays the following error message:

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PREPARE stmt1 from @sql_max; EXECUTE stmt1' at line 1"

My query in Java/hibernate is as follows:


Could an experienced Hibernate and/or MySQL expert spot my syntax issues? Thank you all for your help!

You don't need to prepare/execute the statement manually because that's the job of a JDBC PreparedStatement, which Hibernate uses behind the scenes.

This is how you should run your SQL query:

Thanks for your reply.

I am referencing that query by calling it within this function which looks similar to yours.



Can Hibernate read user-defined variables?

Thanks.

No, it can not.

You can call stored procedures or database functions, as explained in this article, but you cannot extract user-defined variables like you want, and you don't even need to do so. You can use the ResultSet instead.