Java PreparedStatement.closeの例

コード例 #1

ファイル: CFInternetMSSqlISOCurrencyTable.java プロジェクト: msobkow/net-sourceforge-MSSCodeFactory-CFInternet-2-6

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

コード例 #2

ファイル: CFDbTestPgSqlISOTimezoneTable.java プロジェクト: msobkow/net-sourceforge-MSSCodeFactory-CFDbTest-2-6

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

コード例 #3

ファイル: CFSecurityMySqlISOLanguageTable.java プロジェクト: msobkow/net-sourceforge-MSSCodeFactory-CFSecurity-2-6

 /**
  * 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() {
   S_sqlSelectISOLanguageDistinctClassCode = null;
   S_sqlSelectISOLanguageBuff = 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 (stmtDeleteByIdIdx != null) {
     try {
       stmtDeleteByIdIdx.close();
     } catch (SQLException e) {
     }
     stmtDeleteByIdIdx = null;
   }
   if (stmtDeleteByCode3Idx != null) {
     try {
       stmtDeleteByCode3Idx.close();
     } catch (SQLException e) {
     }
     stmtDeleteByCode3Idx = null;
   }
   if (stmtDeleteByCode2Idx != null) {
     try {
       stmtDeleteByCode2Idx.close();
     } catch (SQLException e) {
     }
     stmtDeleteByCode2Idx = null;
   }
   if (stmtReadAllBuff != null) {
     try {
       stmtReadAllBuff.close();
     } catch (SQLException e) {
     }
     stmtReadAllBuff = null;
   }
   if (stmtReadBuffByIdIdx != null) {
     try {
       stmtReadBuffByIdIdx.close();
     } catch (SQLException e) {
     }
     stmtReadBuffByIdIdx = null;
   }
   if (stmtReadBuffByCode3Idx != null) {
     try {
       stmtReadBuffByCode3Idx.close();
     } catch (SQLException e) {
     }
     stmtReadBuffByCode3Idx = null;
   }
   if (stmtReadBuffByCode2Idx != null) {
     try {
       stmtReadBuffByCode2Idx.close();
     } catch (SQLException e) {
     }
     stmtReadBuffByCode2Idx = null;
   }
 }

コード例 #4

ファイル: CFDbTestDb2LUWTopDomainTable.java プロジェクト: msobkow/net-sourceforge-MSSCodeFactory-CFDbTest-2-6

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

コード例 #5

ファイル: CFAccOracleFeeDetailTable.java プロジェクト: msobkow/net-sourceforge-MSSCodeFactory-CFAcc-2-6

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