Overview

This chapter is composed of :

1. Introduction
2. Modeling
   1. Database Connection
   2. Database Schema
   3. Database Schema DTD
   4. Database Diagram
   5. Database SQL
   6. Database Data
   7. Database Data DTD
3. Object Mapping
   1. Torque
   2. Object Relational Bridge
   3. Hibernate

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 independence.

• Eclipse
• GEF
• Torque
• Village
• Hibernate

Every piece of information is part of text based files (XML, DTD or SQL files).

There is no binary cryptic information.

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

• Velocity

The tool is designed to address the most used Databases:

• Axion
• Cloudscape
• DB2
• DB2 400
• Hypersonic
• Informix
• Firebird
• Interbase
• Microsoft Access
• Microsoft SQL Server
• MySQL
• Oracle
• PostgreSQL
• SapDB
• Sybase

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

• Torque
• Object Relational Bridge
• Hibernate

2. Modeling

Database Modeling is Java independent.

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

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

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

This tool is not destined for the use of a database administrator or production.

2.1. Database Connection

The Database Connection file is the central piece in EclipseDatabase.

The following UML diagram shows you how the different database files are connected.

This xml file gathers the references for each database piece :

• Database Schema, one Database Schema per connection
• Database Schema DTD, one Database Schema DTD per Database Schema
• Database Diagram, zero or * Database Diagrams per Database Connection
• Database SQL, zero or * Database SQL per Database Connection
• Database Data, zero or * Database Data per Database Connection
• Database Data DTD, one Database Data DTD per Database Data

2.2. Database Schema

This xml file gathers all of your Database Meta Data 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

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

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 :

2.5. Database SQL

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

• Database SQL Script
• Database Create SQL Script
• Database Schema SQL Script
• Database Data SQL Script

2.6. Database Data

This xml file gathers all of your Database Data.

This file is Database Connection specific.

It 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.

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

3. Object Mapping

Database Object Mapping is Java dependent.

This 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

EclipseDatabase is able to import :

• Torque Schema file

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 Mapping file
• Hibernate Java objects
• Stateless Session Bean

EclipseDatabase is able to import :

• Hibernate Configuration file
• Hibernate Mapping file