Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 359712

Summary:	JPQL query results preview functionality
Product:	[WebTools] Dali JPA Tools	Reporter:	Neil Hauge <neil.hauge>
Component:	JPA	Assignee:	Pascal Filion <pascal.filion>
Status:	NEW ---	QA Contact:
Severity:	enhancement
Priority:	P2	CC:	kwutzke, sergio.e.samayoa, sridhar_baratam
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	Windows 7
Whiteboard:	EaseOfUse

Description Neil Hauge

2011-10-03 11:00:58 EDT

Dali should be able to preview query results for defined JPQL queries.  The available EclipseLink libraries could be used to produce the results.  This would likely require a new view or possibly an editor for query input and the display of results.  Existing query UI could be modified to provide quick JPQL input.

A functional spec should be developed to review and discuss UI design.

Comment 1 Sridhar Baratam

2011-10-05 11:27:31 EDT

This would be a very good enhancement to the existing EclipseLink tools. As of today, consumers will have to write a sampkle stub module to check the validity of the JPQL query. With this enhancement, consumers can write JPQL queries on the fly to construct new custom JPQL queries.

It would be nice if the new enhancement provided a UI kind of thing where users can simply drag and drop entities and be able to provide the selection criteria including joins on the applicable entities that have a relationship.

Comment 2 Neil Hauge

2012-04-11 10:25:32 EDT

Unfortunately we have run out of time for this for Juno, but we intend to add this functionality in the next feature release.

Comment 3 Karsten Wutzke

2013-03-05 05:44:03 EST

Too bad this functionality has been postponed. I think it is one of the most important features of any Java EE IDE.

In the meanwhile competing IDEs are providing this.

https://blogs.oracle.com/geertjan/entry/test_jpql_with_netbeans_ide

I'd usually use JBoss Tools HQL editor, but the problem is that you need to use Hibernate as a JPA provider, which we can't.

Comment 4 Neil Hauge

2013-03-05 09:57:03 EST

(In reply to comment #3)
I agree.  This is an important feature request.  Unfortunately we had our hands full with JPA 2.1 and other priorities.  I'd like to get this into an early milestone for the Luna release so people can start to use it.  Bumping up the priority.