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.

     

     

     

nmrao's avatar
nmrao
Champion Level 3
8 years ago
Are you able to ping that machine using hostname?
You may try with IP Address of the database.

  • jnickgo's avatar
    jnickgo
    Occasional Contributor
    8 years ago

    Hi nmrao

     

    I guess that I have a couple issues here, the reason we use tnsnames is the ip changes, so it is hard to do that.

     

    Also, where would I tell SoapUI to use a specific IP of a database from cmd line or TestRunner?  I know that creating a jdbc Test Step would let me do that if I configured it so. However it seems like TestRunner is not picking that up.

    • nmrao's avatar
      nmrao
      Champion Level 3
      8 years ago
      Can you please take a look the previous reply and answer to the requested info?
      • jnickgo's avatar
        jnickgo
        Occasional Contributor
        8 years ago

        To answer your previous request.

         

        Sure, I can connect to the database with the IP address from a Test Step.  

         

        However, that will not resolve my issue.