Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost;databaseName=
- import groovy.sql.Sql
- import groovy.sql.DataSet
- c = Class.forName('com.microsoft.sqlserver.jdbc.SQLServerDriver')
- def db = [url:'jdbc:sqlserver://localhost;databaseName=... ,driver:'com.microsoft.sqlserver.jdbc.SQLServerDriver']
- def sql = Sql.newInstance(db )
- import groovy.sql.Sql
- import groovy.sql.DataSet
- import java.sql.DriverManager;
- import java.util.ServiceLoader;
- c = Class.forName('com.microsoft.sqlserver.jdbc.SQLServerDriver')
- DriverManager.getDrivers()
- ServiceLoader.load(java.sql.Driver.class)
- def db = [url:'jdbc:sqlserver://localhost;...,driver:'com.microsoft.sqlserver.jdbc.SQLServerDriver']
- def sql = Sql.newInstance(db )
- StringBuilder sb = new StringBuilder();
- String grVersion = "brak";
- Enumeration<Driver> dri = DriverManager.getDrivers();
- for (Enumeration<Driver> e = dri; e.hasMoreElements();) {
- Driver e1 = e.nextElement();
- sb.append(e1.getClass().getName()).append(' ');
- sb.append(e1.getMajorVersion()).append('.').append(e1.getMinorVersion());
- }
- // get LOADED drivers niesetty
- ServiceLoader<java.sql.Driver> codecSetLoader = ServiceLoader.load(java.sql.Driver.class);
- for (Driver e1 : codecSetLoader) {
- sb.append(e1.getClass().getName()).append('!');
- sb.append(e1.getMajorVersion()).append('.').append(e1.getMinorVersion());
- sb.append("# ");
- }
- 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#
- Exception thrown
- java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost;databaseName=....
- at ConsoleScript11.run(ConsoleScript11:32)
- @Grab('com.microsoft.sqlserver:sqljdbc4:4.0')
- @GrabConfig(systemClassLoader=true)
Add Comment
Please, Sign In to add comment