/**
  * Release the prepared statements.
  *
  * <p>When the schema changes connections, the prepared statements have to be released because
  * they contain connection-specific information for most databases.
  */
 public void releasePreparedStatements() {
   final String S_ProcName = "releasePreparedStatements";
   S_sqlSelectISOCountryDistinctClassCode = null;
   S_sqlSelectISOCountryBuff = null;
   if (stmtReadBuffByPKey != null) {
     try {
       stmtReadBuffByPKey.close();
     } catch (SQLException e) {
     }
     stmtReadBuffByPKey = null;
   }
   if (stmtLockBuffByPKey != null) {
     try {
       stmtLockBuffByPKey.close();
     } catch (SQLException e) {
     }
     stmtLockBuffByPKey = null;
   }
   if (stmtCreateByPKey != null) {
     try {
       stmtCreateByPKey.close();
     } catch (SQLException e) {
     }
     stmtCreateByPKey = null;
   }
   if (stmtUpdateByPKey != null) {
     try {
       stmtUpdateByPKey.close();
     } catch (SQLException e) {
     }
     stmtUpdateByPKey = null;
   }
   if (stmtDeleteByPKey != null) {
     try {
       stmtDeleteByPKey.close();
     } catch (SQLException e) {
     }
     stmtDeleteByPKey = null;
   }
   if (stmtDeleteByISOCodeIdx != null) {
     try {
       stmtDeleteByISOCodeIdx.close();
     } catch (SQLException e) {
       //				throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
       //					S_ProcName,
       //					e );
     } finally {
       stmtDeleteByISOCodeIdx = null;
     }
   }
   if (stmtDeleteByNameIdx != null) {
     try {
       stmtDeleteByNameIdx.close();
     } catch (SQLException e) {
       //				throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
       //					S_ProcName,
       //					e );
     } finally {
       stmtDeleteByNameIdx = null;
     }
   }
   if (stmtReadAllBuff != null) {
     try {
       stmtReadAllBuff.close();
     } catch (SQLException e) {
     }
     stmtReadAllBuff = null;
   }
   if (stmtReadBuffByIdIdx != null) {
     try {
       stmtReadBuffByIdIdx.close();
     } catch (SQLException e) {
     }
     stmtReadBuffByIdIdx = null;
   }
   if (stmtReadBuffByISOCodeIdx != null) {
     try {
       stmtReadBuffByISOCodeIdx.close();
     } catch (SQLException e) {
     }
     stmtReadBuffByISOCodeIdx = null;
   }
   if (stmtReadBuffByNameIdx != null) {
     try {
       stmtReadBuffByNameIdx.close();
     } catch (SQLException e) {
     }
     stmtReadBuffByNameIdx = null;
   }
 }
  /**
   * Release the prepared statements.
   *
   * <p>When the schema changes connections, the prepared statements have to be released because
   * they contain connection-specific information for most databases.
   */
  public void releasePreparedStatements() {
    final String S_ProcName = "releasePreparedStatements";
    S_sqlSelectSecFormDistinctClassCode = null;
    S_sqlSelectSecFormBuff = null;

    if (stmtReadBuffByPKey != null) {
      try {
        stmtReadBuffByPKey.close();
      } catch (SQLException e) {
      }
      stmtReadBuffByPKey = null;
    }
    if (stmtReadAllBuff != null) {
      try {
        stmtReadAllBuff.close();
      } catch (SQLException e) {
      }
      stmtReadAllBuff = null;
    }
    if (stmtLockBuffByPKey != null) {
      try {
        stmtLockBuffByPKey.close();
      } catch (SQLException e) {
      }
      stmtLockBuffByPKey = null;
    }
    if (stmtCreateByPKey != null) {
      try {
        stmtCreateByPKey.close();
      } catch (SQLException e) {
      }
      stmtCreateByPKey = null;
    }
    if (stmtUpdateByPKey != null) {
      try {
        stmtUpdateByPKey.close();
      } catch (SQLException e) {
      }
      stmtUpdateByPKey = null;
    }
    if (stmtDeleteByPKey != null) {
      try {
        stmtDeleteByPKey.close();
      } catch (SQLException e) {
      }
      stmtDeleteByPKey = null;
    }
    if (stmtDeleteByIdIdx != null) {
      try {
        stmtDeleteByIdIdx.close();
      } catch (SQLException e) {
      }
      stmtDeleteByIdIdx = null;
    }
    if (stmtDeleteByClusterIdx != null) {
      try {
        stmtDeleteByClusterIdx.close();
      } catch (SQLException e) {
      }
      stmtDeleteByClusterIdx = null;
    }
    if (stmtDeleteBySecAppIdx != null) {
      try {
        stmtDeleteBySecAppIdx.close();
      } catch (SQLException e) {
      }
      stmtDeleteBySecAppIdx = null;
    }
    if (stmtDeleteByUJEEServletIdx != null) {
      try {
        stmtDeleteByUJEEServletIdx.close();
      } catch (SQLException e) {
      }
      stmtDeleteByUJEEServletIdx = null;
    }
    if (stmtReadAllBuff != null) {
      try {
        stmtReadAllBuff.close();
      } catch (SQLException e) {
      }
      stmtReadAllBuff = null;
    }
    if (stmtReadBuffByIdIdx != null) {
      try {
        stmtReadBuffByIdIdx.close();
      } catch (SQLException e) {
      }
      stmtReadBuffByIdIdx = null;
    }
    if (stmtReadBuffByClusterIdx != null) {
      try {
        stmtReadBuffByClusterIdx.close();
      } catch (SQLException e) {
      }
      stmtReadBuffByClusterIdx = null;
    }
    if (stmtReadBuffBySecAppIdx != null) {
      try {
        stmtReadBuffBySecAppIdx.close();
      } catch (SQLException e) {
      }
      stmtReadBuffBySecAppIdx = null;
    }
    if (stmtReadBuffByUJEEServletIdx != null) {
      try {
        stmtReadBuffByUJEEServletIdx.close();
      } catch (SQLException e) {
      }
      stmtReadBuffByUJEEServletIdx = null;
    }
  }