Skip to Content
0
Former Member
Oct 17, 2006 at 03:49 PM

Web Service and JDBC

34 Views

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