/** * 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_sqlSelectISOCountryLanguageDistinctClassCode = null; S_sqlSelectISOCountryLanguageBuff = null; if (stmtReadBuffByPKey != null) { try { stmtReadBuffByPKey.close(); } catch (SQLException e) { } stmtReadBuffByPKey = null; } if (stmtReadBuffAll != null) { try { stmtReadBuffAll.close(); } catch (SQLException e) { } stmtReadBuffAll = 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 (stmtDeleteByCountryIdx != null) { try { stmtDeleteByCountryIdx.close(); } catch (SQLException e) { } stmtDeleteByCountryIdx = null; } if (stmtDeleteByLanguageIdx != null) { try { stmtDeleteByLanguageIdx.close(); } catch (SQLException e) { } stmtDeleteByLanguageIdx = null; } if (stmtReadAllBuff != null) { try { stmtReadAllBuff.close(); } catch (SQLException e) { } stmtReadAllBuff = null; } if (stmtReadBuffByIdIdx != null) { try { stmtReadBuffByIdIdx.close(); } catch (SQLException e) { } stmtReadBuffByIdIdx = null; } if (stmtReadBuffByCountryIdx != null) { try { stmtReadBuffByCountryIdx.close(); } catch (SQLException e) { } stmtReadBuffByCountryIdx = null; } if (stmtReadBuffByLanguageIdx != null) { try { stmtReadBuffByLanguageIdx.close(); } catch (SQLException e) { } stmtReadBuffByLanguageIdx = 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_sqlSelectSecAppBuff = null; S_sqlSelectSecAppDistinctClassCode = null; if (stmtReadBuffByPKey != null) { try { stmtReadBuffByPKey.close(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { stmtReadBuffByPKey = null; } } if (stmtLockBuffByPKey != null) { try { stmtLockBuffByPKey.close(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { stmtLockBuffByPKey = null; } } if (stmtCreateByPKey != null) { try { stmtCreateByPKey.close(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { stmtCreateByPKey = null; } } if (stmtUpdateByPKey != null) { try { stmtUpdateByPKey.close(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { stmtUpdateByPKey = null; } } if (stmtDeleteByPKey != null) { try { stmtDeleteByPKey.close(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { 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 (stmtDeleteByUJEEMountIdx != null) { try { stmtDeleteByUJEEMountIdx.close(); } catch (SQLException e) { } stmtDeleteByUJEEMountIdx = null; } if (stmtReadAllBuff != null) { try { stmtReadAllBuff.close(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { stmtReadAllBuff = null; } } if (stmtReadBuffByIdIdx != null) { try { stmtReadBuffByIdIdx.close(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } stmtReadBuffByIdIdx = null; } if (stmtReadBuffByClusterIdx != null) { try { stmtReadBuffByClusterIdx.close(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } stmtReadBuffByClusterIdx = null; } if (stmtReadBuffByUJEEMountIdx != null) { try { stmtReadBuffByUJEEMountIdx.close(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } stmtReadBuffByUJEEMountIdx = null; } if (stmtDeleteByIdIdx != null) { try { stmtDeleteByIdIdx.close(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } stmtDeleteByIdIdx = null; } if (stmtDeleteByClusterIdx != null) { try { stmtDeleteByClusterIdx.close(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } stmtDeleteByClusterIdx = null; } if (stmtDeleteByUJEEMountIdx != null) { try { stmtDeleteByUJEEMountIdx.close(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } stmtDeleteByUJEEMountIdx = null; } }