Guest User

Untitled

a guest
Aug 23rd, 2018
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.93 KB | None | 0 0
  1. java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost;databaseName=
  2.  
  3. import groovy.sql.Sql
  4. import groovy.sql.DataSet
  5.  
  6. c = Class.forName('com.microsoft.sqlserver.jdbc.SQLServerDriver')
  7.  
  8. def db = [url:'jdbc:sqlserver://localhost;databaseName=... ,driver:'com.microsoft.sqlserver.jdbc.SQLServerDriver']
  9. def sql = Sql.newInstance(db )
  10.  
  11. import groovy.sql.Sql
  12. import groovy.sql.DataSet
  13. import java.sql.DriverManager;
  14. import java.util.ServiceLoader;
  15.  
  16.  
  17. c = Class.forName('com.microsoft.sqlserver.jdbc.SQLServerDriver')
  18. DriverManager.getDrivers()
  19. ServiceLoader.load(java.sql.Driver.class)
  20. def db = [url:'jdbc:sqlserver://localhost;...,driver:'com.microsoft.sqlserver.jdbc.SQLServerDriver']
  21. def sql = Sql.newInstance(db )
  22.  
  23. StringBuilder sb = new StringBuilder();
  24. String grVersion = "brak";
  25.  
  26. Enumeration<Driver> dri = DriverManager.getDrivers();
  27.  
  28. for (Enumeration<Driver> e = dri; e.hasMoreElements();) {
  29. Driver e1 = e.nextElement();
  30. sb.append(e1.getClass().getName()).append(' ');
  31. sb.append(e1.getMajorVersion()).append('.').append(e1.getMinorVersion());
  32. }
  33.  
  34.  
  35. // get LOADED drivers niesetty
  36.  
  37. ServiceLoader<java.sql.Driver> codecSetLoader = ServiceLoader.load(java.sql.Driver.class);
  38. for (Driver e1 : codecSetLoader) {
  39. sb.append(e1.getClass().getName()).append('!');
  40. sb.append(e1.getMajorVersion()).append('.').append(e1.getMinorVersion());
  41. sb.append("# ");
  42. }
  43.  
  44. com.mysql.jdbc.Driver 5.1com.mysql.fabric.jdbc.FabricMySQLDriver 5.1com.mysql.jdbc.Driver!5.1# com.mysql.fabric.jdbc.FabricMySQLDriver!5.1# com.microsoft.sqlserver.jdbc.SQLServerDriver!4.0#
  45. Exception thrown
  46.  
  47. java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost;databaseName=....
  48.  
  49. at ConsoleScript11.run(ConsoleScript11:32)
  50.  
  51. @Grab('com.microsoft.sqlserver:sqljdbc4:4.0')
  52. @GrabConfig(systemClassLoader=true)
Add Comment
Please, Sign In to add comment