Guest User

Untitled

a guest
May 9th, 2018
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.93 KB | None | 0 0
  1. String userName = "xxxx";
  2. String password = "xxxx";
  3. String url = "jdbc:sqlserver:xxx.xxx.xxx.xxx;databaseName=asdfzxcvqwer;integratedSecurity=true";
  4. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  5. connection = DriverManager.getConnection(url, userName, password);
  6.  
  7. java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
  8. at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1713)
  9. at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1558)
  10. at java.lang.Class.forName0(Native Method)
  11. at java.lang.Class.forName(Unknown Source)
  12. at repositories.RepositoryBase.<init>(RepositoryBase.java:22)
  13. at repositories.ProductsRepository.<init>(ProductsRepository.java:13)
  14. at api.Products.init(Products.java:31)
  15. at javax.servlet.GenericServlet.init(GenericServlet.java:160)
  16. at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
  17. at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
  18. at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:865)
  19. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:136)
  20. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
  21. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
  22. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
  23. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
  24. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
  25. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
  26. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
  27. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
  28. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
  29. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
  30. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  31. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  32. at java.lang.Thread.run(Unknown Source)
  33.  
  34. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  35.  
  36. Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
  37.  
  38. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  39.  
  40. DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver());
  41.  
  42. String userName = "xxxx";
  43. String password = "xxxx";
  44. String url = "jdbc:sqlserver:xxx.xxx.xxx.xxx;databaseName=asdfzxcvqwer;integratedSecurity=true";
  45.  
  46. try {
  47. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  48. connection = DriverManager.getConnection(url, userName, password);
  49.  
  50. } catch (Exception e)
  51. {
  52. e.printStackTrace();
  53. }
Add Comment
Please, Sign In to add comment