"java.lang.ClassCastException" When Executing Command Service Query Post 20b Upgrade (Doc ID 2679390.1)

Last updated on JUNE 22, 2020

Applies to:

Symptoms

 Command service query is not working after patch application to 20B, It was working fine
previously in 20A

The issue can be reproduced at will with the following steps:
1. Starting form SOAP UI
2. Add the WSDL url for connecting to the test box
3. Add the Credentials
4. Run the SQL Query in the SOAP UI
5. Run the query and the result is the error shared above.


SQL run:

<dbx:sql2xml>
            <dbx:Sql2xmlParameters>
               <Query>
                  <RootName>Order</RootName>
                  <Statement>select field from table where condition='something'</Statement>
               </Query>
            </dbx:Sql2xmlParameters>
            <!--Optional:-->
            <!--<dbx:FootPrint>?</dbx:FootPrint>-->
            <!--Optional:-->
            <!--<dbx:UseLOBElement>?</dbx:UseLOBElement>-->
 </dbx:sql2xml>

Changes

 Upgraded to 20B

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.