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?

1 Reply

Sort By
  • 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');