answersLogoWhite

0


Best Answer
  1. HQL is to perform both select and non-select operations on data, but Criteria is only for selecting data, we can't perform non-select operations using criteria.
  2. HQL is suitable for executing static queries, where as Criteria is suitable for dynamic queries.
  3. HQL doesn't support pagination concept, but we can achieve pagination with Criteria.
  4. Criteria used to take more time to execute than HQL.
  5. With Criteria we are safe with SQL injection, because of its dynamic query operation, but in HQL as your queries are either fixed or parametrized , there is no safe for SQL injection.
User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the difference between hql and criteria?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the difference between hql and sql?

one of the difference is HQL does not support distinct but SQL supports the distinct in the query


What is the difference between constraints and criteria?

A constraint has a limit as for criteria: to end a loop Excel Questions


In what year did HandQ Life Sciences Investors - HQL - have its IPO?

H&Q Life Sciences Investors (HQL)had its IPO in 1992.


What is the difference between 'criteria' and 'standard' in cognitive process 'evaluate'?

the same meaning


What is the market cap for HandQ Life Sciences Investors HQL?

As of July 2014, the market cap for H&Q Life Sciences Investors (HQL) is $326,538,351.36.


What is the difference between criterion and criteria?

Criterion is singular. The plural form is criteria. Example: The first criterion in the study will be sex. All of the important criteria are sex, age, income, and education level.


What is the difference between an association and and organization?

An association is normally either hired or you have to pass a cetain criteria to enter, whereas organizations are normally where everyone can get in.


What is the difference between if and countif?

COUNTIF counts things that meet certain criteria. The IF function can help a spreadsheet to make decisions. See the related question below.


What is the difference between essential criteria and desirable criteria?

The difference between desirable and essential is... essential is a MUST have where as... desirable is something someone would LIKE you to have. For example; in a job description it may have A-C in GSCE Maths as an essential because they are saying you MUST have this but it may say a current driving licence is an advantage which it could then say desirable next to it as they would LIKE you to have this but it is not a must hope this helps... from Charley


What is the difference between a winter storm warning and a winter weather advisory?

A winter weather advisory is not as serious. The specific criteria vary among different regions of the country.


What is the symbol for HandQ Life Sciences Investors in the NYSE?

The symbol for H&Q Life Sciences Investors in the NYSE is: HQL.


What is the difference between noise rating NR and noise criteria NC curves?

5 dba NC 25 is approximately 30 DBA and NR 25 is 35 dbA.