This plugin scans your eclipse workspace for JPA entities and lets you
navigate in those entities against your database tables.
- Getting Started
- Quick Tutorial
- Flat/Hierarchical navigation display
- Fast workspace scanning for entities
- Named queries auto detection
- Support user custom queries
- Objects results view and history
- Support all databases
- Entities inheritance
JPAExplorer does not require a special projects type in order to support
It scans you whole workspace (or selected projects) for .class annotated with
parse those annotations and run queries against your database to show the data.
The project is hosted on sourceforge, releases are available for download
Update site: http://jpaexplorer.sourceforge.net
Make sure you have at least Eclipse 3.3.2.
To get started with JPAExplorer, download the release zipped file.
Extract the zipped file into your eclipse installation folder and restart your
Read the tutorial for more details.
JPAExplorer plugin comes with 3 new views that have to be activated
using the menu Window->Show view->Other->JPA Explorer.
Before you start, open Window->Preferences->JPA Explorer
and set your database details.
||This view displays your entities as a database table, including
the table's columns.
In order to see the entity's objects, right click on an entity and
select the 'Show Objects' action,
The results will be displayed in the Entity Objects View.
The purpose of this view is to display both named queries and
user custom queries.
Named queries are collected during the workspace scanning process
and cannot be edited while user custom queries
can be created, edited or deleted using the mouse right click
In order to execute a query, do one of the following:
1. Double click a query
2. Right click on a query and select 'Execute Query' from the
If the query does not contain parameters, the query will be executed
immediately and the results will be displayed in the Entity Objects
Otherwise, a Query Parameters dialog will be shown where you can
populate the query's parameters.
Select the parameter type from the 'Type' dropdown menu and populate
||Entity Objects View
||The purpose of this view is to display the selected entity's
objects taken directly from the database or the executed query
The view supports multi tabs in order to display several results
You can rename a tab header, refresh the results or execute
The entity objects view supports 2 displays modes: flat and hierarchical.
To change display mode, click the small arrow in the toolbar and
select the desired mode.
In hierarchical mode, the hierarchy contains all the entity's data,
if you expand the entity's node,,
you can see all columns, expand a column to see its properties and
data from the database.
If the entity contains a collection, you can drill down the
collection to see its properties.
In flat mode, the data is displayed in a filterable table,
You can click any column header to sort the table.