soapUI从groovy脚本访问MS SQL数据库 [英] soapUI access MS SQL DB from groovy script
问题描述
import groovy.sql.Sql $ 我试图使用Groovy脚本从SoapUI连接到MS Sql 2005 DB。 b
$ b sql = Sql.newInstance(jdbc:jtds:sqlserver:// servername\\inst1 / databaseName,
username,password,com.microsoft.sqlserver .jdbc.SQLServerDriver)
错误:找不到适合jdbc的驱动程序:jtds:sqlserver:// 32esx802 \inst1 / tlMain
我试过使用net.sourceforge.jtds.jdbc。驱动程序,但我仍然得到相同的错误
请让我知道我做错了什么。
谢谢
找到答案
首先从连接字符串中删除jtds,所以语法看起来像
sql = Sql.newInstance(jdbc:sqlserver:// servername\\inst1 / databaseName,
username,password,com.microsoft.sqlserver.jdbc.SQLServerDriver)
一旦解决了这个问题,就会出现另一个错误。我有一个超时错误。基于原帖,似乎有些怪异Groovy sql和MS sql之间的冲突。要解决此问题,请删除sql语句中的databaseName和数据库引用。所以sql的语法看起来像。
import groovy.sql.Sql
sql = Sql.newInstance(jdbc :sqlserver:// servername\\inst1,
username,password,com.microsoft.sqlserver.jdbc.SQLServerDriver)
def row = sql。 firstRow(select te.tDisplayName from dbName.TableName te where te.Column2 = 5000006)
log.info(row.tDisplayName);
如果您有错误,指出无法找到 com.microsoft.sqlserver .jdbc.SQLServerDriver
确保从Microsoft网站下载 sqljdbc.jar
,并将它放在 C:\ Program Files Files \eviware\soapUI-3.6.1\lib
并重新启动SoapUI。
I am trying to connect to MS Sql 2005 DB from SoapUI using Groovy script.
import groovy.sql.Sql
sql = Sql.newInstance("jdbc:jtds:sqlserver://servername\\inst1/databaseName",
"username", "password", "com.microsoft.sqlserver.jdbc.SQLServerDriver")
Error: No suitable driver found for jdbc:jtds:sqlserver://32esx802\inst1/tlMain
I have tried to use "net.sourceforge.jtds.jdbc.Driver" but i still get the same error
Please let me know what i am doing wrong.
Thanks
Found the answer
first remove "jtds" from the connect string, so the syntax will look like
sql = Sql.newInstance("jdbc:sqlserver://servername\\inst1/databaseName",
"username", "password", "com.microsoft.sqlserver.jdbc.SQLServerDriver")
Once this is fixed another error came up. I got a timeout error. Based on the original post there seems to be some weird conflict between Groovy sql and MS sql. to work around this remove the databaseName and the database reference in the sql statement. So the sql syntax will look like.
import groovy.sql.Sql
sql = Sql.newInstance("jdbc:sqlserver://servername\\inst1",
"username", "password", "com.microsoft.sqlserver.jdbc.SQLServerDriver")
def row = sql.firstRow("select te.tDisplayName from dbName.TableName te where te.Column2=5000006")
log.info(row.tDisplayName);
also if you have error stating that could not find com.microsoft.sqlserver.jdbc.SQLServerDriver
make sure you download sqljdbc.jar
from Microsoft site and place it in C:\Program Files\eviware\soapUI-3.6.1\lib
and restart SoapUI.
这篇关于soapUI从groovy脚本访问MS SQL数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!