PI JDBC sender Adapter

[mohit_verma1]

I am using pi jdbc sender adapter.

i have wrote query which is picking data.

-------------------

<row>
<WSEQNR>9975084</WSEQNR>
<WDATE>2013-11-21 00:00:00.0</WDATE>
<WTIME>1900-01-01 13:13:43.0</WTIME>
<WSTAT>1</WSTAT>
<WMESSND>732033718364 3 </WMESSND>
</row>

i have wroten one join query which is picking a lot of records

and after picking it is updating WSTAT field 2

so every time

pi is picking new record which have value 1

now issue is that

once PI is picking bulk data

for example 100 records at one time

if there is any one record fails in mapping all data is stucked in PI

so i need to process 1 record at a time.

How to achieve it.

Regards

Mohit

[Former Member · Accepted solution]

Hi,

There is no option to set that in PI...simplest is ensure the mapping condition in PI works fine for those cases and do a reprocessing from PI...

Else you have to fine tune your select or Join query to pick only one record for processing but again this can be performance bottleneck if there are huge records to be processed...

HTH

Rajesh

[Former Member]

Hi Mohit

If your message is failing in mapping because of some empty fields, then you can check this option in sender adapter so that the message will not contain any empty field tags

[mohit_verma1]

Hi Indrajeet ,

reason of failure is :

There is some un- printable charters coming from database and due to one record having error , all messages sucked in PI,

Requirement is to process one record at a time 

[iaki_vila]

Hi Mohit,

It depends about your DB system, because you can construct a SQL to restrict the number of values retrieved. The command can be different or simply dont exist depending of your DB vendor.

Check this Dheeraj Kumar's blog

Regards