Here is an easy one. The next piece of code shows an HQL Query I am executing in my program.
String queryString = "update Instance model set model.excluded = :value where model.label in (:instan...
http://www.experts-exchange.com/Programming/Languages/Java/J2EE/EJB/Q_23886788.html
Could I somehow write this using hql, instead - or something that would give me the same result.
rsList = session.createSQLQuery("SELECT {t.*} FROM rfq_supplier_table {t} WHERE ({t}.supplier_nu...
http://www.experts-exchange.com/Programming/Languages/Java/Q_21380535.html
Zones:
JavaDate Answered: 04/07/2005 Rating: 9.4 Views: 0
I'm using HQL, which is Hibernate's SQL. I'm hoping it works
I have the following HQL
select distinct r from Release as r, ReleaseComponent as c
where r.deploymentDate between :fromDate and...
http://www.experts-exchange.com/Database/MySQL/Q_21837216.html
Zones:
MySQL ServerDate Answered: 05/03/2006 Rating: 7.4 Views: 136
Hi
When I look for spa for exmaple, my code goes and grabs things like spanish
How am I supposed to tell it to look for the whole word. I tried adding space at the end but didn't work
How am I...
http://www.experts-exchange.com/Programming/Languages/Java/Q_21871763.html
Zones:
JavaDate Answered: 07/02/2006 Rating: 7.4 Views: 11
Hi
I have a situation where devices in the field send their readings and is persisted every hour. The devices measure consumption with a counter (cumulative). This counter reading is persisted e...
http://www.experts-exchange.com/Programming/Languages/Java/J2EE/Frameworks/Q_23714538.html
assume that There is a column in a table that has the vaue of price = 0.90909090 (9 digit decimal) , in SQL server we can round the data from within the select statement : for instance to round by ...
http://www.experts-exchange.com/Programming/Languages/Java/J2EE/Q_23750042.html
Zones:
J2EE,
JavaDate Answered: 11/10/2008 Rating: 8.2 Views: 17
I have already added the 'search' queries that I need. Now I am trying to add functionality that will allow me to add entries. The entries are to go along with the buttons I have in the screen sh...
http://www.experts-exchange.com/Programming/Languages/Java/Q_24333887.html
Hi,
I want to get data from two table by using a join. Since I am using Hibernate, I want to use HQL. Can someone please help me with writing joins in HQL?
Thanks.
http://www.experts-exchange.com/Programming/Languages/Java/J2EE/JSP/Q_24396319.html
Zones:
JSP,
DatabasesDate Answered: 06/19/2009 Rating: 7.2 Views: 4
One thing that I always hated about SQL was that I always needed two versions of a query if one of the values needed to be tested against null. Yes, there is the nvl() function, but my understandin...
http://www.experts-exchange.com/Programming/Languages/Java/Q_21557317.html
Zones:
JavaDate Answered: 11/27/2005 Rating: 6.4 Views: 267
I am using Hibernate 3 and want to do a query akin to:
SQL
select * from stuff where thingId in (1,2,3,4,5)
Ok. Easy enough - and indeed, I could do that directly in HQL buy building the HQ...
http://www.experts-exchange.com/Programming/Languages/Java/Q_21616097.html
Zones:
JavaDate Answered: 11/02/2005 Rating: 9.0 Views: 42
