Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import groovy.sql.Sql
- this.class.classLoader.rootLoader.addURL(new URL('file:.../jtds-1.2.2.jar'))
- def driver = 'net.sourceforge.jtds.jdbc.Driver'
- def dburl = "jdbc:jtds:sqlserver://ITSVIL:1433/IKALM_APP"
- def first
- Sql.withInstance(dburl, '.....', '.....', driver) {
- sql ->
- first = sql.firstRow( "SELECT * FROM PROJECT" )
- }
- import groovy.sql.Sql
- defaultTasks 'queryTest'
- buildscript {
- dependencies {
- classpath files('..../jtds-1.2.2.jar')
- }
- }
- task queryTest () {
- // l'update va su REPOSITORYURL + '/' + alm.project.vcrProjectName + '/' + Reference
- doLast {
- def driver = 'net.sourceforge.jtds.jdbc.Driver'
- def dburl = "jdbc:jtds:sqlserver://ITSVIL:1433/IKALM_APP"
- def first
- Sql.withInstance(dburl, 'EY00018', 'IknAlm18', driver) {
- sql ->
- first = sql.firstRow( "SELECT * FROM PROJECT" )
- }
- }
- }
- Execution failed for task ':queryTest'.
- > java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlserver://ITSVIL:1433/IKALM_APP
Add Comment
Please, Sign In to add comment