/**
* 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_sqlSelectISOCurrencyDistinctClassCode = null;
S_sqlSelectISOCurrencyBuff = 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 (stmtDeleteByCcyCdIdx != null) {
try {
stmtDeleteByCcyCdIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtDeleteByCcyCdIdx = null;
}
}
if (stmtDeleteByCcyNmIdx != null) {
try {
stmtDeleteByCcyNmIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtDeleteByCcyNmIdx = null;
}
}
if (stmtReadAllBuff != null) {
try {
stmtReadAllBuff.close();
} catch (SQLException e) {
}
stmtReadAllBuff = null;
}
if (stmtReadBuffByIdIdx != null) {
try {
stmtReadBuffByIdIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByIdIdx = null;
}
if (stmtReadBuffByCcyCdIdx != null) {
try {
stmtReadBuffByCcyCdIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByCcyCdIdx = null;
}
if (stmtReadBuffByCcyNmIdx != null) {
try {
stmtReadBuffByCcyNmIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByCcyNmIdx = 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_sqlSelectTopDomainDistinctClassCode = null;
S_sqlSelectTopDomainBuff = 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 (stmtDeleteByTenantIdx != null) {
try {
stmtDeleteByTenantIdx.close();
} catch (SQLException e) {
}
stmtDeleteByTenantIdx = null;
}
if (stmtDeleteByTldIdx != null) {
try {
stmtDeleteByTldIdx.close();
} catch (SQLException e) {
}
stmtDeleteByTldIdx = null;
}
if (stmtDeleteByNameIdx != null) {
try {
stmtDeleteByNameIdx.close();
} catch (SQLException e) {
}
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 (stmtReadBuffByTenantIdx != null) {
try {
stmtReadBuffByTenantIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByTenantIdx = null;
}
if (stmtReadBuffByTldIdx != null) {
try {
stmtReadBuffByTldIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByTldIdx = 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_sqlSelectISOTimezoneDistinctClassCode = null;
S_sqlSelectISOTimezoneBuff = 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 (stmtDeleteByOffsetIdx != null) {
try {
stmtDeleteByOffsetIdx.close();
} catch (SQLException e) {
}
stmtDeleteByOffsetIdx = null;
}
if (stmtDeleteByUTZNameIdx != null) {
try {
stmtDeleteByUTZNameIdx.close();
} catch (SQLException e) {
}
stmtDeleteByUTZNameIdx = null;
}
if (stmtDeleteByIso8601Idx != null) {
try {
stmtDeleteByIso8601Idx.close();
} catch (SQLException e) {
}
stmtDeleteByIso8601Idx = null;
}
if (stmtReadAllBuff != null) {
try {
stmtReadAllBuff.close();
} catch (SQLException e) {
}
stmtReadAllBuff = null;
}
if (stmtReadBuffByIdIdx != null) {
try {
stmtReadBuffByIdIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByIdIdx = null;
}
if (stmtReadBuffByOffsetIdx != null) {
try {
stmtReadBuffByOffsetIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByOffsetIdx = null;
}
if (stmtReadBuffByUTZNameIdx != null) {
try {
stmtReadBuffByUTZNameIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByUTZNameIdx = null;
}
if (stmtReadBuffByIso8601Idx != null) {
try {
stmtReadBuffByIso8601Idx.close();
} catch (SQLException e) {
}
stmtReadBuffByIso8601Idx = 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;
}
}