[SoapUI] JDBC 请求连接SQL Sever,MySQL

时间:2023-03-08 15:40:46

MySQL
Driver: com.mysql.jdbc.Driver
Connection string: jdbc:mysql://localhost:3306/xxx?user=xxx&password=xxx

SQLServer
Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection string (SQL Server Authentication): jdbc:sqlserver://xxx(SeverName):1433;databaseName=xxx(DB Name);user=xxx;password=xx
Connection string (Windows Authentication): jdbc:sqlserver://xxxx(SeverName):1433;databaseName=xxx(DB Name);IntegratedSecurity=true

For soapUI: (先到官网下载driver,解压)
copy "sqljdbc4.jar" to C:\Program Files (x86)\SmartBear\SoapUI-5.1.3\bin\ext
copy "sqljdbc_auth.dll" to C:\Program Files (x86)\SmartBear\SoapUI-5.0.0\bin