Rows Are Getting Duplicated in Multiple Resultset

[nmorado]

I am connecting to DB2 in linux using DB2 driver 9.x

Intermittently, we noticed that for a stored proc call with multiple resultsets, rows are getting duplicated after each call. We tried calling the same proc using a standalone app without using spring and the results do not show this weird behavior.

Has anyone run into this issue before?

Any ideas?

Thanks.

[posta07]

I can't personally recall seeing that behavior, but if you post the relevant snippets of your applicationContext and the calls in your data access layer, we might be able to help more?

[nmorado]

Just an additional info, this problem does not seem to happen using DB2 driver 8.x. This happens only in 9.x

It looks to me like it has something to do with spring's interaction with the driver? Because calling stored proc without spring on the same driver works fine.