File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes query issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "query issue" Watch "query issue" New topic
Author

query issue

giuseppe D'Amico
Greenhorn

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
Marshal

Joined: May 26, 2003
Posts: 30776
    
157

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?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Abhinav Kansal
Greenhorn

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
Greenhorn

Joined: Oct 04, 2011
Posts: 5
Thanks for your reply, I solved, just a stupid mistake.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: query issue