Fetching records in batches

[ashish_shah]

Hi Experts ,

In one application , i need to fetch the data in batches , some thing similar to the search criteri in ABAP for F4 value help .

I will be fetching data from oracle tables from JDBC connectors through EJBs.

So can you guys tell me is this possible in webDynpro to fetch the data in batches ?

Regards,

Ashish Shah

[Former Member]

Hi! ashish,

i think in JDBC API, we have API's to fetch the records in batches. you should use that Batch API.

regards,

Mithileshwar

[ashish_shah]

Hi Mithilieshwar ,

Can you provide me the name of the JDBC API ?

Ashish Shah

[Former Member]

Hi! ashish,

i checked that batch Update but using that batchUpdate you can only insert,update,delete records and create table,drop table.

you can't run select command in batch.

regards,

Mithileshwar

[former_member751941]

Hi Ashish,

Check the <b>executeBatch()</b> method of <b>Statement</b> class.

http://java.sun.com/j2se/1.3/docs/guide/jdbc/spec2/jdbc2.1.frame6.html

Regards,

Mithu