java.sql.SQLException: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long
eclipse로 mysql 연동해 작업진행 시 다음 메시지가 나왔다.
java.sql.SQLException: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long
package jdbc.spms.servlets;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.GenericServlet;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.annotation.WebServlet;
@WebServlet("/member/list")
public class MemberListServlet extends GenericServlet {
private static final long serialVersionUID = 1L;
@Override
public void service(ServletRequest request, ServletResponse
response)
throws ServletException, IOException {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
conn = DriverManager.getConnection(
"jdbc:mysql://localhost/studydb", //JDBC URL
"study",
"1111");
stmt = conn.createStatement();
rs = stmt.executeQuery(
"SELECT MNO,MNAME,EMAIL,CRE_DATE" +
" FROM MEMBERS" +
" ORDER BY MNO ASC");
response.setContentType("text/html;
charset=UTF-8");
PrintWriter out = response.getWriter();
out.println("<html><head><title>DB테스트</title></head>");
out.println("<body><h1>테스트</h1>");
while(rs.next()) {
out.println(
rs.getInt("MNO")
+ "," +
rs.getString("MNAME")
+ "," +
rs.getString("EMAIL")
+ "," +
rs.getDate("CRE_DATE")
+ "<br>"
);
}
out.println("</body></html>");
} catch (Exception e) {
throw new ServletException(e);
} finally {
try {if (rs != null) rs.close();} catch(Exception e) {}
try {if (stmt != null) stmt.close();} catch(Exception e) {}
try {if (conn != null) conn.close();} catch(Exception e) {}
}
}
}
|
구글릥을 죽어라 해보고 안되서 BigInteger로도 바꿔보고 쌩쑈를 해봐도 안됬다..
이렇게 2시간 넘게 뻘짓한 결과.. 갑자기 드는생각!!
mysql을 'GA release' 버전이 아닌 '
development release'로 설치한 기억이 문뜩 났다.
삭제하고 GA버전 설치하니........정상 작동된다.....하......
나같이 뻘짓 하는 사람이 없길 바라며 다들 GA버전 설치하시기를..
댓글
댓글 쓰기