I am running into an issue with a stored procedure call returning what appears to be cached data.

I am connecting to DB2 on an iSeries.

When I call the stored procedure I can put the procedure in debug and validate that the correct information is being retrieved and returned, but when I look at the values in debug on the Java side (running in eclipse 3.4) I am seeing cached data. I am sure the data is cached because I can manually change the data from one call to values that don't exist in the database, call the stored procedure and the values that I see are the values I manually entered.

If I clear the session after each individual transaction I then get the correct data. I would prefer not to clear the session for each transaction for performance reasons.

Any assistance would be appreciated.