/**
* 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_sqlSelectTenantDistinctClassCode = null;
S_sqlSelectTenantBuff = null;
if (stmtReadBuffByPKey != null) {
try {
stmtReadBuffByPKey.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
}
stmtReadBuffByPKey = null;
}
if (stmtLockBuffByPKey != null) {
try {
stmtLockBuffByPKey.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
}
stmtLockBuffByPKey = null;
}
if (stmtCreateByPKey != null) {
try {
stmtCreateByPKey.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
}
stmtCreateByPKey = null;
}
if (stmtUpdateByPKey != null) {
try {
stmtUpdateByPKey.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
}
stmtUpdateByPKey = null;
}
if (stmtDeleteByPKey != null) {
try {
stmtDeleteByPKey.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
}
stmtDeleteByPKey = null;
}
if (stmtReadAllBuff != null) {
try {
stmtReadAllBuff.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtReadAllBuff = null;
}
}
if (stmtReadBuffByClusterIdx != null) {
try {
stmtReadBuffByClusterIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtReadBuffByClusterIdx = null;
}
}
if (stmtReadBuffByUNameIdx != null) {
try {
stmtReadBuffByUNameIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtReadBuffByUNameIdx = null;
}
}
if (stmtDeleteByClusterIdx != null) {
try {
stmtDeleteByClusterIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtDeleteByClusterIdx = null;
}
}
if (stmtDeleteByUNameIdx != null) {
try {
stmtDeleteByUNameIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtDeleteByUNameIdx = null;
}
}
if (stmtReadBuffByClusterIdx != null) {
try {
stmtReadBuffByClusterIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtReadBuffByClusterIdx = null;
}
}
if (stmtReadBuffByUNameIdx != null) {
try {
stmtReadBuffByUNameIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtReadBuffByUNameIdx = 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_sqlSelectSysClusterDistinctClassCode = null;
S_sqlSelectSysClusterBuff = 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 (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;
}
}