/**
* 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;
}
}
