Any tools for testing ad hoc JPQL queries outside of an application?

views:

answers:

Any tools for testing ad hoc JPQL queries outside of an application?

I'm working on a project which uses JPA for persistence, and I'm trying to find the cleanest and most efficient means for testing JPQL queries. I am more accustomed to the Hibernate world... in which you can test HQL on an ad hoc basis outside the application, using Hibernate Tools and its Hibernate Console. I believe that tool also supports JPQL if you use Hibernate as the JPA provider, but unfortunately in this case I'm on GlassFish and using TopLink.

Are there any rough equivalents to the Hibernate Console l out there (or in development) in the general JPA world? If not, what is your typical practice for tinkering around with JPQL queries during development?

How 'bout IntelliJ, the best IDE around?

http://blogs.jetbrains.com/idea/tag/jpa/

duffymo 2010-10-19 22:30:46

I guess I'll give the points to this answer since IntelliJ wasn't covered in that older "duplicate" question. It seems the plugins for Eclipse and NetBeans are still vaporware after a full year, and nothing else really solid has come along. Still, it's disappointing that the only solid option is a commercial proprietary one. Few companies will drop $600 per seat on IntellJ... when virtually all Java developers are fluent in Eclipse or NetBeans, and a rare shortcoming like this can be worked around by manually writing a test class. Oh well.

Steve Perkins 2010-10-24 13:36:19

" Few companies will drop $600 per seat on IntellJ" - at your hourly rate, I can assume you that IntelliJ will more than pay for itself in a very short period of time. An individual seat costs far less. I buy a personal license every year and use that wherever I go.

duffymo 2010-10-25 09:46:50

ansaurus

tags:

views:

answers:

Any tools for testing ad hoc JPQL queries outside of an application?

related questions