SQLServerException

I am getting a SQLServerException:The statement must be executed before any
results can be obtained. The statement must be executed before any results
can be obtained. randomly when doing an insert of a table and needing back
the IDENTITY field. It seems to be when server is under load. I have been
trying to track down the conditions on when this error gets thrown. Any
ideas??

Thx!

On Aug 4, 2:53 pm, kdenning
wrote:
> I am getting a SQLServerException:The statement must be executed before any
> results can be obtained. The statement must be executed before any results
> can be obtained. randomly when doing an insert of a table and needing back
> the IDENTITY field. It seems to be when server is under load. I have been
> trying to track down the conditions on when this error gets thrown. Any
> ideas??
>
> Thx!

What's the chance you're using the executeQuery() call to do a non-
query,
such as an update/insert/delete? Is your code being run in a
multithreaded
environment, with the chance that multiple threads may be stepping on
each other's JDBC objects? Is the statement variable being
overwritten?
Joe Weinstein at Oracle