Database and Persistence Support

MyEclipse enables you to rapidly develop database-centric applications using Java EE, Spring, JPA, Hibernate and POJOs. With connectors for dozens of databases using JDBC standards and an embedded Derby database, you can be up and running in a snap. From persistence, to reverse-engineering, to visual ER models, MyEclipse has all the tools a database developer needs!

Ready to improve database development in the enterprise?

Get Started with MyEclipse

While you learn more about powerful tools for database development in the enterprise, go ahead and start your MyEclipse download!

Connect to a Database

Add the driver for your database and perform a one-time configuration. Now you’re ready to connect to the database and get to work.

Connect to a Database

Utilize Your Database

From the Database Explorer, access views and wizards to design, create, query and update your database.
Utilize Your Database

Dozens of Database Connectors

Quickly set up drivers using pre-installed driver templates. You can choose to see all catalogs/schemata in your database or only a selected few. The handy Export and Import wizards provide an easy way to share driver definitions between workspaces and machines. Plus, MyEclipse Professional subscribers have access to extended support for Oracle, MySQL, SQL Server, DB2 and Sybase databases with CRUD operations (where applicable) for packages, procedures, functions, sequences, triggers, etc.

Database Connectors
Wizards and Editors

Easy to Use Wizards and Editors

Database entities from all connected drivers are displayed in a DB Browser view, allowing you to quickly access a number of helpful wizards that assist you in creating new tables, columns, foreign keys and indices.  You can also view database connection properties for a driver, view a structured display of all available data from a database entity and modify the table.

Persistence and Reverse Engineering

Wield the power of persistence through JPA with the EclipseLink, OpenJPA or Hibernate providers in standalone, web or EJB 3 projects. Wizards make it easy to reverse engineer database table information to generate entity beans and DAOs, with Spring backed DAOs and transactions in Spring projects. Powerful views allow you to easily create and edit persistence annotations.

Persistence and Reverse Engineering
Simplified SQL

Simplified SQL

The SQL editor provides content assist based on the selected connection. You can enter multiple queries in the editor and execute them successively. These queries are recorded in a history view. You also have the ability to generate DDL for existing database entities. The Visual SQL Query Editor lets you create complex SQL queries without having to remember complex SQL syntax. Visually add tables, create joins, manage groups, expressions and order your output with easy-to-use wizards.

Database Visualization

Visually manage the lifecycle of a relational database from design, through implementation, and maintenance with a visual model of existing databases. The ER-Designer, our read-only editor, utilizes the database connectors of the Database Explorer to access a database’s metadata as it reverse engineers the database’s entity-relationship (ER) model. Tables can be added to an existing diagram by dragging and dropping them from the DB Browser.

Database Visualization

Database development and Java EE solutions in one IDE

Developing for the enterprise throws a lot of things your way. In addition to superior database and persistence support, MyEclipse also includes a comprehensive set of Java EE technologies that allows you to provide solutions for anything that comes your way.

Java EE IDE technologies
Power Up with the Latest Java EE

Adopt the latest Java EE platform in a snap with the out-of-the-box libraries and wizards enabled in MyEclipse. Learn More

Jump-Start Your Spring

If Spring is your thing, give your Spring a boost with built-in Spring framework libraries, bean development tools, and even Spring scaffolding. Learn More

Unchain Your WebSphere

Don’t get stuck in a rut. With MyEclipse, you can work with WebSphere while enjoying the freedom to explore other technologies. Learn More

Build Projects with Maven without Leaving your IDE

MyEclipse boasts seamless pairing of Maven with MyEclipse projects. Use Maven commands from the menu, or use command-line Maven, your choice. Learn More

Tutorial Sneak Peek

Creating a New Index

Creating an index can be an important performance tool for developers. DBMSs typically create indices on keys in database tables. However, there might be other fields that are used regularly in ORDER BY or WHERE clauses that require an index as a performance enhancement. For example, suppose you do a lot of ordering on the CITY of the customers. You could create an index on that field.

  1. Open a connection in the DB Browser view to the built-in MyEclipse Derby database.

    Verifying the connection is established

  2. Expand the connection, right-click the CUSTOMER table, and select New Index.
  3. Type city_idx in the Index name field, and click the Add button to add the columns that belong to the new index.

    Creating a new index

  4. Click the first cell in the Index Columns list, click the drop-down arrow, select CITY, and click Finish.

    Selecting the index column

  5. On the Table/Object Info view, click the Indexes tab to see the new index.

To see more of this document, visit Working with Database Tables, Foreign Keys, and Indices.