Skip to Content
0
Former Member
Jan 15, 2008 at 03:10 PM

Problem mapping response of JDBC receiver adapter

18 Views

hi everybody,

I have the following problem. I want to retrieve data from Oracle DB. I execute the following sentence:

"Select count(*) from X". I'm doing that by means of action=SQL_QUERY. The response is something like that:

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

<ns0:MT_WM02_request_bbdd_count_response xmlns:ns0="urn:xxx-com:xi:xxx_WM">

<STMT_response>

<row>

<COUNT()>32</COUNT()>

</row>

</STMT_response>

</ns0:MT_WM02_request_bbdd_count_response>

The problem is that I can't map the response because the Integration Builder doesn't allow to develop this kind of element on the Data Type. I mean <COUNT()>. The symbols '(' and '' are not permitted.

How can I solve the problem?

Thanks in advance,

Regards

Carlos