API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 4th, 2015
214
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.16 KB | None | 0 0
raw download clone embed print report
  1. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  2. at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720)
  3. at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571)
  4. at java.lang.Class.forName0(Native Method)
  5. at java.lang.Class.forName(Unknown Source)
  6. at jdbc.DatabaseAccess.doGet(DatabaseAccess.java:25)
  7. at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
  8. at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
  9. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  10. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  11. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  12. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  13. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  14. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
  15. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
  16. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
  17. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
  18. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  19. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
  20. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  21. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
  22. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
  23. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
  24. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
  25. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  26. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  27. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  28. at java.lang.Thread.run(Unknown Source)
  29. May 04, 2015 6:06:29 PM org.apache.catalina.core.StandardContext reload
  30. INFO: Reloading Context with name [/servelt] has started
  31. May 04, 2015 6:06:29 PM org.apache.catalina.core.StandardContext reload
  32. INFO: Reloading Context with name [/servelt] is completed
  33. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  34. at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720)
  35. at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571)
  36. at java.lang.Class.forName0(Native Method)
  37. at java.lang.Class.forName(Unknown Source)
  38. at jdbc.DatabaseAccess.doGet(DatabaseAccess.java:25)
  39. at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
  40. at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
  41. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  42. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  43. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  44. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  45. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  46. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
  47. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
  48. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
  49. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
  50. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  51. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
  52. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  53. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
  54. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
  55. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
  56. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
  57. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  58. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  59. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  60. at java.lang.Thread.run(Unknown Source)
  61.  
  62. package jdbc;
  63. import java.io.*;
  64. import javax.servlet.*;
  65. import javax.servlet.annotation.WebServlet;
  66. import javax.servlet.http.*;
  67. import java.sql.*;
  68. @WebServlet("/DatabaseAccess")
  69. public class DatabaseAccess extends HttpServlet
  70. {
  71. @Override
  72. protected void doGet(HttpServletRequest req, HttpServletResponse resp)
  73. throws ServletException, IOException
  74. {
  75. resp.setContentType("text/html");
  76. PrintWriter out = resp.getWriter();
  77. String title = "Database connect";
  78. String docType ="<!doctype html>n";
  79. out.println(docType +"<html>n" +"<head><title>" + title + "</title></head>n" +"<body>n" +
  80. "<h1 align="center">" + title + "</h1>n");
  81. try
  82. {
  83. Class.forName("com.mysql.jdbc.Driver");
  84. Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
  85. Statement stmt=con.createStatement();
  86. ResultSet rs=stmt.executeQuery("select * from student");
  87. while(rs.next()){
  88. int id = rs.getInt("id");
  89. int marks = rs.getInt("marks");
  90. String name = rs.getString("name");
  91. out.println("ID: " + id + "<br>");
  92. out.println(", name: " + name + "<br>");
  93. out.println(", marks: " + marks + "<br>");
  94. }
  95. out.println("</body></html>");
  96. rs.close();
  97. stmt.close();
  98. con.close();
  99. }
  100. catch (Exception e)
  101. {
  102. e.printStackTrace();
  103. }
  104.  
  105. }
  106.  
  107. }
  108.  
  109. <?xml version="1.0" encoding="UTF-8"?>
  110. <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
  111. <display-name>servelt</display-name>
  112. <welcome-file-list>
  113. <welcome-file>index.html</welcome-file>
  114. <welcome-file>index.htm</welcome-file>
  115. <welcome-file>index.jsp</welcome-file>
  116. <welcome-file>default.html</welcome-file>
  117. <welcome-file>default.htm</welcome-file>
  118. <welcome-file>default.jsp</welcome-file>
  119.  
  120. <servlet>
  121. <servlet-name>DatabaseAccess</servlet-name>
  122. <servlet-class>jdbc.DatabaseAccess</servlet-class>
  123. </servlet>
  124. <servlet-mapping>
  125. <servlet-name>DatabaseAccess</servlet-name>
  126. <url-pattern>/DatabaseAccess</url-pattern>
  127. </servlet-mapping>
  128.  
  129.  
  130. </web-app>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!