eDatabase is a general Database Eclipse toolsets. You can graphically design, create, reverse and access your databases. Torque, Hibernate and OJB code generation lets your application access your datas.





1. Introduction



EclipseDatabase is a general purpose Database Tool.

It lets you manage the design of your Database and generate java code to access your Database.

This tool is designed with open technologies which provide software independance.



Everything is stored in XML, there is no binary cryptic information.

Most of the generators are templates based and so users can modify the templates to fit their needs.



(Click on image for full size)



The tool is designed to address the most used Databases.



To Access your Database, EclipseDatabase proposes you several Object Mapping technologies.



2. Modeling



Database Modeling is Java independent.

It means that you can either create Database Connection and Diagrams into Simple Project, Java Project, C Project or other kind of Projects existing on your Eclipse Platform.

This tool focuses on database description and its associated Database Description Language SQL.

The goal of the tool is to provide a Database Modeler to Development Team.

This tool is not Database administrator or production targeted.

2.1. Database Connection



The Database Connection file is the central piece in EclipseDatabase.

The following UML diagrams show you how the different database files are connected.

(Click on image for full size)



This xml file gathers the references for each database piece :

(Click on image for full size)





2.2. Database Schema



(Click on image for full size)



This xml file gathers all of your Database Meta Datas description.

The Database Schemas are Apache Torque and Apache Turbine compatible.

There is only one Schema associated to a Connection.

2.3. Database Schema DTD



(Click on image for full size)



Each Schema file is associated with one DTD.

This DTD acts as a dictionary of your Database Schema Meta Data.

This DTD is Apache Torque and Apache Turbine compatible.

2.4. Database Diagram



(Click on image for full size)



Each Database Connection can view its Schemas in a graphical way.

This is the purpose of the Database Diagram.

You can have more than one diagram associated to a Database Connection.

This file is xml based :

(Click on image for full size)



2.5. Database SQL



(Click on image for full size)



The tool is able to generate two kinds of SQL files :

  • Database Create SQL Script
  • Database Schema SQL Script


2.6. Database Data



(Click on image for full size)



This xml file gathers all of your Database Datas

This file is Database Connection specific.

This file is generated when running the Database Data DTD and XML Resources wizard.

2.7. Database Data DTD





This dtd file acts as the dictionary of a Database Data file.

This file is Database Connection specific.

This file is generated when running the Database Data DTD and XML Resources wizard.

3. Code Generation



Database Code generation is Java dependent.

It means that you need to create a Java Project to generate your Java Code.

However you can define a Simple Project to hold your Database description while you use a Java Project for your application.

3.1. Torque



Torque is a persistence layer.

Torque is an Apache Software Foundation Project.

EclipseDatabase is able to generate :

  • Torque.properties file
  • Object Mapping Java objects


3.2. Object Relational Bridge



ObJect Relational Bridge (OJB) is an Object/Relational mapping tool that allows transparent persistence for Java Objects against relational databases.

OJB is an Apache Software Foundation Project.

EclipseDatabase is able to generate :

  • repository.xml file
  • repository_internal.xml file
  • repository_schema file
  • OJB Java objects


3.3. Hibernate



Hibernate is an object/relational persistence and query service for Java.

EclipseDatabase is able to generate :

  • Hibernate configuration file
  • Hibernate Java objects
  • Stateless Session Bean