A friendly place for programming greenhorns!
Big Moose Saloon
Search
|
Java FAQ
|
Recent Topics
Register / Login
JavaRanch
»
Java Forums
»
Databases
»
Object Relational Mapping
Author
recursive JQL/HQL
nimo frey
Ranch Hand
Joined: Jun 28, 2008
Posts: 580
posted
Oct 20, 2009 07:23:13
0
Hello,
How can I translate this recursive query (from DB2, example query of
http://it.toolbox.com/blogs/db2luw/using-values-to-build-a-recursive-query-12601
):
WITH ALL_DAYS(DT) AS ( VALUES (DATE('2009-02-01')) UNION ALL SELECT DT + 1 DAY FROM ALL_DAYS WHERE DT < '2009-09-02' ) SELECT DT FROM ALL_DAYS;
to JQL or HQL ?
Is that possible?
I agree. Here's the link:
http://ej-technologies/jprofiler
- if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
subject: recursive JQL/HQL
Similar Threads
Hibernate Query Language where clause
How to use IN Clause in HQL
HQL join problem
tuple in jql/hql
How to get aroun LazyInitialization exceptions using Spring HibernateDaoSupport?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter