Any one experiened problem testing using SOAPUI webservice which is hosted using wsHttpBinding ?

Let me know any fix for the issue...

nreimertz : I sent you configuration file....

Thank you,

I will send you the WSDL /config file in couple of days..

Here is the content of web.config file




   <services>
         <service behaviorConfiguration="TESTService.ServiceImplementation.TEST_Behavior" name="TESTService.ServiceImplementation.TEST">
            <endpoint binding="wsHttpBinding" bindingConfiguration="transactionalWsHttpBinding" bindingNamespace="http://TESTService.ServiceContracts/2007/07" contract="TESTService.ServiceContracts.ITEST"/>
            <endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange"/>
         </service>
      </services>
      <bindings>
         <wsHttpBinding>
            <binding name="transactionalWsHttpBinding" transactionFlow="true" receiveTimeout="00:10:00" sendTimeout="00:10:00" openTimeout="00:10:00" closeTimeout="00:10:00">
               <reliableSession enabled="true" ordered="true" inactivityTimeout="00:10:00"/>
            </binding>
         </wsHttpBinding>
      </bindings>

omatzura

I am waiting for you reply, please let me what info you needed ?

Ramesh

yes I mean  --   WFC ws-http binding

- what exact configuration details/info you need - guide me....so that I can provide

Than you,
Ramesh

does Soap ui supports ws-http protocol ?

My demo went well, but above question came up... could you please advice ?

Hi

I am trying to write to Databse ( sql Servicer 2005 )

Datasink has two properties   apcode, apcity.

I want to write these two properties into Database table ( apupdate)... how do I do ?

I wrote like this:   insert into apupdate values(apcode = ?, apcity = ?)

which did not work... could please help me....   again... this is also for Demo I am presenting...

Thank you Ole...  its magic...

Creating Data source from response file ( below is the reponse )...  with Row X Path as

declare namespace types='http://www.aeroflot.ru/';
//types:Airport[1]


Column X Path as

code/text()


But I am unable to create datasource with all the code present in the response, only I get first code ( GYD) to property when I execute...

Please help me...


soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.aeroflot.ru/" xmlns:types="http://www.aeroflot.ru/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
   <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
      <types:AirportListResponse>
         <AirportListResult href="#id1"/>
      </types:AirportListResponse>
      <soapenc:Array id="id1" soapenc:arrayType="types:Airport[14]">
         <Item href="#id2"/>
         <Item href="#id3"/>
         <Item href="#id4"/>
         <Item href="#id5"/>
         <Item href="#id6"/>
         <Item href="#id7"/>
         <Item href="#id8"/>
         <Item href="#id9"/>
         <Item href="#id10"/>
         <Item href="#id11"/>
         <Item href="#id12"/>
         <Item href="#id13"/>
         <Item href="#id14"/>
         <Item href="#id15"/>
      </soapenc:Array>
      <types:Airport id="id2" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Baku</city>
         <name xsi:type="xsd:string">BINA</name>
         <code xsi:type="xsd:string">GYD</code>
         <id_country xsi:type="xsd:string">AZE</id_country>
      </types:Airport>
      <types:Airport id="id3" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Bangkok</city>
         <name xsi:type="xsd:string">Bangkok</name>
         <code xsi:type="xsd:string">BKK</code>
         <id_country xsi:type="xsd:string">THA</id_country>
      </types:Airport>
      <types:Airport id="id4" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Barcelona</city>
         <name xsi:type="xsd:string">Barcelona</name>
         <code xsi:type="xsd:string">BCN</code>
         <id_country xsi:type="xsd:string">SPA</id_country>
      </types:Airport>
      <types:Airport id="id5" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Barnaul</city>
         <name xsi:type="xsd:string">Barnaul</name>
         <code xsi:type="xsd:string">BAX</code>
         <id_country xsi:type="xsd:string">RUS</id_country>
      </types:Airport>
      <types:Airport id="id6" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Beijing</city>
         <name xsi:type="xsd:string">Capital</name>
         <code xsi:type="xsd:string">PEK</code>
         <id_country xsi:type="xsd:string">CHN</id_country>
      </types:Airport>
      <types:Airport id="id7" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Beirut</city>
         <name xsi:type="xsd:string">Beirut</name>
         <code xsi:type="xsd:string">BEY</code>
         <id_country xsi:type="xsd:string">LEB</id_country>
      </types:Airport>
      <types:Airport id="id8" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Belgrade</city>
         <name xsi:type="xsd:string">Belgrade</name>
         <code xsi:type="xsd:string">BEG</code>
         <id_country xsi:type="xsd:string">YUG</id_country>
      </types:Airport>
      <types:Airport id="id9" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Berlin</city>
         <name xsi:type="xsd:string">Schonefeld</name>
         <code xsi:type="xsd:string">SXF</code>
         <id_country xsi:type="xsd:string">GER</id_country>
      </types:Airport>
      <types:Airport id="id10" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Berlin</city>
         <name xsi:type="xsd:string">Tegel</name>
         <code xsi:type="xsd:string">TXL</code>
         <id_country xsi:type="xsd:string">GER</id_country>
      </types:Airport>
      <types:Airport id="id11" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Bishkek</city>
         <name xsi:type="xsd:string">Manas</name>
         <code xsi:type="xsd:string">FRU</code>
         <id_country xsi:type="xsd:string">KYR</id_country>
      </types:Airport>
      <types:Airport id="id12" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Bratislava</city>
         <name xsi:type="xsd:string">Ivanka</name>
         <code xsi:type="xsd:string">BTS</code>
         <id_country xsi:type="xsd:string">SLK</id_country>
      </types:Airport>
      <types:Airport id="id13" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Brussels</city>
         <name xsi:type="xsd:string">Brussels</name>
         <code xsi:type="xsd:string">BRU</code>
         <id_country xsi:type="xsd:string">BEL</id_country>
      </types:Airport>
      <types:Airport id="id14" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Bucharest</city>
         <name xsi:type="xsd:string">Otopeni</name>
         <code xsi:type="xsd:string">OTP</code>
         <id_country xsi:type="xsd:string">RUM</id_country>
      </types:Airport>
      <types:Airport id="id15" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Budapest</city>
         <name xsi:type="xsd:string">Budapest</name>
         <code xsi:type="xsd:string">BUD</code>
         <id_country xsi:type="xsd:string">HUN</id_country>
      </types:Airport>
   </soap:Body>
</soap:Envelope>

thank you

Keven

I could not locate, please help me

thank you
- Ramesh

Does SOAP UI supports HttpBinding  ?

Could please let me know if the service is built on WCF ( .NET 3.0/3.5 ?)

And also Let me know if it supports

1. Support for  Https ?  ( secured )
2. Support for .Net 3.5 ( if service is developed from )
 

Hi

I am trying to create Data source from list of values from Response.


For example Air port codes for letter  'B', below is the response.... when i tried to create Data source from response I am getting only first airport code in the result, but not all the codes..

Please help in 'Row Xpath' and Column XPath'

Here is the response.


