Nirmal Kumar<br />If you have to aim, aim for the moon. Even if you miss you will land among the stars
JDBC library - ojdbc14.jar (by sun)
When I hard code the String input and parameterize the int, the program works like a charm and gives me the desired result.
When I hard code the int input and parameterize the String poof ... it returns an empty result set.
Paul Sturrock wrote:
JDBC library - ojdbc14.jar (by sun)
Are you running a 1.4 JDK?
Using JDK1.5.0 update 22
When I hard code the String input and parameterize the int, the program works like a charm and gives me the desired result.
When I hard code the int input and parameterize the String poof ... it returns an empty result set.
I don't follow this. Can you show us your code?
Nirmal Kumar<br />If you have to aim, aim for the moon. Even if you miss you will land among the stars
Nirmal Kumar<br />If you have to aim, aim for the moon. Even if you miss you will land among the stars
-Abhishek
I came to this world on a Learner's License
Abhishek Ralhan wrote:Its all fine. I tried the code myself with all the possible ways.. it is just fine..
May be it would be a very trivial bug when you at last find it..
Nirmal Kumar<br />If you have to aim, aim for the moon. Even if you miss you will land among the stars
Anyways for now I have taken the ugly route ... string replacements
Paul Clapham wrote:It looks very easy to get confused between "t$dtyp" and "t$dpty" (yes, I know the column names are beyond your control). And I noticed that you used them in one order in one example and then later used them in the opposite order. Even more confusing.
Nirmal Kumar<br />If you have to aim, aim for the moon. Even if you miss you will land among the stars
Paul Sturrock wrote:The database will not make a difference. The driver may, but this is such basic stuff I would be amazed if a driver implementation had such glaring bugs in it - it would after all make that driver next to useless. That aside, I've used the Oracle drivers for years and never seen the same behaviour you are reporting. My guess is some error in your code logic - hard to say what that is because your code examples change each time you post them, though the versions you post will work just fine (I too, just tried your code and it works).
Anyways for now I have taken the ugly route ... string replacements
Nirmal Kumar<br />If you have to aim, aim for the moon. Even if you miss you will land among the stars