너는 진정 전자인을 아는가?

java.sql.SQLException: Operation not allowed after ResultSet closed

에러 발생~ !!

하나의 Statement에 대해 하나의 ResultSet이 유효합니다. 

아래 참고~하였습니다.

public static void main(String[] args) throws ClassNotFoundException, SQLException {

    Connection conn = null;
    Statement stmt = null;

    Class.forName("com.mysql.jdbc.Driver");

    conn = (Connection) DriverManager.getConnection(DB_URL, USER, PASS);

    stmt = (Statement) conn.createStatement();
    String sql;
    ResultSet rs = null;
    ResultSet rs2 = null;
    ResultSet rs3 = null;
    java.sql.PreparedStatement ps = null;
    int event_id = 10;
    sql = "SELECT id,text from tweet where event_id = " + event_id;
    rs = stmt.executeQuery(sql);

    String text = "";
    Long id;
    while (rs.next()) {
        id = rs.getLong("id");
        text = rs.getString("text");
        System.out.println("tweet = " + text);
        text = text.replaceAll("http[^\\s]+", "");
        text = text.replaceAll("www[^\\s]+", "");
        System.out.println("tweet after removal of links= " + text);

        StringTokenizer st = new StringTokenizer(text);
        while (st.hasMoreTokens()) {
            String stopword = st.nextToken();
            System.out.println("stopword : " + stopword);

            sql = "SELECT * from stopwords WHERE word =" + '"'+stopword+'"';

            Statement stmt2 = conn.createStatement();
            rs2 = stmt2.executeQuery(sql);
            if (rs2.next()) {
                text = text.replaceAll(stopword, "");
                System.out.println("tweet after removing stopword = " + text);
            }
            sql = "SELECT * from filtertweet where tweet_id = " + id + "";

            Statement stmt3 = conn.createStatement();
            rs3 = stmt3.executeQuery(sql);
            if (!rs3.next()) {
                sql = "INSERT INTO filtertweet VALUES(?,?)";
                ps = conn.prepareStatement(sql);
                ps.setLong(1, id);
                ps.setString(2, text);
                ps.executeUpdate();
            }

        }
    }
    stmt.close();
    conn.close();
}

출처

org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: Unable to compile class for JSP: 

An error occurred at line: [33] in the jsp file: [  ]
tmp_field19s cannot be resolved to a variable

변수의 값의 값이 이상하여 난 오류입니다.\

Access denied(접근 거부)

https://zetawiki.com/wiki/MySQL_ERROR_1045_%EC%A0%91%EA%B7%BC_%EA%B1%B0%EB%B6%80

https://zetawiki.com/wiki/MySQL_%EC%9B%90%EA%B2%A9_%EC%A0%91%EC%86%8D

https://zetawiki.com/wiki/MySQL_%EC%9B%90%EA%B2%A9_%EC%A0%91%EC%86%8D_%ED%97%88%EC%9A%A9

#1146 Table 'mysql.server' doesn't exist가 없어서 에러발생하였습니다.

원인을 찾았으니 간단하게 생성해주면 됩니다.

CREATE TABLE `servers` (

`Server_name` CHAR(64) NOT NULL DEFAULT '',

`Host` CHAR(64) NOT NULL DEFAULT '',

`Db` CHAR(64) NOT NULL DEFAULT '',

`Username` CHAR(64) NOT NULL DEFAULT '',

`Password` CHAR(64) NOT NULL DEFAULT '',

`Port` INT(4) NOT NULL DEFAULT '0',

`Socket` CHAR(64) NOT NULL DEFAULT '',

`Wrapper` CHAR(64) NOT NULL DEFAULT '',

`Owner` CHAR(64) NOT NULL DEFAULT '',

PRIMARY KEY (`Server_name`)

)

COMMENT='MySQL Foreign Servers table'

COLLATE='utf8_general_ci'

ENGINE=MyISAM

;