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 Grade: A 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 Grade: A Views: 163
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 Grade: A Views: 28
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
I'm struggling with HQL, how can I do the same thing as this SQL statement:
select horse_name.sire, sum(results.prize_money) as 'total_winnings' from horse_name, results where horse_name.horse_i...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23834440.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 Grade: A Views: 20
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 Grade: C Views: 327
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 Grade: A Views: 131
Hi experts,
I have a table, which has a start and end date, and i want to query, using Hibernate's query language, whether a given day falls between these two SQL dates. Can anyone help me out?...
http://www.experts-exchange.com/Programming/Languages/Java/Q_21616968.html
Zones:
JavaDate Answered: 11/04/2005 Grade: A Views: 189
