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

DAO refactoring - Use Spring NamedParameterJdbcTemplate instead of simple preparedStatement in DAO code

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Minor
    • None
    • 4.2
    • Common
    • None
    • General

    Description

      For the implementation of NAS-2212, I had to modify several DAO classes.

      Right now all DAO code uses plain ol' PreparedStatements and populating is done by using parameter indices. Bluntly put, it's a real pain in the neck to modify/extend such code...

      I'd recommend switching to Spring's NamedParameterJdbcTemplate that basically wraps a PreparedStatement but allows to used named parameters to populate it, hence making DAO modifications a whole lot easier.

      Its a few hours' work, and I believe a most useful refactoring to do.

      Attachments

        Activity

          People

            Unassigned Unassigned
            ngiraud Nicolas Giraud (Inactive)
            Søren Vejrup Carlsen Søren Vejrup Carlsen (Inactive)
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 14h
                14h
                Remaining:
                Remaining Estimate - 14h
                14h
                Logged:
                Time Spent - Not Specified
                Not Specified