HQL, acronym for "Hibernate Query Language", is a query language used by Hibernate and NHibernate
1
vote
1answer
35 views
HQL transformation
I am a newbie with HQL and I am trying to do this :
select count(T) from (
select inscription, max(wrd_step) as max
from table aa
where rd_context = ?
group by inscription
) as T
...
0
votes
1answer
27 views
Syntax Error for HQL JOIN Statment
I'm trying to create a HQL query to join a result of a select with another table. What I have currently is
SELECT e FROM Experience e JOIN (SELECT f FROM Follow f WHERE f.username = :username AND ...
-1
votes
0answers
11 views
Retrieve data from DB in selectOneMenu based on previous SelectOneMenu research
I am creating an IceFaces+spring+Hibernate project now. In the main enterance page, it just has two selectOneMenu tags, the first one is Work Type, the second one is FWRS# and the second drop down ...
1
vote
3answers
33 views
Null in HQL Expressions
I want to know if HQL expressions are null-safe or not?
For example, consider this named query
SELECT a
FROM A a
where a.f=:f
in which f is a field of type String, Double, Date, etc.
Then I use it ...
0
votes
1answer
29 views
How to achieve the following sql query using HQL?
I've the following sql query which I need to accommodate using HQL.
A is an Author and B is an Book - Author has Many books
SQL:
order by a.bookNbr desc, nvl(b.auth_name, b.last_name || ' ' || ...
0
votes
1answer
17 views
Error org.hibernate.hql.internal.ast.QuerySyntaxException
This is my SQL query
select * from customer where cust_acnt_nbr IN
(select cust_acnt_nbr from Asset where dstrct_id IN
(select dstrct_id from dstrct where dstrct_nm = 'ATLANTA'))
I ...
0
votes
0answers
44 views
Grails left outer join between unrelated domains.(one way one to many relationship)
I am following this link to bring some positive changes regarding performance in my app.
I have following two classes
class Topic {
String title
String body
String type
User user
...
0
votes
0answers
21 views
Error with NVL in Hibernate Query Language (HQL)
In hibernate (HQL), I used coalesce instead of NVL (as there is no alternative) as namedQuery , but I got following error
Caused by: java.sql.SQLException: ORA-01465: invalid hex number
at ...
0
votes
1answer
17 views
details of CreateSqlQuery( )
I am new to Hibernate and I need help/answers for few doubts.
1) I am using Oracle 10g dialect and If I use Session.CreateSqlQuery("Oracle syntax SQL Query");
My Question: If I change my dialect to ...
0
votes
1answer
27 views
Does Hibernate 1st Cache work with HibernateTemplate?
I am trying to dive a little deeper into Hibernate cache and Spring's HibernateTemplate, and I am kinda confused by the following questions:
1) How does HibernateTemplate manages the Hibernate ...
0
votes
1answer
14 views
Hibernate hql query
How can i express this SQL query in HQL if we say i have the correct mappings, dtos(pojo) and configurations files...
select * from sig_tc_contraloria_objetivos o
inner join ...
1
vote
4answers
28 views
Error Hibernate propperty “Lazy”
Why do i get this error when i set lazy = true on my mapping file, but when i set it false it works right...
>>org.hibernate.LazyInitializationException: failed to lazily initialize a ...
1
vote
1answer
66 views
hibernate one to many query using mappings
I have 3 classes with the corresponding relationship parent child on them:
//SigTcContraloriaObjetivos, SigTcContraloriaIniciativas, SigTcContraloriaAcciones
<class dynamic-insert="false" ...
0
votes
1answer
18 views
hql not deleting query ok
sessionFactory.getCurrentSession().createQuery("delete from Attendance attend where attend.id in(Select att.id from Attendance att where att.dat= :dat and att.cls_id= :cls_id)")
...
0
votes
0answers
31 views
Handling Data Types in HIbernate Join
So I have two tables with the following details:
Employee(name, age, superior)
Employer(name, age, sex)
Now my .hbm.xml files look like:
Employee.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE ...
