Feature Highlights

MyEclipse 5.0 GA release includes the following major enhancements and bug fixes since the 4.1.1 release:  

• Full compatibility with Eclipse 3.2 and Callisto projects
• Matisse4MyEclipse integration into MyEclipse; Now includes customizable palettes
• Web Service support, including:
  • Project and project creation wizard
  • Customizable library containers
  • New Web Services Wizard
  • Deploy web-service web-app
  • Services .xml file editor
  • Java editor with JSR-181 annotation support and code-assist
  • WSDL editor
  • Web Services Explorer
  • Java hot-swap debug support & MyEclipse hot-sync support for web services application
  • Quick-start documentation and example projects
  • Add Web Services capabilities to existing Web and Java projects
• Cross-platform Visual HTML Editor including Struts and JSF
• Expanded database support for MS SQL Server and Sybase
  • View triggers, functions, and procedures in DB Explorer
  • Generate and edit the DDL for triggers and procedures
  • Function Runner - runs functions by generating UI - executes procedure
  • Supports access to the 'sp_help' facility for any selected object to get additional DB information
• Enhanced Hibernate 3.1.X and Spring 1.2.X support
• AJAX/Web 2.0 tool extensions
  • Instant-on JavaScript Debugging, extending the integrated MyEclipse local JavaScript debugger to allow the user to debug remote JavaScript applications
  • Full Linux and Mac support
• Full I18N support for internationalization and localized support following 5.0
• New Websphere 6.1, Sun Java Application Server System 9.0, and Glassfish 1.0 application server connectors
• Customizable server launch configurations
• New Branding

The Database explorer will now display Procedures which are part of your MS SQL or Sybase schema.

The Table/Object Info view displays a structured view of the selected procedure.

Procedure source can be viewed in the SQL Editor using the Open action.

View & Edit data in multiple tables using the new Edit Table view.

The Delete All Rows script allows you to easily delete all rows in your table.

Execute complex scripts with the ability to change the command separator on the fly.

Support for Function nodes has been added to SQL Server. Trigger node support for both SQL Server and Sybase.

Use the Open action to view or edit the source for Procedures, Functions and Triggers.

Opening a Procedure


Opening a Function


Opening a Trigger

Use the Run action to execute procedures and functions conveniently from within MyEclipse.

Running a Procedure

Running a Function

Use the Show sp_help action to request additional information for any database entity. The results are displayed in the SQL Results view.

The Table, Foreign Key and Index wizards do not implicitly quote identifiers anymore. You may add quotes yourself as required.

New ER Diagram Wizard

The new ER Diagram creation wizard enables you select the tables from your DB schema to include in a new ER diagram.

A similar wizard is also presented if you click Refresh Diagram from the View menu allowing you to manage existing diagrams just as easily.

ERD Drag and Drop Support

Drag tables from your schema and drop them into an existing diagram to add them to the ER diagram. If the tables already exist in the diagram, they will be refreshed.

The dropped table will be displayed at the drop location. All relationships involving the new table are automatically depicted.

Deleteting tables from an ER Diagram

Select tables in your diagram and delete them by pressing the DEL key or using the context menu. Table deletions can be undone and redone as needed.

New Table Wizard

Create a new table by using the New Table action from your schema's context menu.

Use the Add button in the Columns tab to open the New Table Column Wizard.

The New Table Column Wizard allows you to defint the details of a new column for the table.

Drop Table Action

Drop tables using the Drop Table action from the table's context menu in the Database Browser.

New Index Wizard

Create a new index by using the New Index action from your table's context menu.

Drop Index Action

Drop indices using the Drop Index action from the index's context menu in the Table Info view.

Index - Generate DDL Action

Generate DDL for your index using the Generate DDL from the index's context menu in the Table Info view.

New Foreign Key Wizard

Create a new foreign key by using the New Foreign Key action from your table's context menu in the Database Browser.

Drop Foreign Key Action

Drop foreign keys using the Drop Foreign Key action from the foreign key's context menu in the Table Info view.

Foreign Key - Generate DDL Action

Generate DDL for your foreign key using the Generate DDL from the foreign key's context menu in the Table Info view.

Use Search > Spring Beans... to search for Spring beans in your workspace.
Ctrl + Shift + G in the Beans Config Editor immediately searches for references of the bean under the cursor.

Use the universal Alt + Shift + B combo or Navigate > Open Spring Bean to bring up the new Open Bean dialog and navigate to the appropriate beans config file.

Hyperlink navigation for Properties now supports property paths.

New Basic DAOs function independent of either Spring or JNDI
Precise findBy methods make it easy to locate entities

MyEclipse Hibernate Perspective

The new Hibernate perspective provides a customized workbench layout consisting the views and editors frequently used in OR mapping activites such as: browsing of Hibernate projects and database schemas, reverse engineer OR mapping details from database schema OR editing and execute HQL queries.

MyEclipse HQL Editor and HQL Snippet Execution

Open the HQL Editor using the Open HQL Editor... action in the MyEclipse submenu of your Hibernate or Spring-Hibernate project's context menu.
Alternatively, double clicking a file with an hql extension also opens this editor.

Content Assist is availabe in the HQL Editor.  It provides support for the following contexts. 

• HQL Keywords
• Hibernate mapped entities

Content Assist can be invoked by pressing Ctrl + Space or Alt + '/' if you use Emacs keybindings.

As you type, observe the HQL being translated to SQL in the Hibernate Dynamic Query Translator View.

Use the Query Parameters view to supply variable values for your query if necessary.

Execute the HQL using the Execute button on the HQL toolbar

The results of the query are displayed in the Hibernate Query Results view. Click a particular result to see more details in the Properties view.

Use the Project combo to switch the editor context between different Hibernate projects.

If you make changes to your configuration files, mapping files or POJOs, those changes can be picked up by the Hibernate Project model by clicking the Refresh button on the HQL toolbar.