java - JPQL 到 SQL 转换器

Question

是否可以访问由 JPQL 生成的 SQL？

我想稍后使用 SQL 创建一个 View 以供我使用。

如果重要的话，我会使用 Hibernate。

Answer 1

Is it possible to access the SQL which is generated by JPQL?

您可以从 Hibernate Interceptor 访问 SQL String，更准确地说是从方法 Interceptor.html#onPrepareStatement(java.lang.String)

onPrepareStatementString onPrepareStatement(String sql)    Called when sql string is being prepared.    Parameters:        sql - sql to be prepared     Returns:        original or modified sql

If you decide to go this way, the best option is to extends EmptyInterceptor and to override only the methods you want.

You can hook your interceptor using the following declaration in your persistence.xml:

<properties>
  <property name="hibernate.ejb.interceptor" value="com.acme.MyInterceptor"/>
</properties>