cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Problem

Former Member
0 Kudos

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>

<email compareOperation="LIKE">test@test.de</email>

</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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi ,

This is the correct structure....try this way

<?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>

- <access>

<lastname />

</access>

- <key>

<email compareOperation="LIKE">test@test.de</email>

</key>

<b></TABLENAME></b>

</STATEMENT>

Sekhar

</ns0:MT_User_CMDB_request>

Former Member
0 Kudos

Hi,

It looks like the table is expecting a value in the field LastName.Try making the field which accepts null values.

Regards,

Jishi

Former Member
0 Kudos

Use the weblog for reference.

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step by Bhavesh.... But first make the change as said by Sekhar.

Regards,

Jai Shankar.

Former Member
0 Kudos

Damm. I just found it in another thread

().

It seem to be really a wrong structure where the table-tag close to early.

Thanks a lot. I just wasn't able to see it, even I compared it with the SAP documentation

(http://help.sap.com/saphelp_nw04/helpdata/de/43/65d4dab39b0398e10000000a1553f6/frameset.htm).

points are given..

Answers (3)

Answers (3)

bhavesh_kantilal
Active Contributor
0 Kudos

Hi,

Like pointed out , this is how the strucutre should be.

<?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>

- <access>

<lastname />

</access>

- <key>

<email compareOperation="LIKE">test@test.de</email>

</key>

<b></TABLENAME></b>

</STATEMENT>

</ns0:MT_User_CMDB_request>

Take a look at my blog for more info,

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Regards,

Bhavesh

agasthuri_doss
Active Contributor
0 Kudos

Hi,

1) Kindly check whether the Table has LAST NAME field.

2) If so see whether the FIELD LAST NAME made Mandatory

one.

3) As Martin Mentioned check whethere the value is

available for the FIELD LAST NAME,

4) The LAST NAME field might be mandatory one in the

JAVA code you are using .

Regards

Agasthuri Doss

Former Member
0 Kudos

Is this not the problem.

'key element 'lastname' contains no values'