コード例 #1
0
  private boolean createTable(
      Connection conn, String tableNameSqlStringName, String createSqlStringName)
      throws SQLException {
    String tableName = sqlQueries.getSqlString(tableNameSqlStringName, true);

    DatabaseMetaData dbMetaData = conn.getMetaData();

    // Try UPPER, lower, and MixedCase, to see if the table is there.
    if (theJDBCUtil.tableExists(dbMetaData, tableName)) {
      return false;
    }

    PreparedStatement createStatement = null;

    try {
      createStatement = conn.prepareStatement(sqlQueries.getSqlString(createSqlStringName, true));
      createStatement.execute();

      StringBuffer logBuffer;
      logBuffer =
          new StringBuffer(64)
              .append("Created table '")
              .append(tableName)
              .append("' using sqlResources string '")
              .append(createSqlStringName)
              .append("'.");
      log(logBuffer.toString());

    } finally {
      theJDBCUtil.closeJDBCStatement(createStatement);
    }

    return true;
  }
コード例 #2
0
  /**
   * Initializes the sql query environment from the SqlResources file. Will look for
   * conf/sqlResources.xml.
   *
   * @param conn The connection for accessing the database
   * @param sqlFileUrl The url which we use to get the sql file
   * @throws Exception If any error occurs
   */
  private void initSqlQueries(Connection conn, String sqlFileUrl) throws Exception {
    try {

      File sqlFile;

      try {
        sqlFile = fileSystem.getFile(sqlFileUrl);
        sqlFileUrl = null;
      } catch (Exception e) {
        serviceLog.error(e.getMessage(), e);
        throw e;
      }

      sqlQueries.init(sqlFile.getCanonicalFile(), "GreyList", conn, sqlParameters);

      selectQuery = sqlQueries.getSqlString("selectQuery", true);
      insertQuery = sqlQueries.getSqlString("insertQuery", true);
      deleteQuery = sqlQueries.getSqlString("deleteQuery", true);
      deleteAutoWhiteListQuery = sqlQueries.getSqlString("deleteAutoWhitelistQuery", true);
      updateQuery = sqlQueries.getSqlString("updateQuery", true);

    } finally {
      theJDBCUtil.closeJDBCConnection(conn);
    }
  }
コード例 #3
0
  /** Initializes the mailet. */
  public void init() throws MessagingException {
    automaticInsert = Boolean.valueOf(getInitParameter("automaticInsert"));
    log("automaticInsert: " + automaticInsert);

    displayFlag = getInitParameter("displayFlag");
    insertFlag = getInitParameter("insertFlag");
    removeFlag = getInitParameter("removeFlag");

    String whitelistManagerAddressString = getInitParameter("whitelistManagerAddress");
    if (whitelistManagerAddressString != null) {
      whitelistManagerAddressString = whitelistManagerAddressString.trim();
      log("whitelistManagerAddress: " + whitelistManagerAddressString);
      try {
        whitelistManagerAddress = new MailAddress(whitelistManagerAddressString);
      } catch (javax.mail.internet.ParseException pe) {
        throw new MessagingException("Bad whitelistManagerAddress", pe);
      }

      if (displayFlag != null) {
        displayFlag = displayFlag.trim();
        log("displayFlag: " + displayFlag);
      } else {
        log("displayFlag is null");
      }
      if (insertFlag != null) {
        insertFlag = insertFlag.trim();
        log("insertFlag: " + insertFlag);
      } else {
        log("insertFlag is null");
      }
      if (removeFlag != null) {
        removeFlag = removeFlag.trim();
        log("removeFlag: " + removeFlag);
      } else {
        log("removeFlag is null");
      }
    } else {
      log("whitelistManagerAddress is null; will ignore commands");
    }

    String repositoryPath = getInitParameter("repositoryPath");
    if (repositoryPath != null) {
      log("repositoryPath: " + repositoryPath);
    } else {
      throw new MessagingException("repositoryPath is null");
    }

    try {
      initSqlQueries(datasource.getConnection(), getMailetContext());
    } catch (Exception e) {
      throw new MessagingException("Exception initializing queries", e);
    }

    selectByPK = sqlQueries.getSqlString("selectByPK", true);
    selectBySender = sqlQueries.getSqlString("selectBySender", true);
    insert = sqlQueries.getSqlString("insert", true);
    deleteByPK = sqlQueries.getSqlString("deleteByPK", true);
  }