Sender JDBC reading all entries in blocks

[Former Member]

Hi guys,

Is it possible to set the Sender JDBC adapter (Oracle DB) to read all the table entries in blocks of i.e 10k and 10k until the end? More or less like Sender file adapter does.

Thanks in advance,

Ricardo.

[Former Member · Accepted solution]

Hi,

you could use the Sender JDBC adapter, but the datbase tables are based on no of rows. So with JDBC sender adapter you could restrict the no of lines to be read at a time.

You could achive this with the index in select query or may be you could call stored procedure to apply more cmplex logics.

Refer

Tips and Tutorial for Sender JDBC Adapter

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

Thanks

Swarup

[Former Member]

Thank you all

regards,

Ricardo.

[Former Member]

Hi Ricardo !

I suggest to estimate an average number of rows that belongs to your expected amount of data in kb, and then use the JDBC sender to retrieve N rows via specific SELECT commands like LIMIT or TOP and then use the "UPDATE" statement to mark this records as read to not retrieve them later again.

Regards,

Matias.

[Former Member]

Hi,

some links on JDBC.

JDBC ADAPTER

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

Phani