public class dbtesting {
private static Connection connection = null;
def connection(String server, String port, String dbname, String username, String password) {
String url = "jdbc:sqlserver://" + server + ":" + port + ";databaseName=" + dbname + ";user=" + username + ";password=" + password + ";IntegratedSecurity=true"
connection = DriverManager.getConnection(url)
}
}
这是我用来连接到sqlserver的自定义关键字,但它失败了。at TempTestCase1580391392461.run(TempTestCase1580391392461.groovy:23( 原因:com.microsoft.sqlserver.jdbc.SQLServerException: **7 at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1745( at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(身份验证JNI.java:58(
我错过了什么? 感谢您的任何帮助
用于窗口身份验证的SQL Server Db连接正在为我工作,使用以下代码
def connection(String server, String port, String username, String Password, String dbname) {
String url = "jdbc:sqlserver://" + server + ":" + port + ";databaseName=" + dbname + ";IntegratedSecurity=true"
connection = DriverManager.getConnection(url)
当我们通过窗口身份验证连接时,无需传递用户名和密码。