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.
You will do this project on Omega using JDBC on mySQL. You can find information about JDBC in the class slides (Web Programming with Servlets). See also the file mysql.java. You first need to download the mySQL JDBC driver on your Omega directory. Then edit the file mysql.java on Omega so that it uses your own username/password and run it using:
javac mysql.java java -cp .:mysql-connector-java.jar SQL(make sure that the directory /opt/jdk1.6.0_03/bin/ is in your PATH).
You will use the XML file from Project #7 that describes auctions:
Use the form below to submit your java file and your relational schema:
Last modified: 04/14/09 by Leonidas Fegaras