Error: Macro BackLinksMenu(None) failed

compressed data is corrupt

Error: Macro TicketQuery(summary=S2S_PERSISTENCE_COMMONS_R0, compact) failed

current transaction is aborted, commands ignored until end of transaction block

Analysis

^{(The purpose of the analysis is to give as much as possible of the needed information for designing and implementing the task.)}

Overview

• There will be layer that uses JDBC directly, "Database" layer or "JDBC" layer.
• There will be Data Access Objects that represent the persistence layer in higher level.
• The primal scheme of the database must be created..
• Some of the queries will be created. And a way for keeping them will be developed in later revision.

Task requirements

• Create the JDBC layer using Derby( JavaDB ).
• Create the DAOs (Data Access Objects) representing the persistence layer.
• Create the database schema to the extend needed by the other tasks in R0.
• Think of a way to store the queries; may be in configuration files?

Task result

The end result will be interface for communication with the database. The DAO objects will be our API for accessing the DB. There will be basic database.

Implementation idea

The DAOs will execute queries to the database using the JDBC(Database) layer.

Related

The schema must be useful for #1293

How to demo

There will be JUnit tests for that task.

Design

Implementation

^{(Implementation results should be described and linked here (from the wiki or the repository))}

Testing

Comments

^{(Write comments for this or later revisions here.)}