Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Problems with resultset being to large

Posted on 2004-09-21
8
Medium Priority
?
169 Views
Last Modified: 2010-03-31
We are running a query using jdbc, the total amount of records that could be returned are 100,000. Could this be a problem in our java code?
0
Comment
Question by:inzaghi
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 35

Accepted Solution

by:
girionis earned 600 total points
ID: 12111807
> We are running a query using jdbc, the total amount of records that
> could be returned are 100,000. Could this be a problem in our java code?

It depends what do you mean by a problem in your java code. Generally though no, it shouldn't be a problem.

0
 
LVL 86

Assisted Solution

by:CEHJ
CEHJ earned 200 total points
ID: 12111817
What are you thinking of?
0
 
LVL 37

Assisted Solution

by:zzynx
zzynx earned 200 total points
ID: 12111835
>> Could this be a problem in our java code?
If e.g. you keep all records in memory that could lead to memory problems
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:inzaghi
ID: 12111846
What I meant could an SQLException be thrown if the resultset from the query is to big
0
 
LVL 37

Expert Comment

by:zzynx
ID: 12111866
No
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 12111887
8-)
0
 
LVL 37

Expert Comment

by:zzynx
ID: 12111894
Thanks for accepting
(Fast as lightening)
0
 
LVL 35

Expert Comment

by:girionis
ID: 12111898
:)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Video by: Michael
Viewers learn about how to reduce the potential repetitiveness of coding in main by developing methods to perform specific tasks for their program. Additionally, objects are introduced for the purpose of learning how to call methods in Java. Define …
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
Suggested Courses

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question