|
|
1.
Introduction
This document presents an overview of Database features available in
MyEclipse. To
get a better feel for MyEclipse and learning more about it,
please check out our product
Documentation for more
material.
|
|
2. MyEclipse Database Explorer Perspective
This perspective presents an optimal layout of views and editors for database centric tasks.
To open this perspective, select Window > Open Perspective > Other > MyEclipse Database Explorer.
Figure 2.1. MyEclipse Database Explorer perspective
|
3. Working with Drivers
New MyEclipse JDBC drivers used to connect to your database can be created from the DB Browser view.
Figure 3.1. Creating a new driver
Use the Database Driver wizard to quickly setup the driver using pre-installed driver templates.
Use the Test Driver button to ensure supplied details are correct.
Figure 3.2. Database Driver wizard
You can choose to see all catalogs / schemata in your database or only a selected few.
Figure 3.3. Selecting schema
Use the Export and Import wizards to share driver definitions between workspaces and machines.
Figure 3.4. Exporting MyEclipse drivers
MyEclipse drivers may be imported either from a previously exported file or from an existing workspace.
Figure 3.5. Importing MyEclipse drivers
|
4. Database Explorer Views and Wizards
The DB Browser view is the primary view from which DB tasks can be initiated.
Database entities from all connected drivers will be displayed in this view.
Figure 4.1. DB Browser view
Figure 4.2 Available table actions
Use the Table Wizard to create new tables in the selected catalog / schema.
Figure 4.3. New Table wizard
Figure 4.4. New Column wizard
Use the Foreign Key wizard to create a new foreign key between selected tables.
Figure 4.5 New Foreign Key wizard
Use the Index wizard to create a new index on column(s) of a selected table.
Figure 4.6. New Index wizard
The DB Connection Info view displays database connection properties for the currently selected driver.
Figure 4.7. DB Connection Info view
The Table/Object Info view contains a structured display of all available data from the selected database entity.
Figure 4.8. Table/Object Info view
Use the Edit Data action to bring up an Edit table view for the selected table. Textual data can be edited in place.
Figure 4.9. Edit table view
|
5. Working with SQL
Open the SQL editor using the context menu on an open connection or simply double click an sql or ddl file.
Figure 5.1. Opening an SQL editor
The SQL editor will provide content assist based on currently selected connection.
Multiple queries may be entered in the editor and executed successively.
Figure 5.2. SQL editor column content assist
Figure 5.3. SQL editor general content assist
Results are displayed in the SQL Results view; rows are fetched in configurable increments.
Figure 5.4. SQL Results view displaying first 100 results
Queries executed in the current session are recorded in the SQL History view.
Figure 5.6. SQL History view
Generate DDL for existing database entities using the Generate > DDL action invoked from the corresponding context menu.
Figure 5.7. Generate DDL action
Figure 5.8 Generated DDL
|
6. Entity Relationship Designer
Create an ER diagram by selecting the Create ER Diagram action on your catalog or schema.
Select the set of tables you wish to include in the diagram and click Finish to create the diagram.
Figure 6.1. New ERD wizard
Tables can be added to an existing diagram by dragging and dropping them from the DB Browser view.
Figure 6.2. ER Diagram
|
7. Extended Oracle, MySQL, SQL Server and Sybase features
MyEclipse professional subscribers have access to extended support for the above databases.
CRUD operations (where applicable) for packages, procedures, functions, sequences, triggers, etc. are available through the DB Browser view.
For example, a list of supported Oracle entities can be seen below.
Figure 7.1. DB Browser view connected to an Oracle DB
Figure 7.2 Running an Oracle procedure
For More details on the extended support, please see the following overview documents:
Extended Oracle Feature Overview
Extended MySQL Feature Overview
Extended MS SQL Server & Sybase Feature Overview
|
8. Feedback
We would like to hear from you! If you liked this overview, have
some suggestions or even some corrections for us please let us
know. We track all user feedback about our learning material in
our
Documentation Forum.
Please be sure to let us know which piece of MyEclipse material
you are commenting on so we can quickly pinpoint any issues that
arise.
|
