connecting to sql server
I am very new to using SOAP UI tool by practising i have got some idea.. now i want to get somemore idea about how to connect to my sql server from my soapui tool can anyone help me about this...
Forum Discussion
I am new to SOAPUI and using the open source version of it(SOAP4.5.1). Trying to establish connection to remote database and see error
Here is what I did......
Added a JDBC test step and the values are given as below
Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
connection string : jdbc:sqlserver://127.0.0.1:1433;databaseName=dbname;user=username;password=PASS_VALUE;
sqljdbc jar file is in: C:\Program Files\SmartBear\soapUI-4.5.1\bin\ext
I also downloaded sqljdbc4.jar and placed in the same folder
And when I tried to run the step, the RequestLog show the below error. Could someone please provide me a solution?
Error getting response; java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
Here is what I did......
Added a JDBC test step and the values are given as below
Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
connection string : jdbc:sqlserver://127.0.0.1:1433;databaseName=dbname;user=username;password=PASS_VALUE;
sqljdbc jar file is in: C:\Program Files\SmartBear\soapUI-4.5.1\bin\ext
I also downloaded sqljdbc4.jar and placed in the same folder
And when I tried to run the step, the RequestLog show the below error. Could someone please provide me a solution?
Error getting response; java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.