What operating system are you using?
The script is fine, the only reason you are seeing is because soapUI cannot find the jar.
Could you also put this jar in soapUI/lib and restart.
Hi,
You can pass your password in a string like below:
import groovy.sql.Sql
sql = Sql.newInstance("jdbc: oracle:thin: @HOST:1521 : S I D " , "USER", "@12345", "oracle.jdbc.pool.OracleDataSource")
Please remove spaces from there, I had to put them in to avoid emojis haha
Hello,
Thank you for your response. I tried your code and I got this error :
Hi,
That's because you need an oracle jdbc7 or 8 jar depending on your windows version.
Also, once that you have downloaded the jar from oracle website - you need to place it in SoapUI>bin>ext and restart soapUI and it should work
Goodluck
I already have the file ojdbc7.jar in SoapUI>bin>ex.
Do I have to import the driver in my groovy script ? Like : import java.sql.DriverManager; or something ?
No you should not need to.
As long as you have the driver in ext folder, the above script should work as that's all you need for a connection.
