Guten Morgen ihr lieben,
zur Zeit möchte ich durch eine JSP Datei meine Verbindung zur Datenbank testen. Hier der Code:
Dabei entsteht jedoch folgende Fehlermeldung:
Ich bin in dem Gebiet noch relativ neu, verstehe daher die Fehlermeldungen nicht. Was habe ich falsch geschrieben?
zur Zeit möchte ich durch eine JSP Datei meine Verbindung zur Datenbank testen. Hier der Code:
Code:
<jsp:directive.page import="java.sql.*" />
<jsp:directive.page import="java.util.*" />
<jsp:scriptlet>
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:80/partyservice", "jspdude", "jspdude");
Statement statement = connection.createStatement();
String SQL = "select * from GERICHTE";
ResultSet rs = statement.executeQuery(SQL);
ResultSetMetaData rsmd=rs.getMetaData();
</jsp:scriptlet>
Dabei entsteht jedoch folgende Fehlermeldung:
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /jsptest.jsp at line 4
1: <jsp:directive.page import="java.sql.*" />
2: <jsp:directive.page import="java.util.*" />
3: <jsp:scriptlet>
4: Class.forName("com.mysql.jdbc.Driver");
5: Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:80/partyservice", "jspdude", "jspdude");
6: Statement statement = connection.createStatement();
7: String SQL = "select * from GERICHTE";
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.jsptest_jsp._jspService(jsptest_jsp.java:140)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1360)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1206)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:128)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:66)
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:169)
org.apache.jsp.jsptest_jsp._jspService(jsptest_jsp.java:58)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.
Ich bin in dem Gebiet noch relativ neu, verstehe daher die Fehlermeldungen nicht. Was habe ich falsch geschrieben?