This content has been marked as final.
Show 2 replies
-
1. Re: A setMaxRows(0) is missing in PrepareStatementInPool imp
davidjencks Sep 7, 2001 8:02 AM (in response to dabder)Are you sure this is a good idea? You had to get the prepared statement and call setMaxRows on it, right? so why can't you call setMaxRows(0) when you are done? Is there some reason this doesn't work?
-
2. Re: A setMaxRows(0) is missing in PrepareStatementInPool imp
dabder Sep 7, 2001 5:44 PM (in response to dabder)I don't agree.
For instance :
// BEGIN
PrepareStatement ps1 = connection.prepareStatement();
ps1.setMaxRows(13);
....
ps1.close();
PrepareStatement ps2 = connection.prepareStatement();
/////////// END
Without patching the PrepareStatementInPool.close method, ps2 result will be limited to 13 rows. It's an
amazing thing, isn't it ?
I don't think that doing a ps1.setMaxRows(0) before close, is a good way .
When we create a new prepareStatement, the new PS must be independant. This same code works on BEA WL.