Import XML instances into RDBMS

Preparation

If you already started the first task just continue working on your project using IntelliJ. Otherwise read the first task regarding the skeleton project import.

Description

Write a Java application reading <catalog> document instances and writing the XML content to a relational database. Hints:

  • de.hdm_stuttgart.mi.sda1.Category2Rdbms contains JDBC related connection parameters and boilerplate code.

  • Upon invocation class de.hdm_stuttgart.mi.sda1.Driver instantiates de.hdm_stuttgart.mi.sda1.Category2Rdbms thereby:

    • Reading and parsing Schema/sampledata.xml.

    • Open a database connection to your local PostgreSQL server.

Tasks

Insert data from Schema/sampledata.xml into your local database. Use your schema from the second task.

Hints

Even if your application e.g. just fills in category data you'll receive points. Also partly completed but not fully working code may contribute.

Solution upload

Upload your project using the first task. Enter either of the following two texts:

  • I'm expecting points for my work on the current task.

  • I did not work on this task.

You may as well add other marking related comments.