Skip to Content
0
Former Member
Apr 19, 2007 at 12:06 PM

Getting Error in JDBC

13 Views

Hello,

got same error befor (look web-service-and-jdbc), but can not understand this time.

Sending this JDBC request :

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

- <ns0:MT_User_CMDB_request xmlns:ns0="http://com.test">

- <STATEMENT>

- <TABLENAME action="SELECT">

<TABLE>tablename</TABLE>

<access>

<lastname />

<firstname />

<ccresp />

</access>

<key>

<ccresp compareOperation="LIKE">%9313%</ccresp>

</key>

</TABLENAME>

</STATEMENT>

</ns0:MT_User_CMDB_request>

With following error:

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

Normally this happens, if the field ccresp would be of type integer and I try to use a like-statement. But this field has the type varchar and with a database tool I'm able to perform a statement like this:

select * from tablename

where ccresp like '9313'

But this takes about 2 Minutes. Too long for XI? But then the error message is confusing me.

thanks

chris