Copyright © 2007 - 2010 Lars Vogel
|Revision 0.1 - 0.5||17.01.2008||Lars
|Revision 0.6 - 0.7||05.01.2009||Lars
|bug fixes and enhancements|
|Revision 0.8 - 0.9||24.06.2009 - 25.01.2010||Lars
|Upgrade to Eclipse 3.5 (Galileo)|
|Update to Eclipse 3.6 (Helios)|
Table of Contents
The Eclipse DTP project provide tools for performing database tasks. For example the project provides an editor for SQL statements or a database browser.
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.
Install the Data Tools Platform via the Eclipse update manager. Install "Data Tools Platform Enablement Extender SDK"
Download the latest Derby version from the Apache website http://db.apache.org/derby/. Choose the binary distribution.
Create a new General Project "de.vogella.dtp.example" via File-> New -> Other -> General -> Project. This project will store the SQL files.
Add a folder "lib" to your project. Copy the file derby.jar from your Derby download into this folder.
The result should look like the following.
The following will create a connection for an embedded Derby.
Define the driver for the derby access. Go to Window-> Preferences and select "Data Management" -> Connectivity -> Driver Definition. Press Add. Select Derby and the version you want to use. If your Derby version is not listed selected the highest number displayed.
Select then the tab jar pressand select the derby.jar from your project folder "lib".
Switch to the perspective "Database Development" and select "Database Connections", right mouse click and select new.
Maintain a Database location where the new database should be stored on your file system. The flag "Create database (if required)" should be selected. Maintain user and password and press finish.
Congratulation! You have created a new database.
Now your folder Database should have an additional entry. Right it and select connect (if you not connected).
Open then tree to see the content of your new database.
Congratulation. You have connected yourself to the new database.
Switch back to the Java perspective. Create a folder "scripts". Right-click on it, select New -> Other and SQL Development and SQL File.
Maintain the folder "scripts" as a target, name the file "myscript.sql" and maintain the connection you have created earlier.
Maintain a SQL statement, e.g. the creation of a Database schema, right-click and select "Execute all". After running the script you see the result in the "SQL Results" view.
Switch back to "Database development" perspective, right click on your database and select refresh to see your new schema. You could continue now writing SQL statements to create your database, e.g. creating a table via SQL.
Create a table with the following coding.
CREATE TABLE MYKILLERAPP.MyTabelle (ID INTEGER NOT NULL, MyKey INTEGER NOT NULL, Content VARCHAR(20) NOT NULL, PRIMARY KEY (ID));
Put in some data via SQL
insert into MYKILLERAPP.MyTabelle values (1,1,'Hallo');
Refresh your database and select your new table, right-click on your table and select Data->Edit. Now you can edit the data.
Also note that Eclipse Data Tools Platform allows you to upload / download the data and also to see a sample of the content.
Maintaining high quality free online tutorials is a lot of work. Please support free tutorials by donating or by reporting typos or errors.
If you find errors in this tutorial, please notify me (see the top of the page). Please note that due to the high volume of feedback I receive, I cannot answer questions to your implementation. Ensure you have read the vogella FAQ as I don't respond to questions already answered there.
vogella Training Android and Eclipse Training from the vogella team
Android Tutorial Introduction to Android Programming
Eclipse RCP Tutorial Create native applications in Java
JUnit Tutorial Test your application
Git Tutorial Put all your files in a distributed version control system