on 07-23-2008 8:18 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Make sure that you are passing "rows" node to the count function.
Regards
Shailesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you need to correlate the message
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.