Exactly what is it that you are trying to avoid? If you don't want it
to create new objects in the loop then just remove the code.
Colin
Please don't top post, it makes it difficult to follow the thread.
Insert your reply at appropriate points in previous message. Thanks.
> Thanks for the reply.
>
> Exactly what going on here is now,after the execution of one insertion
> some amount of data will insert, around 172 rows
Is that what you expect or is that part of the problem?
>, but after i truncate the
> tables
What do you mean by truncate the tables? Do you mean you have removed
all the rows?
>, again when i execute that operation, the row count starting from
> 173
If there are still records in the database then you have not removed them.
>... i think that happens of new object creation for each transaction...
> Also i want to know... how to do the one time object creation for all
> insertion in that code...?
Sorry, I still don't understand exactly what you want. Please try and
write very carefully a bit at a time exactly what happens and what you
are want to happen.
Colin
Thanks for the reply.Exactly what going on here is now,after the execution of one insertion some amount of data will insert, around 172 rows, but after i truncate the tables, again when i execute that operation, the row count starting from 173... i think that happens of new object creation for each transaction...
Also i want to know... how to do the one time object creation for all insertion in that code...?
Yes, that is the way it works. If you want anything different I
think you will have to put a column in the database (sequence for
example) and manage it yourself. Though I think it may be possible to
override the numbering system but I would not recommend it.
Did you not understand my request about top posting?
Colin