java Programming Glossary: hql
How to avoid type safety warnings with Hibernate HQL results? http://stackoverflow.com/questions/115692/how-to-avoid-type-safety-warnings-with-hibernate-hql-results to avoid type safety warnings with Hibernate HQL results For example I have such query Query q sess.createQuery..
How do you do a limit query in HQL http://stackoverflow.com/questions/1239723/how-do-you-do-a-limit-query-in-hql do you do a limit query in HQL In Hibernate 3 is there a way to do the equivalent of the following.. a way to do the equivalent of the following MySql limit in HQL. select from a_table order by a_table_column desc limit 0 20.. definitely was possible in the older version of Hibernate HQL but seems to have disappeared. java hibernate hql share improve..
Making a OneToOne-relation lazy http://stackoverflow.com/questions/1444227/making-a-onetoone-relation-lazy in the query itself It's possible to specify join fetch in HQL and or explicitly set fetch mode via Criteria API which would..
Hibernate: Criteria vs. HQL http://stackoverflow.com/questions/197474/hibernate-criteria-vs-hql Criteria vs. HQL What are the pros and cons of using Criteria or HQL The Criteria.. vs. HQL What are the pros and cons of using Criteria or HQL The Criteria API is a nice object oriented way to express queries.. Queries are more difficult to understand build than HQL. When do you use Criteria and when HQL What do you prefer in..
Hibernate Criteria returns children multiple times with FetchType.EAGER http://stackoverflow.com/questions/1995080/hibernate-criteria-returns-children-multiple-times-with-fetchtype-eager line items right If not use an inner join fetch in your HQL . Hibernate does not filter out these duplicate references by..
When and why JPA entities should implement Serializable interface? http://stackoverflow.com/questions/2020904/when-and-why-jpa-entities-should-implement-serializable-interface improve this question This usually happens if you mix HQL and native SQL queries. In HQL Hibernate maps the types you.. usually happens if you mix HQL and native SQL queries. In HQL Hibernate maps the types you pass in to whatever the DB understands...
How to get SQL from Hibernate Criteria API (*not* for logging) http://stackoverflow.com/questions/554481/how-to-get-sql-from-hibernate-criteria-api-not-for-logging time for any query run in the application whether it was HQL Criteria or native SQL. This is obviously fragile insecure subject..
Hibernate criteria: Joining table without a mapped association http://stackoverflow.com/questions/720502/hibernate-criteria-joining-table-without-a-mapped-association question My understanding is that if you do this using HQL you are creating a Cartesian join with a filter rather than..
How do you do a limit query in HQL http://stackoverflow.com/questions/1239723/how-do-you-do-a-limit-query-in-hql HQL but seems to have disappeared. java hibernate hql share improve this question This was posted on the Hibernate..
Is there a more efficient way of making pagination in Hibernate than executing select and count queries? http://stackoverflow.com/questions/168084/is-there-a-more-efficient-way-of-making-pagination-in-hibernate-than-executing-s Long q.uniqueResult java mysql hibernate pagination hql share improve this question Baron Schwartz at MySQLPerformanceBlog.com..
How can you call custom database functions with Hibernate? http://stackoverflow.com/questions/1909315/how-can-you-call-custom-database-functions-with-hibernate function such as this from Hibernate java sql hibernate hql share improve this question If you want to use your custom..
Hibernate: Criteria vs. HQL http://stackoverflow.com/questions/197474/hibernate-criteria-vs-hql use cases Or is it just a matter of taste java hibernate hql criteria hibernate criteria share improve this question ..
Table per subclass inheritance relationship: How to query against the Parent class without loading any subclass ??? (Hibernate) http://stackoverflow.com/questions/2700680/table-per-subclass-inheritance-relationship-how-to-query-against-the-parent-cla any subclass java performance hibernate inheritance hql share improve this question An workaround is described as..
How to map a composite key with Hibernate? http://stackoverflow.com/questions/3585034/how-to-map-a-composite-key-with-hibernate ENGINE InnoDB DEFAULT CHARSET utf8 java hibernate orm hql composite key share improve this question To map a composite..
IN-clause in HQL or Java Persistence Query Language http://stackoverflow.com/questions/4828049/in-clause-in-hql-or-java-persistence-query-language not with JDBC style parameters like . java hibernate jpa hql jpql share improve this question Are you using Hibernate's.. Hibernate's you'll need to use the setParameterList String hql from A where name in names Query q s.createQuery hql q.setParameterList..
HQL - row identifier for pagination http://stackoverflow.com/questions/489360/hql-row-identifier-for-pagination else have any other suggestions java hibernate pagination hql share improve this question this is one situation where.. one situation where hibernate shines typical solution with hql query. int elementsPerBlock 10 int page 2 return getSession..
Hibernate: how to use CONCAT and GROUP_CONCAT http://stackoverflow.com/questions/4955580/hibernate-how-to-use-concat-and-group-concat and GROUP_CONCAT in HQL queries java mysql hibernate hql share improve this question About concat it works exactly..
HQL with fully qualified class name http://stackoverflow.com/questions/5327682/hql-with-fully-qualified-class-name unqualified name or fully qualified name java hibernate hql jpa 2.0 share improve this question There is no point to..
How to escape reserved words in Hibernate's HQL http://stackoverflow.com/questions/5686412/how-to-escape-reserved-words-in-hibernates-hql u.name AS text u AS `object` FROM User u java hibernate hql share improve this question You could achieve it by a workaround..
Hibernate HQL Query : How to set a Collection as a named parameter of a Query? http://stackoverflow.com/questions/570229/hibernate-hql-query-how-to-set-a-collection-as-a-named-parameter-of-a-query obvious choice of which to use. Any ideas java hibernate hql share improve this question Use Query.setParameterList Javadoc..
Hibernate criteria: Joining table without a mapped association http://stackoverflow.com/questions/720502/hibernate-criteria-joining-table-without-a-mapped-association is not mapped in the Java annotations or xml. With hql I could select owners that have a pet called 'fido' by specifying.. hibernate criteria If so how Thanks J java hibernate hql criteria share improve this question My understanding is..
|