Originally posted by Paul Clapham:
And you're assuming from that line of code that the result set was empty? That's a bad assumption. The getFetchSize() method doesn't return anything like the number of rows which the result set will return if you ask it. Read its documentation again, more carefully this time. Also note that there's a setFetchSize() method; that would make no sense if getFetchSize() returned the number of rows.
Originally posted by Jan Cumps:
Have you tried to use PreparedStatement.setDate() in stead of setString?
[ October 21, 2008: Message edited by: Jan Cumps ]
You changed your post so much that we don't see the issue anymore. The SQL querythat you used for the Statement and Prepared Statement are gone.
I suppose I have rectified the errors from my post now.
Originally posted by Jeanne Boyarsky:
In the future, please "reply" rather than "edit" when changing code. This allows the conversation to still make sense later.
Originally posted by Sourin K. Sen:
It really doesnt matters with my current post as this is the exact same code after editing which is working on my local machine but not on the production server.
Originally posted by Shailesh Chandra:
You know when few days back when I came to answer this post i could not even find the actual problem because you have changed your code number of times.