we could solve the created node errors by changing the xsd, but the general problem with "choice" elements by using the form-editor still exists.

greets
marcel

there is one more bug in the new version:

soapUI Pro 2.03 does not save the inserted delay time for delay teststep.

The dealy is computed if the delay time of the teststep is e.g. set with another version (i used soapUI pro 2.0.2).

greets
marcel

Hi,

trying to generate Requests from a definition file including <choice> elements causes problems.

The log shows following errors:

      Thu Jul 10 08:52:05 CEST 2008:WARN:Missing insertionpoint for node
      [{http://www.eplus.de/norman/webservices/OrderPackage_V001}existingAccount],
 appending instead

This error message is thrown for every choice element.

The xsd elements are defined as follows:

<xs:element name="orderAccount">
          <xs:complexType>
            <xs:choice>
               <xs:element name="newAccount" type="pref:OrderAccount">
               </xs:element>
               <xs:element name="existingAccount" type="
ExistingOrderAccount">
               </xs:element>
            </xs:choice>
          </xs:complexType>
       </xs:element>


Trying to create requests within the "form-editor" causes lost xml-fragments. Added nodes will not be saved.

==> It is not possible to create a valid request !!

Already existing requests are manipulated, too. Elements / xml-fragments are lost, too.

==> It is even not possible to send an existing request for those operations.

The log shows following errors trying to edit nodes within the "form-editor":

Thu Jul 10 09:21:20 CEST 2008:WARN:Missing insertionpoint for node
[{http://www.eplus.de/norman/webservices/OrderPackage_V001}existingAccount],
 appending instead
      Thu Jul 10 09:21:26 CEST 2008:WARN:Missing insertionpoint for node
      [{http://www.eplus.de/norman/webservices/OrderPackage_V001}newAccount],
 appending instead
      Thu Jul 10 09:21:33 CEST 2008:WARN:Missing insertionpoint for node
      [{http://www.eplus.de/norman/webservices/BaseTypes_V001}privateContact],
 appending instead
      Thu Jul 10 09:21:56 CEST 2008:WARN:Missing insertionpoint for node
      [{http://www.eplus.de/norman/webservices/BaseTypes_V001}address],
      appending instead
      Thu Jul 10 09:21:56 CEST 2008:ERROR:Failed to create node for
      PrivateAddress
      Thu Jul 10 09:21:56 CEST 2008:ERROR:Failed to create node for street
      Thu Jul 10 09:21:56 CEST 2008:ERROR:Failed to create node for
      PrivateAddress
      Thu Jul 10 09:21:56 CEST 2008:ERROR:Failed to create node for street
      Thu Jul 10 09:21:56 CEST 2008:ERROR:Failed to create node for
      PrivateAddress
      Thu Jul 10 09:21:56 CEST 2008:ERROR:Failed to create node for street
      Thu Jul 10 09:21:56 CEST 2008:ERROR:Failed to create node for
      PrivateAddress


Is there any hint or idea how to solve the problems for me ? It is an very urgent case.

Thanks a lot !

Marcel

i can't say anything about PostgreSQL, but for MySQL the new version works.

Hi Ole,

thank you very much for your quick help.
The new version works in the expected way !!

thank !
Marcel

CREATE TABLE IF NOT EXISTS `result_checkaddress` (
  `RESULT_ID` int(10) unsigned NOT NULL auto_increment,
  `TEST_ID` mediumtext NOT NULL,
  `EXECUTION_ID` mediumtext NOT NULL,
  `INPUT_DATA` mediumtext NOT NULL,
  `OUTPUT_DATA` mediumtext NOT NULL,
  `TEST_RESULT` mediumtext,
  `TEST_COMMENT` mediumtext,
  PRIMARY KEY  (`RESULT_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=333 ;


i use server version 5.0.51a
and mysql-connector-java-5.1.6-bin.jar

Hi,

sorry but i tried it hardly again in much different way - complex or simple, the only way it works is the properties are static.

all properties are set and i use a very simple insert statement and althoug i got the error message above.


========================

insert into result_checkaddress (
      test_id,
      execution_id,
      input_data,
      output_data
      )
values (
      ?,
      ?,
      ?,
      ?
)

=========================

i have no more ideas ..       

i got the same problem. Maybe the date format fields are not accesable with properties ?

have you tried to paste the propertyextension directly into the xml ?

Hi,

i tried to prepare some datadriven testsuits. To get the testdata i use an XAMMP with mysql database. Everything works, but writing back data to the database seens al litle bit 'mysterious'.

I tried two cases:

first i have set the update statement within the datasink step like this:

INSERT into result_checkAddress (
      test_id,
      execution_id,
      input_data,
      output_data,
      test_result,
      test_comment
)
VALUES (
      '${Test Result Data#testId}',
      '${Test Result Data#executionId}',
      '${Test Result Data#inputData}',
      '${Test Result Data#outputData}',
      if (STRCMP(
            'IFNULL(${Test Result Data#resultCode},'')',
            '${Test Result Data#expectedResultCode}'
            ),
      'NOTOK', 'OK'
      ),
      'Comment'
)

'Test Result Data' is an Property step and the properties are moved to this step before.

== > there are written data into the database, but although two different datasets are used (and logged as processed in the different logs within the teststeps) only ONE dataset is written back to the database, but TWO times !!

I tried another way:

INSERT into result_checkAddress (
      test_id,
      execution_id,
      input_data,
      output_data,
      test_result,
      test_comment
)
VALUES (
      '${result_checkaddress#testId}',
      '${result_checkaddress#executionId}',
      '${result_checkaddress#inputData}',
      '${result_checkaddress#outputData}',
      if (STRCMP(
            IFNULL(${result_checkaddress#resultCode},''),
            '${result_checkaddress#expectedResultCode}'
            ),
      'NOTOK', 'OK'
      ),
      'Comment'
)

'result_checkaddress' is the datasink step itself and the properties are moved to this before.

==> I've tried everything i mentioned, but every time i got the error message 'java.sql.SQLException: Parameter out of range (0 1).'

As i guess, it could mean the types does not match, or the number of parameters is not correct. But for me it seems everything schould be ok.

I have no more ideas where the fault is hidden, maybe someone has any idea how to solve my problem ?

Greets and thanks a lot ..
Marcel