/**
* 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_sqlSelectFeeDetailDistinctClassCode = null;
S_sqlSelectFeeDetailBuff = 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 (stmtReadBuffByTenantIdx != null) {
try {
stmtReadBuffByTenantIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtReadBuffByTenantIdx = null;
}
}
if (stmtReadBuffByFeeIdx != null) {
try {
stmtReadBuffByFeeIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtReadBuffByFeeIdx = null;
}
}
if (stmtDeleteByTenantIdx != null) {
try {
stmtDeleteByTenantIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtDeleteByTenantIdx = null;
}
}
if (stmtDeleteByFeeIdx != null) {
try {
stmtDeleteByFeeIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtDeleteByFeeIdx = null;
}
}
if (stmtReadBuffByTenantIdx != null) {
try {
stmtReadBuffByTenantIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtReadBuffByTenantIdx = null;
}
}
if (stmtReadBuffByFeeIdx != null) {
try {
stmtReadBuffByFeeIdx.close();
} catch (SQLException e) {
// throw CFLib.getDefaultExceptionFactory().newDbException( getClass(),
// S_ProcName,
// e );
} finally {
stmtReadBuffByFeeIdx = null;
}
}
}
