Guest User

Untitled

a guest
Jan 23rd, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. import groovy.sql.Sql
  2.  
  3. this.class.classLoader.rootLoader.addURL(new URL('file:.../jtds-1.2.2.jar'))
  4. def driver = 'net.sourceforge.jtds.jdbc.Driver'
  5. def dburl = "jdbc:jtds:sqlserver://ITSVIL:1433/IKALM_APP"
  6. def first
  7. Sql.withInstance(dburl, '.....', '.....', driver) {
  8. sql ->
  9. first = sql.firstRow( "SELECT * FROM PROJECT" )
  10. }
  11.  
  12. import groovy.sql.Sql
  13.  
  14. defaultTasks 'queryTest'
  15.  
  16. buildscript {
  17. dependencies {
  18. classpath files('..../jtds-1.2.2.jar')
  19. }
  20. }
  21.  
  22. task queryTest () {
  23.  
  24. // l'update va su REPOSITORYURL + '/' + alm.project.vcrProjectName + '/' + Reference
  25.  
  26. doLast {
  27.  
  28. def driver = 'net.sourceforge.jtds.jdbc.Driver'
  29. def dburl = "jdbc:jtds:sqlserver://ITSVIL:1433/IKALM_APP"
  30. def first
  31. Sql.withInstance(dburl, 'EY00018', 'IknAlm18', driver) {
  32. sql ->
  33. first = sql.firstRow( "SELECT * FROM PROJECT" )
  34. }
  35. }
  36. }
  37.  
  38. Execution failed for task ':queryTest'.
  39. > java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlserver://ITSVIL:1433/IKALM_APP
Add Comment
Please, Sign In to add comment