¡@

Home 

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..