Regards,<br />Sourin.
Regards,<br />Sourin.
Regards, Rene Larsen
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.
Regards,<br />Sourin.
OCUP UML fundamental and ITIL foundation
Originally posted by Jan Cumps:
Have you tried to use PreparedStatement.setDate() in stead of setString?
[ October 21, 2008: Message edited by: Jan Cumps ]
Regards,<br />Sourin.
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.
OCUP UML fundamental and ITIL foundation
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Originally posted by Jeanne Boyarsky:
Sourin,
In the future, please "reply" rather than "edit" when changing code. This allows the conversation to still make sense later.
Regards,<br />Sourin.
Originally posted by Sourin K. Sen:
Hi Jeanne,
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.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
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.
Regards,<br />Sourin.
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime. |