Forum Discussion

jnickgo's avatar
jnickgo
Occasional Contributor
8 years ago

IO Error: Unknown host specified in TestRunner Execution

Hello,   We have some Test Steps that make use of JDBC connections in SoapUI.     For our Oracle database we use a tnsnames.ora file to manage the hosts and connections.  I did have some initial ...
JDBC
testRunner
tns
tnsnames
  • fredsvar's avatar
    fredsvar
    8 years ago

    The .vmoptions file is only read by the exe file when running readyapi. There might be an easier way I don't know of but I think what you will have to do is to open the testrunner.bat (or testrunner.sh) file and edit it manually. This is what I would do.

     

    Where you see: 

    fi

export JAVA_OPTS

# For Cygwin, switch paths to Windows format before running java

    Modify it to read: 

     

     

    fi

    JAVA_OPTS="$JAVA_OPTS -Doracle.net.tns_admin=H:\Oracle8"
    export JAVA_OPTS

# For Cygwin, switch paths to Windows format before running java

    Please let me know if it worked.

     

     

     

jnickgo's avatar
jnickgo
Occasional Contributor

I apologize for the delay.

 

 

 

The way we must connect to our Database Data sources is through using TNS Names, which as I mentioned I configred my ReadyAIP-version.vmoptions file to refer to as shown:

 

-Doracle.net.tns_admin=H:\Oracle8

 

When I'm developing and running my tests from the SoapUI GUI it works fine.

 

The issue is the following:

 

The workflow for my testing requires that I'm running my tests from the command line.  My REST requests and other steps work fine, but when it gets to the JDBC request it always fails because it cannot determine the host it is trying to connect to.  

 

It is not an option for me to indicate the ip of the database host as operations changes them without warning.  I'm not sure why running TestRunner from the cmd line would not pick up these settings to be able to resolve the host.  

 

Is there something else I need to configure to let testrunner.bat (I'm assuming it's the testrunner.bat that executes during this method) to pickup those options? 

 

 

fredsvar's avatar
fredsvar
SmartBear Alumni (Retired)
8 years ago

The .vmoptions file is only read by the exe file when running readyapi. There might be an easier way I don't know of but I think what you will have to do is to open the testrunner.bat (or testrunner.sh) file and edit it manually. This is what I would do.

 

Where you see: 

fi

export JAVA_OPTS

# For Cygwin, switch paths to Windows format before running java

Modify it to read: 

 

 

fi

JAVA_OPTS="$JAVA_OPTS -Doracle.net.tns_admin=H:\Oracle8"
export JAVA_OPTS

# For Cygwin, switch paths to Windows format before running java

Please let me know if it worked.

 

 

 

  • fredsvar's avatar
    fredsvar
    SmartBear Alumni (Retired)
    8 years ago

    Yes, of course sorry, My suggestions were very .sh specific... My bad (being on a mac at the moment). What you have done is what I would have done in a bat file.

  • jnickgo's avatar
    jnickgo
    Occasional Contributor
    8 years ago

    Hi fredsvar,

     

    Actually, I had just tried this a bit earlier and it worked in the way that I wanted. When I mentioned the testrunner.bat, I thought, maybe I should make the change there.  As I don't think manually changing the ip address in the cmd line arg is a preferred solution.

     

    See below.

     

    rem JVM parameters, modify as appropriate
    set JAVA_OPTS=-Xms128m -Xmx%READY_XMX% %READY_PERM_SIZE% -Dtest.history.disabled=true -Dsoapui.properties=soapui.properties -Dgroovy.source.encoding=iso-8859-1 "-Dsoapui.home=%READY_API_HOME%\" -Doracle.net.tns_admin=H:\Oracle8

     

    Thanks!