code: @Override
     protected ResultSet findItemByIdentifier(String identifier) throws SQLException
     {
        if (findItemById == null)
        {
           findItemById = dbConnection.prepareStatement(FIND_ITEM_BY_ID);
        }
        else
        {
           findItemById.clearParameters();
        }
  
        findItemById.setString(1, identifier);
        return findItemById.executeQuery();
     }
docs: {@inheritDoc}