Project #8
Storing XML in a Relational Database

Due on Monday April 21 before midnight.


This project must be done individually. No copying is permitted. The purpose of this project is to learn how to store XML data in a relational database and how to reconstruct it back to XML.


You will do this project either: on your PC using NetBeans and JDBC on an Apache Derby database (included in NetBeans), or on Omega using JDBC on mySQL. You can find information about JDBC in the class slides (Web Programming with Servlets). See also the file You can run this file on Omega by editing it so that it uses your own username/password and doing:

java -cp .:/opt/Wolfram/Mathematica/6.0/SystemFiles/Links/DatabaseLink/Java/mysql-connector-java-3.1.12-bin.jar SQL
(make sure that the directory /opt/jdk1.6.0_03/bin/ is in your PATH).

Project Requirements

You will use the XML file cs.xml with the DTD department.dtd. You need to parse this file and store it into a relational database and then convert the relational data back to XML.

What to Submit

Use the form below to submit your java files and your relational schema

Submit this file:

Last modified: 04/15/08 by Leonidas Fegaras