jsp에서 mssql 연결시 에러Resource specification not allowed here for source level below 1.7

Question

jsp에서 mssql 연결해보려고하는데Resource specification not allowed here for source level below 1.7위와 같은 메세지가 뜹니다. 찾아보니 거의 다 메이븐 관련해서 pom.xml을 수정하면 된다는데저는 spring을 사용중이지 않아서 해결이 안되는데해결 방법이 있을까요? 참고로 jdk 버전은 1.8입니다 혹시 몰라서 소스도 첨부하겠습니다. <%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%> <%@ page import="java.sql.*"%> <%@ page import="java.sql.Connection"%> <%@ page import="java.sql.DriverManager"%> <%@ page import="java.sql.ResultSet"%> <%@ page import="java.sql.SQLException"%> <%@ page import="java.sql.Statement"%> DB Connection Test <% Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String connectionUrl = "jdbc:sqlserver://111.111.111.111:1234;" + "database=test;" + "user=test;" + "password=test;"; try (Connection connection = DriverManager.getConnection(connectionUrl);) { // Code here. Statement stmt = connection.createStatement(); ResultSet rs = stmt.executeQuery("select * from test"); while (rs.next()) { String DIV_CD = rs.getString("DIV_CD"); String DIV_NM = rs.getString("DIV_NM"); out.println(DIV_CD + "||" + DIV_NM + "
"); } rs.close(); stmt.close(); connection.close(); } // Handle any errors that may have occurred. catch (SQLException e) { e.printStackTrace(); } %> 추가사항서블릿파일에서는 작동을하는데jsp 파일에서만 작동을 안하네요. jsp 페이지에서 에러도 첨부합니다. 2가지가 번갈아서 나옵니다.. HTTP Status 500 - java.lang.ClassNotFoundException: org.apache.jsp.mssql_jsp type Exception report message java.lang.ClassNotFoundException: org.apache.jsp.mssql_jsp description The server encountered an internal error that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: java.lang.ClassNotFoundException: org.apache.jsp.mssql_jsp org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:177) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:376) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) kr.co.dm.gmddas.common.AccessLogFilter.doFilter(AccessLogFilter.java:50) kr.co.dm.gmddas.common.AuthFilter.doFilter(AuthFilter.java:103) kr.co.autobrain.adf.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:162) kr.co.dm.gmddas.util.CrossScriptingFilter.doFilter(CrossScriptingFilter.java:21) root cause java.lang.ClassNotFoundException: org.apache.jsp.mssql_jsp java.net.URLClassLoader.findClass(URLClassLoader.java:381) org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:132) org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63) org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:172) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:376) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) kr.co.dm.gmddas.common.AccessLogFilter.doFilter(AccessLogFilter.java:50) kr.co.dm.gmddas.common.AuthFilter.doFilter(AuthFilter.java:103) kr.co.autobrain.adf.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:162) kr.co.dm.gmddas.util.CrossScriptingFilter.doFilter(CrossScriptingFilter.java:21) note The full stack trace of the root cause is available in the Apache Tomcat/7.0.67 logs. HTTP Status 500 - Unable to compile class for JSP: type Exception report message Unable to compile class for JSP: description The server encountered an internal error that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 15 in the jsp file: /mssql.jsp Resource specification not allowed here for source level below 1.7 12: 13: String connectionUrl = "jdbc:sqlserver://111.111.111.111:1111;" + "database=test;" + "user=test;" + "password=test;"; 14: 15: try (Connection connection = DriverManager.getConnection(connectionUrl);) { 16: // Code here. 17: Statement stmt = connection.createStatement(); 18: ResultSet rs = stmt.executeQuery("select * from test"); Stacktrace: org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:103) org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:366) org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:485) org.apache.jasper.compiler.Compiler.compile(Compiler.java:379) org.apache.jasper.compiler.Compiler.compile(Compiler.java:354) org.apache.jasper.compiler.Compiler.compile(Compiler.java:341) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:662) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:364) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) kr.co.dm.gmddas.common.AccessLogFilter.doFilter(AccessLogFilter.java:50) kr.co.dm.gmddas.common.AuthFilter.doFilter(AuthFilter.java:103) kr.co.autobrain.adf.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:162) kr.co.dm.gmddas.util.CrossScriptingFilter.doFilter(CrossScriptingFilter.java:21) note The full stack trace of the root cause is available in the Apache Tomcat/7.0.67 logs.

jsp에서 mssql 연결시 에러Resource specification not allowed here for source level below 1.7

0개의 답변

Q&A 목록