<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.aeroflot.ru/" xmlns:types="http://www.aeroflot.ru/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
   <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
      <types:AirportListResponse>
         <AirportListResult href="#id1"/>
      </types:AirportListResponse>
      <soapenc:Array id="id1" soapenc:arrayType="types:Airport[14]">
         <Item href="#id2"/>
         <Item href="#id3"/>
         <Item href="#id4"/>
         <Item href="#id5"/>
         <Item href="#id6"/>
         <Item href="#id7"/>
         <Item href="#id8"/>
         <Item href="#id9"/>
         <Item href="#id10"/>
         <Item href="#id11"/>
         <Item href="#id12"/>
         <Item href="#id13"/>
         <Item href="#id14"/>
         <Item href="#id15"/>
      </soapenc:Array>
      <types:Airport id="id2" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Baku</city>
         <name xsi:type="xsd:string">BINA</name>
         <code xsi:type="xsd:string">GYD</code>
         <id_country xsi:type="xsd:string">AZE</id_country>
      </types:Airport>
      <types:Airport id="id3" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Bangkok</city>
         <name xsi:type="xsd:string">Bangkok</name>
         <code xsi:type="xsd:string">BKK</code>
         <id_country xsi:type="xsd:string">THA</id_country>
      </types:Airport>
      <types:Airport id="id4" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Barcelona</city>
         <name xsi:type="xsd:string">Barcelona</name>
         <code xsi:type="xsd:string">BCN</code>
         <id_country xsi:type="xsd:string">SPA</id_country>
      </types:Airport>
      <types:Airport id="id5" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Barnaul</city>
         <name xsi:type="xsd:string">Barnaul</name>
         <code xsi:type="xsd:string">BAX</code>
         <id_country xsi:type="xsd:string">RUS</id_country>
      </types:Airport>
      <types:Airport id="id6" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Beijing</city>
         <name xsi:type="xsd:string">Capital</name>
         <code xsi:type="xsd:string">PEK</code>
         <id_country xsi:type="xsd:string">CHN</id_country>
      </types:Airport>
      <types:Airport id="id7" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Beirut</city>
         <name xsi:type="xsd:string">Beirut</name>
         <code xsi:type="xsd:string">BEY</code>
         <id_country xsi:type="xsd:string">LEB</id_country>
      </types:Airport>
      <types:Airport id="id8" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Belgrade</city>
         <name xsi:type="xsd:string">Belgrade</name>
         <code xsi:type="xsd:string">BEG</code>
         <id_country xsi:type="xsd:string">YUG</id_country>
      </types:Airport>
      <types:Airport id="id9" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Berlin</city>
         <name xsi:type="xsd:string">Schonefeld</name>
         <code xsi:type="xsd:string">SXF</code>
         <id_country xsi:type="xsd:string">GER</id_country>
      </types:Airport>
      <types:Airport id="id10" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Berlin</city>
         <name xsi:type="xsd:string">Tegel</name>
         <code xsi:type="xsd:string">TXL</code>
         <id_country xsi:type="xsd:string">GER</id_country>
      </types:Airport>
      <types:Airport id="id11" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Bishkek</city>
         <name xsi:type="xsd:string">Manas</name>
         <code xsi:type="xsd:string">FRU</code>
         <id_country xsi:type="xsd:string">KYR</id_country>
      </types:Airport>
      <types:Airport id="id12" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Bratislava</city>
         <name xsi:type="xsd:string">Ivanka</name>
         <code xsi:type="xsd:string">BTS</code>
         <id_country xsi:type="xsd:string">SLK</id_country>
      </types:Airport>
      <types:Airport id="id13" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Brussels</city>
         <name xsi:type="xsd:string">Brussels</name>
         <code xsi:type="xsd:string">BRU</code>
         <id_country xsi:type="xsd:string">BEL</id_country>
      </types:Airport>
      <types:Airport id="id14" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Bucharest</city>
         <name xsi:type="xsd:string">Otopeni</name>
         <code xsi:type="xsd:string">OTP</code>
         <id_country xsi:type="xsd:string">RUM</id_country>
      </types:Airport>
      <types:Airport id="id15" xsi:type="types:Airport">
         <city xsi:type="xsd:string">Budapest</city>
         <name xsi:type="xsd:string">Budapest</name>
         <code xsi:type="xsd:string">BUD</code>
         <id_country xsi:type="xsd:string">HUN</id_country>
      </types:Airport>
   </soap:Body>
</soap:Envelope>

Unable to connect to SQL Server 2005 DB using feature 'Data Source' using JDBC
 
I am using 
 
Driver as : com.microsoft.sqlserver.jdbc.SQLServerDriver 
connection string as: jdbc:sqlserver://systemname;Database=mydbname;Uid=username;Pwd=pwd 
 
Below is the error message 
 
Java.lang.Exception: Failed to init connection for drvr [com.microsoft.sqlserver.jdbc.SQLServerDriver ], connectionString [jdbc:sqlserver://systemname;Database=mydbname;Uid=username;Pwd=pwd] 
 
Earlier I download and I copied 'sqljdbc.jar' in C:\Program Files\eviware\soapUI-Pro-2.0.2\bin\ext 
 
Please advise...   thank you in advance