Guest User

Untitled

a guest
Oct 27th, 2017
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.81 KB | None | 0 0
  1. Connection conn = null;
  2. Statement stmt;
  3. String user = "test";
  4. String password = "test1";
  5. String url = "localhost;
  6. public void doGet(HttpServletRequest request,
  7. HttpServletResponse response) throws ServletException, IOException {
  8.  
  9. response.setStatus(HttpServletResponse.SC_OK);
  10.  
  11.  
  12. try {
  13. try { Class.forName("com.mysql.jdbc.Driver");
  14.  
  15. } catch (Exception e) {
  16. System.out.println(e);
  17. }
  18.  
  19. conn = DriverManager.getConnection(url, user, password);
  20. stmt = conn.createStatement();
  21. String query = "select * from dataTable";
  22. }........
  23.  
  24. java.sql.SQLException: No suitable driver found for localhost
  25. at java.sql.DriverManager.getConnection(Unknown Source)
  26. at java.sql.DriverManager.getConnection(Unknown Source)
  27. at com.phidget22.ShowDatabase.doGet(ShowDatabase.java:47)
  28. at javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
  29. at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  30. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  31. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  32. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  33. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  34. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  35. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
  36. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  37. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
  38. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  39. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
  40. at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
  41. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  42. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  43. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
  44. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  45. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
  46. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
  47. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  48. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  49. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  50. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  51. at java.lang.Thread.run(Unknown Source)
Add Comment
Please, Sign In to add comment