cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted
Frequent Contributor

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?
1 REPLY 1
Highlighted
Frequent Contributor

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

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');
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors