vogella.de

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 press "Add" and select the derby.jar from your project folder "lib".

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.

Thank you for practicing with this tutorial.

I maintain this tutorial in my private time. If you like the information please help me by using flattr or donating or by recommending this tutorial to other people.

Before posting questions, please see the vogella FAQ . If you have questions or find an error in this article please use the www.vogella.de Google Group . I have created a short list how to create good questions which might also help you. .