Exception ORA-08103: object no longer exists on using setfetchsize of
Hirabenate
I'm using Hibernate. I need to fetch around 1000000 records and it will
cause timeout exception. So I'm using setfetchsize for 6000 records, so
that it will distribute the operation in multiple transactions each of
6000 records.
It will take around 21 hours to fetch all.
But meanwhile retrieving records if somebody deletes one of the record
which was to be fetched then I get ORA-08103: object no longer exists.
Now I want to skip that object which is deleted while retrieving. How can
I do this?
No comments:
Post a Comment