Forum Discussion

Awesome's avatar
Awesome
Frequent Contributor
16 years ago

is it possible to SSH to a server and then connect using sqplus for a datasource

the way i connect to our db (oracle). i have to ssh and then run sqlplus. is there a way to do a connection like this within soapui to populate a datasource with select queries?
Awesome's avatar
Awesome
Frequent Contributor
16 years ago
ah ha, got it!

place 'ojdbc14.jar.' in C:\Program Files\eviware\soapUI-Pro-2.5\bin\ext

use a groovy script:

import groovy.sql.Sql;
import oracle.jdbc.driver.OracleDriver;

def db = Sql.newInstance('jdbc:oracle:thin:@DB_SERVER:DB_PORT:DB_INSTANCE', 'DB_USERNAME', 'DB_PASSWORD','oracle.jdbc.driver.OracleDriver');