[[BackLinksMenu]]

[[TicketQuery(summary=S2S_PERSISTENCE_COMMONS_R0, compact)]]


= 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 [[TicketQuery(summary=S2S_CORE_SECURITY_R0, compact)]]


== 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.)