Skip to Content
0
Former Member
Oct 16, 2006 at 12:42 PM

JDBC Problem

17 Views

Hello,

I tried a JDBC call and also used some web blogs as information. But I received a error message I couldn't deal with. My request to JDBC looks like this (from sxmb_moni):

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

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

- <STATEMENT>

- <TABLENAME action="SELECT">

<TABLE>my_table</TABLE>

</TABLENAME>

- <access>

<lastname />

</access>

- <key>

test@test.de

</key>

</STATEMENT>

</ns0:MT_User_CMDB_request>

I received the 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'): java.sql.SQLException: FATAL ERROR document format: structure 'STATEMENT', key element 'lastname' contains no values</SAP:AdditionalText>

Does anybody know what it could be??

In sxmb_moni: In first column I had red lamps. When do I get a red lamp and when a red flag??

Thanks

chris