Skip to Content
author's profile photo Former Member
Former Member

Web Service and JDBC

Hi,

I did an SOAP -> XI -> JDBC process and it works. Now I would like to do the same with another database table and I failed. I did the same I did before, but XI response with a time out message. I just added the like-statement. Could be there the mistake?

<b>Request Source</b>

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_Software_request xmlns:ns0="http://namespace">

<softwareID>22</softwareID>

</ns0:MT_Software_request>

<b>Request JDBC:</b>

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_Software_DB_request xmlns:ns0="http://namespace">

- <STATEMENT>

- <TABLENAME action="SELECT">

<TABLE>myTable</TABLE>

- <access>

<softwareID />

<softwarename />

<version />

<manufacturer />

<language />

<lastname />

<firstname />

<department />

<grading />

<price />

<description />

<softwarecategory />

<country />

</access>

- <key1>

<softwareID compareOperation="LIKE">%22%</softwareID>

</key1>

</TABLENAME>

</STATEMENT>

</ns0:MT_Software_DB_request>

<b>Response JDBC:</b>

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <!-- Call Adapter

-->

- http://sap.com/xi/XI/Message/30" xmlns:SOAP=" http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="1">

<SAP:Category>XIAdapterFramework</SAP:Category>

<SAP:Code area="MESSAGE">GENERAL</SAP:Code>

<SAP:P1 />

<SAP:P2 />

<SAP:P3 />

<SAP:P4 />

<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'myTable' (structure 'STATEMENT'): com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '22'.</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack />

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

<b>Response Source</b>

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <!-- Call Adapter

-->

- http://sap.com/xi/XI/Message/30" xmlns:SOAP=" http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="1">

<SAP:Category>XIServer</SAP:Category>

<SAP:Code area="INTERNAL">PL_TIMEOUT</SAP:Code>

<SAP:P1 />

<SAP:P2 />

<SAP:P3 />

<SAP:P4 />

<SAP:AdditionalText />

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack>Timeout condition of pipeline reached</SAP:Stack>

<SAP:Retry>N</SAP:Retry>

</SAP:Error>

Could it be, that there are problems with data type? In XI everything is xsd:string, but the database has a smallint for softwareID.

I could not handle with the error message "Incorrect syntax near..".

<u>Testing web services</u>

I'm not able to install XML Spy or another freeware/shareware tool in my company. Does anybody knew a simple method to test a web service?

Got anyone a java class with authentification to SAP for testing it??

Thanks

Chris

Message was edited by: Christian Riekenberg

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Oct 17, 2006 at 03:55 PM

    Hi,

    use the tool shown in this blog to test your webservices,

    /people/community.user/blog/2006/09/19/xi-webservice-studio--a-plain-jane-soap-tool

    As for the DB problem, Can you try this and see if it works?

    <?xml version="1.0" encoding="UTF-8" ?>

    - <ns0:MT_Software_DB_request xmlns:ns0="http://namespace">

    - <STATEMENT>

    - <TABLENAME action="SELECT">

    <TABLE>myTable</TABLE>

    - <access>

    <softwareID />

    <softwarename />

    <version />

    <manufacturer />

    <language />

    <lastname />

    <firstname />

    <department />

    <grading />

    <price />

    <description />

    <softwarecategory />

    <country />

    </access>

    - <key1>

    <softwareID compareOperation="LIKE"><b>22%</b></softwareID>

    </key1>

    </TABLENAME>

    </STATEMENT>

    </ns0:MT_Software_DB_request>

    Regards,

    Bhavesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Bhavesh Kantilal

      That was the solution of the problem. 😊

      With hasQuot I can check for a number, but only

      for the complete number, no wildcards.

      So 10 points for you 😊

      Only the link for testing web services is unsatisfied because the tools have to be installed or need other tools. I hoped that someone got a java programm or so for testing web services.

      Thanks

      chris

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.