Eclipse DTP Tutorial - Database Tools

Eclipse DTP Tutorial - Database Tools
		Next

Lars Vogel

Version 1.0

27.07.2010

Revision History
Revision 0.1 - 0.5	17.01.2008	Lars Vogel
Created
Revision 0.6 - 0.7	05.01.2009	Lars Vogel
bug fixes and enhancements
Revision 0.8 - 0.9	24.06.2009 - 25.01.2010	Lars Vogel
Upgrade to Eclipse 3.5 (Galileo)
Revision 1.0		Lars Vogel
Update to Eclipse 3.6 (Helios)

Eclipse Data tools Platform

The Eclipse Data Tools Platform (DTP) provides tools to simplify the handling of databases. This article demonstrates the usage of the Eclipse DTP.

This article is based on Eclipse Helios (Eclipse 3.6).

Table of Contents

1. Introduction

1.1. Eclipse Data Tools Platform
1.2. Derby - Java DB
1.3. Using Eclipse

2. Installation

2.1. Installation of DTP
2.2. Download Apache Derby

3. Project

4. Configuration

5. Working with Databases

5.1. Create a new Databases Connection
5.2. Create a new Databases Connection

6. Using SQL Statements

7. Maintaining data in a table

8. Thank you

9. Questions and Discussion

10. Links and Literature

10.1. vogella Resources

1. Introduction

1.1. Eclipse Data Tools Platform

The Eclipse DTP project provide tools for performing database tasks. For example the project provides an editor for SQL statements or a database browser.

1.2. Derby - Java DB

In this article Apache Derby is used as the example database. Derby is an open-source, freely available, pure Java database. See Apache Derby Tutorial to learn more about Apache Derby. Eclipse DTP contains connectors for lots of other databases, e.g. MySQL, PostgreSQL, HSQLDB.

1.3. Using Eclipse

The following assumes that you already have knowledge in using the Eclipse IDE . See the Eclipse Java IDE Tutorial in case you lacking this knowledge.

		Next
		2. Installation