Reliable row_count with a multithreaded java client

[Liepa Kuraite]

Hi, I have an application that calls the same procedure in multiple threads at approximatelly the same time. The procedure inserts rows in the same table (but with different information) for all threads. Is it safe to say that if I call row_count() inside the procedure right after INSERT statement it will get the affected row count for that statement for that thread? Or will it get the latest affected row count for the database in general (i.e. if some other threads were updating some other tables)?

Or maybe if I want to doublecheck how many rows were inserted I could increment some varable with every inserted row - would that be more reliable?

Thanks.