How to get SQL from Hibernate Criteria API (*not* for logging)

by

Here’s “another” way to get the SQL :

CriteriaImpl criteriaImpl = (CriteriaImpl)criteria;
SessionImplementor session = criteriaImpl.getSession();
SessionFactoryImplementor factory = session.getFactory();
CriteriaQueryTranslator translator=new CriteriaQueryTranslator(factory,criteriaImpl,criteriaImpl.getEntityOrClassName(),CriteriaQueryTranslator.ROOT_SQL_ALIAS);
String[] implementors = factory.getImplementors( criteriaImpl.getEntityOrClassName() );

CriteriaJoinWalker walker = new CriteriaJoinWalker((OuterJoinLoadable)factory.getEntityPersister(implementors[0]), 
                        translator,
                        factory, 
                        criteriaImpl, 
                        criteriaImpl.getEntityOrClassName(), 
                        session.getLoadQueryInfluencers()   );

String sql=walker.getSQLString();

More Related Contents:

  1. Hibernate show real SQL [duplicate]
  2. How to print a query string with parameter values when using Hibernate
  3. JPA and Hibernate – Criteria vs. JPQL or HQL
  4. Hibernate Union alternatives
  5. Hibernate criteria: Joining table without a mapped association
  6. what is the use of annotations @Id and @GeneratedValue(strategy = GenerationType.IDENTITY)? Why the generationtype is identity?
  7. How can you call custom database functions with Hibernate?
  8. How to get distinct results in hibernate with joins and row-based limiting (paging)?
  9. Hibernate Group by Criteria Object
  10. How to prevent SQL Injection with JPA and Hibernate?
  11. Hibernate Criteria for Dates
  12. Hibernate Criteria API: get n random rows
  13. Get column name of property mapped with Hibernate
  14. Using hibernate criteria, is there a way to escape special characters?
  15. How to escape colon `:` within a native SQL query in Hibernate?
  16. Hibernate Issue : Foreign key must have same number of columns as referenced primary key
  17. How can I make a JPA OneToOne relation lazy
  18. How do I get the size of a java.sql.ResultSet?
  19. What is the best approach using JDBC for parameterizing an IN clause? [duplicate]
  20. JPA Hibernate One-to-One relationship
  21. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  22. Hibernate table not mapped error in HQL query
  23. how to configure hibernate config file for sql server
  24. java.lang.NoSuchMethodError: org.hibernate.SessionFactory.openSession()Lorg/hibernate/classic/Session
  25. Hibernate-sequence doesn’t exist
  26. JPA (Hibernate) and custom table prefixes
  27. hibernate 4 and joda-time
  28. How to use prepared statement for select query in Java?
  29. Hibernate native query – char(3) column
  30. Database independence through JDBC in java

Leave a Comment