Forum Discussion

jnickgo's avatar
jnickgo
Occasional Contributor
7 years ago
Solved

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
    7 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
Please elaborate the issue.
jnickgo's avatar
jnickgo
Occasional Contributor
7 years ago

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)
    7 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
      7 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!

       

      • fredsvar's avatar
        fredsvar
        SmartBear Alumni (Retired)
        7 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.

  • nmrao's avatar
    nmrao
    Champion Level 3
    7 years ago
    You could still use IP Address even if it changing.
    How? use of Property expansion. Define a project level property say DB_SERVER and refer ${#Project#DB_SERVER} inside the steps.

    If the DB_SERVER value which is set in project gets changes, you can still use the changed IP without even modifying the value for the property as testrunner allows to override the project property value by send -P DB_SERVER=<new address> (along with other options supported)