ask again, jdbc response

[Former Member]

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.

[Former Member]

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

[Former Member]

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

Regards

Shailesh

[Former Member]

I'm pretty sure.

[Former Member]

you need to correlate the message

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