cafe24 에서 sms 호스팅 . HTTP Status 500 – Internal Server Error (db 연결부분 오류 추정)

Question

우선 코드를 설명해 드리자면 cafe24에서 jsp 예제를 가져와 기본틀은 유지하며 제가 개발하고자 하는 프로그램을 개발중에 MSSQL 을 사용해 jsp 에 연동하여 데이터를 가져오려우선codeinit.jsp 는 잘 돌아가는거 같은데..찾기 버튼을 누르면이렇게 오류가 뜨네욤..ㅠㅠㅠㅠ ssmsend.jsp 65 - 71이 문제같다는데 어떤부분이 문제인지 도저히 감이 안잡혀 질문 올립니다. --error Message--HTTP Status 500 – Internal Server Error Type Exception Report Message An exception occurred processing JSP page [/smssend.jsp] at line [68] Description The server encountered an unexpected condition that prevented it from fulfilling the request. Exception org.apache.jasper.JasperException: An exception occurred processing JSP page [/smssend.jsp] at line [68] 65: String Message_content = new String("").intern(); 66: 67: try { 68: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 69: String connectionUrl = "jdbc:sqlserver://localhost:52285;database=JimKiMi_User_db;integratedSecurity=true"; 70: Connection conn = DriverManager.getConnection(connectionUrl); 71: Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:617) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:499) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) Root Cause javax.servlet.ServletException: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:909) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:838) org.apache.jsp.smssend_jsp._jspService(smssend_jsp.java:431) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) Root Cause java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1364) org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1185) org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:123) org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:60) java.lang.Class.forName0(Native Method) java.lang.Class.forName(Unknown Source) org.apache.jsp.smssend_jsp._jspService(smssend_jsp.java:194) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) Note The full stack trace of the root cause is available in the server logs. -- codeinit.jsp--<%@ page contentType="text/html; charset=UTF-8" %> SMS Project --smssend.jsp-- <%@ page language="java" import="java.util.*, java.security.*, java.io.*, java.net.*, java.sql.*,java.sql.SQLException,java.util.*" %> <%! /**============================================================== Description : 사용 함수 선언 ==============================================================**/ /** * nullcheck * @param str, Defaultvalue * @return */ public static String nullcheck(String str, String Defaultvalue ) throws Exception { String ReturnDefault = "" ; if (str == null) { ReturnDefault = Defaultvalue ; } else if (str == "" ) { ReturnDefault = Defaultvalue ; } else { ReturnDefault = str ; } return ReturnDefault ; } /** * BASE64 Encoder * @param str * @return */ public static String base64Encode(String str) throws java.io.IOException { sun.misc.BASE64Encoder encoder = new sun.misc.BASE64Encoder(); byte[] strByte = str.getBytes(); String result = encoder.encode(strByte); return result ; } /** * BASE64 Decoder * @param str * @return */ public static String base64Decode(String str) throws java.io.IOException { sun.misc.BASE64Decoder decoder = new sun.misc.BASE64Decoder(); byte[] strByte = decoder.decodeBuffer(str); String result = new String(strByte); return result ; } %> <% /**============================================================== Description : 캐릭터셋 정의 EUC-KR: @ page contentType="text/html;charset=EUC-KR UTF-8: @ page contentType="text/html;charset=UTF-8 ==============================================================**/ %> <%@ page contentType="text/html;charset=EUC-KR"%> <% String PhoneNumber = ""; String Message_content = new String("").intern(); try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String connectionUrl = "jdbc:sqlserver://localhost:호스트 번호;database=데이터 베이스 이름;integratedSecurity=true"; Connection conn = DriverManager.getConnection(connectionUrl); Statement stmt = conn.createStatement(); String name = ""; String NGateS =""; char NGateC = ' '; float Speed=0; float length=0f; float Time; float Sec; System.out.println("MS-SQL 서버 접속에 성공하였습니다."); Scanner scan = new Scanner(System.in); String mssql_query = "SELECT * FROM UserDataTable where Unique_Code = '"+ nullcheck(request.getParameter("c_code"), "") +"'"; ResultSet rs = stmt.executeQuery(mssql_query); // 메타 정보 ResultSetMetaData metaInfo = rs.getMetaData(); int count = metaInfo.getColumnCount(); // 결과값 출력 while (rs.next()) { // 레코드 출력 for (int i = 0; i < count; i++) { if(i == 0) { name = rs.getString(i + 1); } else if(i == 1) { PhoneNumber = rs.getString(i + 1); } else if( i ==5) { NGateS = rs.getString(i + 1); NGateC = NGateS.charAt(0); } else if(i == 6) { length = Float.parseFloat(rs.getString(i + 1)); } else if(i == 7) { Speed = Float.parseFloat(rs.getString(i + 1)); } } } Time = length / Speed; Sec = Time % 60; if(Sec >=30) Time++; Time = Time / 60; Message_content = String.format("%s고객님의 수하물이 %c-gate 에서 %.0f분 후 도착 예정입니다.%n이용해 주셔서 감사합니다.%n%n짐키미%nJimKiMi.com%n",name,NGateC,Time); System.out.printf(Message_content); rs.close(); stmt.close(); conn.close(); scan.close(); } catch (SQLException sqle) { System.out.println("SQLException : " + sqle); } /**============================================================== Description : 사용자 샘플코드 ==============================================================**/ String charsetType = "EUC-KR"; //EUC-KR 또는 UTF-8 request.setCharacterEncoding(charsetType); response.setCharacterEncoding(charsetType); String action = nullcheck(request.getParameter("action"), ""); if(action.equals("go")) { String sms_url = ""; sms_url = "https://sslsms.cafe24.com/sms_sender.php"; // SMS 전송요청 URL String user_id = base64Encode(""); // SMS아이디 String secure = base64Encode("");//인증키 String msg = base64Encode(nullcheck(Message_content, "")); // String msg = base64Encode(nullcheck(request.getParameter(Mssql_ServerConection.ConectionDB_PhonNumber("code")), "")); // String msg = base64Encode(nullcheck(request.getParameter("msg"), "")); String rphone = base64Encode(nullcheck(PhoneNumber, "")); // String rphone = base64Encode(nullcheck(request.getParameter(Mssql_ServerConection.ConectionDB("code")), "")); // String rphone = base64Encode(nullcheck(request.getParameter("rphone"), "")); String sphone1 = base64Encode(nullcheck(request.getParameter("sphone1"), "")); String sphone2 = base64Encode(nullcheck(request.getParameter("sphone2"), "")); String sphone3 = base64Encode(nullcheck(request.getParameter("sphone3"), "")); String rdate = base64Encode(nullcheck(request.getParameter("rdate"), "")); String rtime = base64Encode(nullcheck(request.getParameter("rtime"), "")); String mode = base64Encode("1"); String subject = ""; if(nullcheck(request.getParameter("smsType"), "").equals("L")) { subject = base64Encode(nullcheck(request.getParameter("subject"), "")); } String testflag = base64Encode(nullcheck(request.getParameter("testflag"), "")); String destination = base64Encode(nullcheck(request.getParameter("destination"), "")); String repeatFlag = base64Encode(nullcheck(request.getParameter("repeatFlag"), "")); String repeatNum = base64Encode(nullcheck(request.getParameter("repeatNum"), "")); String repeatTime = base64Encode(nullcheck(request.getParameter("repeatTime"), "")); String returnurl = nullcheck(request.getParameter("returnurl"), ""); String nointeractive = nullcheck(request.getParameter("nointeractive"), ""); String smsType = base64Encode(nullcheck(request.getParameter("smsType"), "")); String[] host_info = sms_url.split("/"); String host = host_info[2]; String path = "/" + host_info[3]; int port = 80; // 데이터 맵핑 변수 정의 String arrKey[] = new String[] {"user_id","secure","msg", "rphone","sphone1","sphone2","sphone3","rdate","rtime" ,"mode","testflag","destination","repeatFlag","repeatNum", "repeatTime", "smsType", "subject"}; String valKey[]= new String[arrKey.length] ; valKey[0] = user_id; valKey[1] = secure; valKey[2] = msg; valKey[3] = rphone; valKey[4] = sphone1; valKey[5] = sphone2; valKey[6] = sphone3; valKey[7] = rdate; valKey[8] = rtime; valKey[9] = mode; valKey[10] = testflag; valKey[11] = destination; valKey[12] = repeatFlag; valKey[13] = repeatNum; valKey[14] = repeatTime; valKey[15] = smsType; valKey[16] = subject; String boundary = ""; Random rnd = new Random(); String rndKey = Integer.toString(rnd.nextInt(32000)); MessageDigest md = MessageDigest.getInstance("MD5"); byte[] bytData = rndKey.getBytes(); md.update(bytData); byte[] digest = md.digest(); for(int i =0;i1) {Count= rMsg[1]; } //발송결과 알림 if(Result.equals("success")) { alert = "성공적으로 발송하였습니다."; alert += " 잔여건수는 "+ Count+"건 입니다."; } else if(Result.equals("reserved")) { alert = "성공적으로 예약되었습니다"; alert += " 잔여건수는 "+ Count+"건 입니다."; } else if(Result.equals("3205")) { alert = "잘못된 번호형식입니다."; } else { alert = "[Error]"+Result; } out.println(nointeractive); if(nointeractive.equals("1") && !(Result.equals("Test Success!")) && !(Result.equals("success")) && !(Result.equals("reserved")) ) { out.println(""); } else if(!(nointeractive.equals("1"))) { out.println(""); } out.println(""); } %>------------------------------------------------------------------------------------------------------------------------------------------- 긴 코드 읽어주셔서 감사합니다 jsp 기초도 하기 전에 이런일을 맞게 되서 부랴부랴 공부하고 있는데 너무 어렵네요.. 첫 질문이라 많이 부족하지만 도움 주시면 감사하겠습니다!

JohnMark · Accepted Answer

에러 로그를 보시면 JDBC 커넥터 클래스르 찾지 못하고 있네요 해당 파일이 또는 패키지가 베대로 있는지 확인해보세요

GenZo · Answer

감사합니다! 원래 자바 eclipse 에서는 추가 했었어서 자동으로 같이 추가 된줄 알았네욤 ㅎㅎ 덕분에 해결했습니다!

cafe24 에서 sms 호스팅 . HTTP Status 500 – Internal Server Error (db 연결부분 오류 추정)

2개의 답변

Q&A 목록