Uploaded image for project: 'NetarchiveSuite'
  1. NetarchiveSuite
  2. NAS-1817

Refactor DAO code

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Major
    • None
    • 3.15.0
    • Common, GUI, Harvest Definition
    • None

    Description

      Currently the DAO code is not conforming to JDBC programming best practices.

      There is a lot of duplicated code, especially all code handling statement and result set closing that is not automatically called and must be added to every business method by hand.

      Following issue NAS-1816, the DAO code will contain a lot of try {} finally

      { <close connection> }

      code which is equally bad, and error prone.

      Hence we should move from this very basic DAO implementation to some DAO framework that offers a higher level of abstraction.

      Something like Spring JdbcTemplate seems to be the level of abstraction we need.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ngiraud Nicolas Giraud (Inactive)
              Mikis Seth Sørensen Mikis Seth Sørensen (Inactive)
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 78h
                  78h
                  Remaining:
                  Time Spent - 3h Remaining Estimate - 75h
                  75h
                  Logged:
                  Time Spent - 3h Remaining Estimate - 75h
                  3h