A. On Windows
The solution is to specify a path to the JDBC driver in the CLASSPATH in soapui-pro.bat in C:\Program Files (x86)\SmartBear\soapUI-Pro-4.5.1\bin, as follows:
set CLASSPATH=%SOAPUI_HOME%soapui-pro-4.5.1.jar;%SOAPUI_HOME%..\lib\*;%SOAPUI_HOME/bin/ext/sqljdbc4.jar
B. On Linux:
try to edit soapui-pro.sh. Just add this line to the end of soapui_classpath:
SOAPUI_CLASSPATH=$SOAPUI_CLASSPATH:$SOAPUI_HOME/bin/ext/ojdbc14.jar
C.
You also should be able to change environments and point to different instances of DB connection strings and drivers, using scripts as follows:
def env = project.getPropertyValue("EnvironmentVar")
log.info "Environment param = " + project.getPropertyValue("EnvironmentVar")
log.info "Pointing to environment = " + project.getActiveEnvironmentName()
if (env != null && env != "") {
project.setActiveEnvironment(env)
log.info "Now Pointing to environment = " + project.getActiveEnvironmentName()
}
Or by including the following in your groovy script:
com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("org.sqlite.JDBC")
Thanks,
