Skip to Content
author's profile photo Former Member
Former Member

ask again, jdbc response

I designed process to figure out how to get the records count of jdbc response.

after step send db request with synchronize mode, there is a transformation step to get count.(mapping with count function to rows of DB response). The result is always is 0.

But when I add a send step, which send db response message to file, I can see all the response content.

I don't know why.

How could I get the records count of DB response?

Thank you very much.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 07:25 AM

    you need to correlate the message

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      not understand you.

      DB response is this:

      <?xml version="1.0" encoding="UTF-8"?>
      <ns0:jdbc_req_response xmlns:ns0="http://aaa.com/jdbc_syn">
      <ExecuteStatement1_response>
      	<row>
      		<LIBID>2001</LIBID>
      		<LIBNAME>Zoral</LIBNAME>
      		<LIBADDRESS>Shanghai</LIBADDRESS>
      	</row>
      	<row>
      		<LIBID>2001</LIBID>
      		<LIBNAME>Zoral</LIBNAME>
      		<LIBADDRESS>Shanghai</LIBADDRESS>
      	</row>
      	<row>
      		<LIBID>2001</LIBID>
      		<LIBNAME>Zoral</LIBNAME>
      		<LIBADDRESS>Shanghai</LIBADDRESS>
      	</row>
      	<row>
      		<LIBID>2001</LIBID>
      		<LIBNAME>Zoral</LIBNAME>
      		<LIBADDRESS>Shanghai</LIBADDRESS>
      	</row>
      ...
      </ExecuteStatement1_response>
      </ns0:jdbc_req_response>
      

      I use count function :

      row ->count ->size. But got 0.

      It is one message, why I need correlation?

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 07:30 AM

    Make sure that you are passing "rows" node to the count function.

    Regards

    Shailesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 08:48 AM

    Thanks for all your effort.

    I just find it is my fault.

    define wrong message type name.

    for example for db request message is jdbc_rep, the response message must be jdbc_req_response

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.