This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes query issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "query issue" Watch "query issue" New topic

query issue

giuseppe D'Amico

Joined: Oct 04, 2011
Posts: 5
HI, I have a servlet that performs two differents query to a mysql db in function of the task,so only one at a time is used but one after the other in very fast sequence, each of them return a json, I have two identical methods parameters_list and potentials_list, but only parameters_list works properly the second one obtain from mysql an empty resultset, I can not figure why. Here it is the relevant code for the two methods:
Parameters_list is the working one

and the code for potentials_list that does not work

both methods
use a third one for json encoding

the two methods are the same apart the query and the key I use for the json to return, so do not understand whi potential_list obtain a void resultSet in queryDb4Potentials, I wish someone can help me,
thanks in advance
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33132

What do you mean by "doesn't work." Does it throw an exception or just not return any data?

Also, there is a lot of code here. Could you try replying to this post by just showing what is different between the two examples?

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Abhinav Kansal

Joined: Jun 25, 2010
Posts: 5
Did you ran the query independently and saw the results? However the code looks alright.

I'm not sure why you have used two different methods for the same logic. I would suggest to modularize these methods and try running the core logic within a single method. To me, it just seems to be a problem with too much code duplication rather than some technical issue.
giuseppe D'Amico

Joined: Oct 04, 2011
Posts: 5
Thanks for your reply, I solved, just a stupid mistake.
I agree. Here's the link:
subject: query issue
It's not a secret anymore!