Hi Ranchers.
I am not sure is this the right forum for this question.
I am trying to come up with a logic for a small utility. Bascially I need to run a java program that will call a Stored Procedure to insert records
into a table from a text file which has several hundred rows. If the rows are being appended to the text file everytime to the existing rows how can I know until which rowcounts I have updated last time to the database after the program runs.I mean if I have updated 1-100 row the first time how can I keep track so that I will start updating from the 101 row on the next run. Do you think I should keep an indicator which updates the text file so that next time I will know which rows have been updated. Or is there anyother mechanism to do this relatively easily.
Please advise. Thanks in advance.
Bhazee
I am not sure is this the right forum for this question.
I am trying to come up with a logic for a small utility. Bascially I need to run a java program that will call a Stored Procedure to insert records
into a table from a text file which has several hundred rows. If the rows are being appended to the text file everytime to the existing rows how can I know until which rowcounts I have updated last time to the database after the program runs.I mean if I have updated 1-100 row the first time how can I keep track so that I will start updating from the 101 row on the next run. Do you think I should keep an indicator which updates the text file so that next time I will know which rows have been updated. Or is there anyother mechanism to do this relatively easily.
Please advise. Thanks in advance.
Bhazee